1z0-066 Free Practice Test

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?

1. 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.
2. B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
3. 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.
4. D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Correct Answer: C

On your logical standby database, you specified these rules:
<>

1. A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
2. B. it succeeds but the SQL Apply fitters are not deleted.
3. C. It deletes both the SQL Apply filters.
4. D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
5. E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Correct Answer: D

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

1. A. Recover the datafile by using the RMAN RECOVER DATAFILE command
2. B. Restart the redo apply.
3. C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
4. D. Stop the redo apply.
5. E. Recover the database by using the RMAN RECOVER DATABASE command.

Correct Answer: CDE

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

1. A. a remote physical standby database with RedoRoutesvia a far sync instance
2. B. a snapshot standby database with synchronous redo transport
3. C. a physical standby database with real-time query enabled
4. D. a logical standby database
5. E. a read mostly implementation of a physical standby database

Correct Answer: BC

Which three factors can influence the rate of redo apply on a physical standby database?

1. A. the network latency between the primary and standby databases
2. B. the number of archiver processes on the standby database
3. C. the number and size of standby redo logs on the primary database
4. D. the rate of redo generation on the primary database
5. E. the number and size of standby redo logs on the standby database

Correct Answer: ABE