1Z0-066 Online Practice Questions and Answers

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?

A. Archive logs on the primary database may be deleted once they are applied on all standby databases.

B. Archive logs on the primary database may be deleted once they are shipped 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 backed up at least once on the remote physical standby database.

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

E. Archive logs on the primary database may be deleted once they are archived locally to disk.

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 in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration

B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration

C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.

D. The target database should be MOUNTED and DGMGRL should be connected to the target database

E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Which three statements are true about Data Guard configurations?

A. All databases in one Data Guard environment must have the same database name.

B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.

C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

D. When using the Data Guard Broker, an spfile is not required.

E. Up to 30 physical standby databases may exist within one configuration.

F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Examine this query and its output: Which are true?

A. The observer is not connected to the database on which the query was executed.

B. Cats is a bystander database.

C. The observer is connected to the database on which the query was executed.

D. The observer is currently running on o17.example com

E. The observer is not running, but should run on o17 example.com.

Examine the Data Guard configuration: Identify two possible reasons for this error.

A. The FastStartFailoverTarget property is not set on Sheep.

B. The FastStartFailoverTarget property is not set on Dogs.

C. The FastStartFailoverTarget property is not set on DogsFSI.

D. The LogXptMode property is set to ASYNC on Dogs.

E. The RedoRoutes property is not set on Dogs

F. The RedoRoutes property is not set on DogsFSI

Examine the Data Guard configuration: Which three will be true after a successful failover to Cats?

A. Sheep will be in the disabled state.

B. Sheep will be in the enabled state.

C. Dogs will be in the disabled state and has to be manually reinstated

D. The configuration will be in Maximum Performance mode.

E. The configuration will be in Maximum Availability mode.

Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered

C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

D. backups of data files taken on the logical standby database, if not connected to a recovery catalog

E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to define connectivity to the primary database instance.

Which will automatically redirect clients to the new primary database in case of a switchover or failover?

A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.

B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.

C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.

D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

A. if the CACHE option is set then the size of the cache must be at least 100

B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary

C. Their usage will always have a performance impact on the primary database.

D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small

E. They must have the NOORDER and CACHE options set.

Examine the Fast-start configuration

Oracle Error Conditions: (none) Which three are true?

A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

B. An automatic failover will be initiated even if the target standby database lags behind the primary

C. The observer is running

D. a failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database

E. The configuration operates in Maximum Availability mode

F. The configuration operates in Maximum Performance mode