Oracle Database 12c: Data Guard Administrator - 1Z1-066 Exam Practice Test

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?
Correct Answer: D
Which three are true about using Flashback database through role transitions in a Data Guard environment?
(Choose three.)
Correct Answer: A,C,D
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)
Correct Answer: C,D
Explanation: (Only visible to ExamsLabs members)
Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
sheep Logical standby database
cats Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Sheep? (Choose three.)
Correct Answer: A,B,E
Explanation: (Only visible to ExamsLabs members)
Your Data Guard environment has one physical standby database using Real-Time Query.
Two sequences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?
Correct Answer: C
Examine this list of possible steps:
1.Raise the compatibility level on both databases.
2.Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?
Correct Answer: A
Explanation: (Only visible to ExamsLabs members)
Which three are benefits of using the Data Guard Broker to manage standby databases? (Choose three.)
Correct Answer: B,E,F
Explanation: (Only visible to ExamsLabs members)
After converting your physical standby database to a logical database, you get an error:
DGMGRL> show configuration
Configuration proddg
Protection Mode: MaxPerformance
Databases:
prod Primary database
prodsby Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?
Correct Answer: D
Explanation: (Only visible to ExamsLabs members)
Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
------------------ --------------------------
BYSTANDER cats
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------------------------- -------------------------
NO ol7.example.com
Which are true?
Correct Answer: E
Explanation: (Only visible to ExamsLabs members)
Which four are true about DGMGRL show command? (Choose four.)
Correct Answer: A,C,D,E
Explanation: (Only visible to ExamsLabs members)