1Z0-066 by Oracle Actual Free Exam Q&As

Question 1

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?

A. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name. B. Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name. C. Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name. D. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

Discussion 0

Correct Answer: C Vote an answer

Question 2

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

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

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 3

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 A C. Option B D. Option C

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)

A. Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled. B. An SPFILE must be used for all the databases in a configuration. C. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker. D. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker. E. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.

Discussion 0

Correct Answer: B,C Vote an answer

Question 5

Which three are among the various tasks performed by the Data Guard Monitor (DMON) process? (Choose three.)

A. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required. B. communicating with DMON processes in other database instances that are part of the broker configuration C. performing role transitions when switchover requests are made D. activating role-based services appropriately in the various database instances of the configuration, based on the database role E. maintaining information about all members of the broker configuration in binary configuration files

Discussion 0

Correct Answer: B,C,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)

A. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered. B. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database. C. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database. D. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database. E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database? (Choose three.)

A. Switch to the data file copy using the RMAN SWITCH command. B. Catalog the data file copy for RMAN to use on the primary database for restore. C. Connect to the primary database as the AUXILIARY. D. Connect to the primary database as the TARGET. E. Back up the data file as copy on the standby host to a location on the standby host. F. Back up the data file as copy on the standby host to a location on the primary host.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

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