Online Access Free 1z0-497 Practice Test

Which statement about Oracle patches is false?

• A.Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.
• B.Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
• C.Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.
• D.Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
• E.Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

Which two statements about Data Recovery Advisor are true?

• A.Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
• B.Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CD
• C.Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
• D.You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

• A.cluster
• B.materialized view
• C.mapping table
• D.database link

Which two are client-side components of Oracle Data Guard Broker?

• A.Oracle Enterprise Manager Cloud Control
• B.Oracle Data Guard monitor
• C.Oracle Data Guard Broker Manager
• D.Oracle Data Guard command-line interface (DGMGRL)

Which is the default isolation level in Oracle Database 12c?

• A.serializable
• B.read uncommitted
• C.read-only
• D.read committed