1z0-066 practice test

1. Question 1 · 1

   Examine this command executed on a physical standby database to transition it to a logical standby database: SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby; Which statement is true regarding the execution of this command?

   Choose one answer.

   • FLASHBACK is automatically enabled when transitioning to the logical standby database.
   • The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
   • Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
   • SQL apply is automatically started when transitioning to the logical standby database.
   • It will automatically start redo apply.

2. Question 2 · 1

   You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command: DGMGRL> CREATE CONFIGURATION ‘DGConfig’ AS > PRIMARY DATABASE IS ‘PROD’ > CONNECT IDENTIFIER IS PROD; Which three statements are true regarding the execution of the command? (Choose three.)

   Choose all answers that apply.

   • The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
   • The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
   • The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
   • The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
   • The PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.
   • The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.

3. Question 3 · 1

   Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)

   Choose all answers that apply.

   • The configuration transport mode may be modified while the entire configuration is disabled from broker management.
   • Database properties may be modified when that database is disabled from broker management.
   • A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
   • The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
   • The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.

4. Question 4 · 1

   Examine the Data Guard configuration: DGMGRL> show configuration; Configuration Animals - Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- (*) Physical standby database cats- Physical standby database Fast-Start Failover: ENABLED - Configuration Status: SUCCESS - What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

   Choose one answer.

   • The switchover succeeds but Dogs need to be reinstated.
   • The switchover succeeds but Fast-Start Failover is suspended.
   • The switchover succeeds and Cats become the new failover target.
   • The switchover succeeds and Dogs become the new failover target.
   • It results in an error indicating that a switchover is not allowed.

   Read explanation

   Incorrect Answers: E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.

5. Question 5 · 1

   A Data Guard environment has this configuration and these attributes: 1. The primary database prima is in the local region. 2. A physical standby database physt1 is in the local region. 3. A physical standby database physt2 is in a remote region. 4. The primary ships redo to physt1. 5. physt1 ships redo physt2. 6. physt1 and physt2 have Real-Time Query enabled. A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

   Choose all answers that apply.

   • The sequence is usable on physt1 and physt2.
   • The sequence is usable on physt1 but not usable on physt2.
   • The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.
   • physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
   • physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

6. Question 6 · 1

   Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

   Choose all answers that apply.

   • FLASHBACK DATABASE must be enabled on the physical standby database.
   • There must be connectivity between the primary and the physical standby database.
   • FLASHBACK DATABASE must be enabled on the primary database.
   • The physical standby database must have Real-Time Apply enabled.
   • The logical standby database must have Real-Time Query enabled.

7. Question 7 · 1

   Examine the Data Guard configuration: DGMGRL > show configuration: Configuration Animals - Protection Mode: MaxAvailability Databases: cats- Primary database dogs-Physical standby database sheep-Logical standby database Fast-Start Failover: DISABLED - Configuration Status: SUCCESS - Which three will be true after a switchover to Dogs?

   Choose all answers that apply.

   • Sheep will be an enabled logical standby database.
   • Cats will be an enabled physical standby database.
   • Dogs will be the primary database.
   • Sheep will be a disabled logical standby database.
   • Cats will be a disabled physical standby database.

8. Question 8 · 1

   Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

   Choose all answers that apply.

   • They are required on a logical standby for real-time apply.
   • They are required only for synchronous redo transport.
   • Only standby databases can write redo to them.
   • It is recommended to have them on the primary database.
   • They are required on a physical standby for real-time apply.
   • The LGWR process writes to them on a standby database.

9. Question 9 · 1

   You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control. Which two are true about this change?

   Choose all answers that apply.

   • If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
   • The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
   • Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
   • Fast start failover can be enabled when making the chance.
   • Real time apply will be automatically turned on.

