1Z0-066 試験問題を無料オンラインアクセス

You must manually reinstate a database using DGMGRL.
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A.The target database should be MOUNTED and DGMGRL should be connected to the target database.
• B.The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration.
• C.The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database.
• D.The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration.
• E.The target database should be MOUNTED and DGMGRL should be connected to the primary database.

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?

• A.Option D
• B.Option B
• C.Option A
• D.Option C

You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration? (Choose three.)

• A.Archive logs on the primary database may be deleted once they are archived locally to disk.
• B.Archive logs on the primary database may be deleted once they are applied on all standby databases.
• C.The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
• D.Archive logs on the primary database may be deleted once they are shipped on all standby databases.
• E.The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

Which two statements are true about Real-Time Query? (Choose two.)

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

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment? (Choose two.)

• A.Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• B.Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.
• C.Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.
• D.Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.
• E.Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.