Free Oracle 1Z1-066 Exam Dumps Questions & Answers

Which three statements are true about snapshot standby databases? (Choose three.)

• A.A snapshot standby database can have Real-Time Query enabled.
• B.If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C.Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D.Snapshot standby databases may be used for rolling release upgrades.
• E.A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

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.)

• A.Dogs will be a logical standby database.
• B.Cats will be an enabled logical standby database.
• C.Sheep will be the primary database.
• D.Cats will be a disabled logical standby database.
• E.Dogs will be a physical standby database.

Which three statements are true about snapshot standby databases? (Choose three.)

• A.Tablespaces can be created.
• B.The broker may be used to fail over to a snapshot standby database.
• C.Tablespaces can be dropped.
• D.A logical standby database can be converted into a snapshot standby database.
• E.Tables can be dropped.

Which four are true about DGMGRL show command? (Choose four.)

• A.It can be used to show properties of a far sync instance.
• B.It can be used to show properties of a pluggable standby database.
• C.It can be used to show properties of a primary container database.
• D.It can be used to show properties of a pluggable primary database.
• E.It can be used to show Fast Start Failover properties.
• F.It can be used to show instance-specific properties for a RAC database.

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep- Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?

• A.The redo transport mode is set to ASYNC for the standby database Sheep.
• B.The redo transport mode is set to ASYNC for both standby databases.
• C.Cats is a snapshot standby database.
• D.The redo transport mode is set to ASYNC for the standby database Cats.