10. Question 10 · 1

    A customer asks you to propose the most appropriate solution for this set of requirements: 1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss. 2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes. 3. Developers may need to test occasionally on a copy of the live database. You have to already confirmed that there are no unsupported data types on the primary database. Which two solutions would you recommend?

    Choose all answers that apply.

    • a remote physical standby database with RedoRoutes via a far sync instance
    • a snapshot standby database with synchronous redo transport
    • a physical standby database with real-time query enabled
    • a logical standby database
    • a read mostly implementation of a physical standby database

11. Question 11 · 1

    Which two statements are true about Real-Time Query?

    Choose all answers that apply.

    • Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.
    • Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
    • Real-Time Query sessions can be connected to a Far Sync instance.
    • Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
    • A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

    Read explanation

    If a license for the Oracle Active Data Guard option has been purchased, Redo Apply can be active while the physical standby database is open, thus allowing queries to return results that are identical to what would be returned from the primary database. This capability is known as the real-time query feature. Incorrect Answers: A: If STANDBY_MAX_DATA_DELAY is set to 0, a query issued to a physical standby database is guaranteed to return the exact same result as if the query were issued on the primary database, unless the standby database is lagging behind the primary database, in which case an ORA-3172 error is returned. Note: The STANDBY_MAX_DATA_DELAY session parameter can be used to specify a session-specific apply lag tolerance, measured in seconds, for queries issued by non-administrative users to a physical standby database that is in real-time query mode. This capability allows queries to be safely offloaded from the primary database to a physical standby database, because it is possible to detect if the standby database has become unacceptably stale.

12. Question 12 · 1

    On your logical standby database, you specified these rules: SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> DML, - SCHEMA_NAME => HR, - OBJECT_NAME=> EMP_NEW); SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> DML, - SCHEMA_NAME => HR, - OBJECT_NAME=> EMP_OLD); After completion of the weekend batch cycle you attempt to delete the SQL Apply filters: SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> DML, - SCHEMA_NAME => HR, - OBJECT_NAME=> EMP%); Which is true regarding the execution of the UNSKIP procedure?

    Choose one answer.

    • It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.
    • It succeeds but the SQL Apply filters are not deleted.
    • It deletes both the SQL Apply filters.
    • It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.
    • It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

13. Question 13 · 1

    Examine the Data Guard configuration after an accidental switchover to Sheep: DGMGRL> show configuration; Configuration Animals - Protection Mode: MaxAvailability Databases: sheep- Primary database dogs- Logical standby database cats- Physical standby database (disabled) ORA-16795: the standby database needs to be re-created Fast-Start Failover: DISABLED - Configuration Status: SUCCESS - Which three will be true after a switchover to Dogs?

    Choose all answers that apply.

    • Sheep will be a disabled logical standby database.
    • Sheep will be an enabled logical standby database.
    • Cats will be a disabled physical standby database that can be manually enabled.
    • Cats will be an enabled physical standby database.
    • Dogs will be the primary database.

14. Question 14 · 1

    Examine the Data Guard configuration: Properties: FastStartFailoverThreshold = ‘30’ OperationTimeout = ‘30’ TraceLevel = ‘USER’ FastStartFailoverLagLimit = ‘30’ CommunicationTimeout = ‘180’ ObserverReconnect = ‘10’ FastStartFailoverAutReinstate = ‘TRUE’ FastStartFailoverPmyShutdown = ‘TRUE’ BystandersFollowRoleChange = ‘all’ ObserverOverride = ‘FALSE’ Fast-Start Failover: ENABLED - Threshold: 30 seconds - Target: dogs - Observer: prutser6.example.com - Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE - Auto-reinstate: TRUE - Observer Reconnect: 10 seconds - Observer Override: Configuration Status: SUCCESS - What happens if you issue “failover to dogs;” at the DGMGRL prompt while connected to Dogs?

    Choose one answer.

    • The failover succeeds, Sheep becomes the new target standby database, and Cats is automatically reinstated.
    • The failover succeeds and Cats is automatically reinstated.
    • The failover succeeds and Cats is left running.
    • The failover succeeds and Cats is terminated.
    • It results in an error indicating that a failover is not allowed.

Paid access to all 14 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.