Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 31:

  You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

  

  What is true concerning this configuration?

  A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which

  forwards the redo in turn to the Far_away physical standby database instance.

  B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

  C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.

  D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled

  E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

  Correct Answer: A

• Question 32:

  Attempting to start the observer raises an error:

  DGMGRL> start observer:

  DGM-16954: Unable to open and lock the Observer configuration file Failed.

  Identify two possible reasons for this error

  A. Fast-Start Failover is not yet enabled for this Data Guard configuration

  B. The observer configuration file is marked read-only.

  C. There is already an observer running for this Data Guard configuration.

  D. There is another observer running for a Data Guard configuration which uses the same observer configuration file

  E. The broker configuration has not yet been created.

  Correct Answer: BD

• Question 33:

  Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

  A. The primary database must have FORCE LOGGING enabled.

  B. The primary database must be in archive log mode

  C. A backup of the primary database must exist.

  D. The primary host and the proposed standby database host must run the same operating system.

  E. The primary database instance must be started using an SPFILE.

  F. The primary database must have flashback enabled

  Correct Answer: AB

• Question 34:

  You have a Data Guard Broker configuration called Somewhere' as shown: Which two are true about the output of this DGMGRL command?

  

  A. A far sync instance cannot have inconsistent properties because it has no database.

  B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

  C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.

  D. Any inconsistency reported is on an instance-specific basis.

  Correct Answer: CD

• Question 35:

  Examine the Data Guard configuration: Configuration Status: SUCCESS

  

  Which two are true?

  A. The observer must run on host ol5.example com and is currently not running.

  B. The observer will reinstate Sheep automatically after a failover, if required.

  C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.

  D. The observer will detect if the primary database is unable to accept new connections

  E. The former primary database will not be reinstated automatically alter a failover.

  Correct Answer: BE

• Question 36:

  You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:

  1.

  Data loss is not permitted.

  2.

  Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:

  1.

  It should be possible to apply designated patches with a minimum amount of downtime.

  2.

  Upgrading to a new database release should be performed with the least possible amount of downtime.

  3.

  New application software releases should be tested against an exact and up-to-date replica of the primary database.

  Which configuration meets these requirements with the fewest databases?

  A. a primary database with three physical standby databases

  B. a primary database with one logical and two physical standby databases

  C. a primary database with one logical standby database

  D. a primary database with one logical and one physical standby database

  E. a primary database with two physical standby databases

  F. a primary database with one physical standby database

  Correct Answer: D

• Question 37:

  Which two statements are true for Data Guard environments with multi-tenant databases?

  A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.

  B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.

  C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.

  D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database

  E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

  Correct Answer: AD

• Question 38:

  Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

  A. Backups of data files taken on the primary database may be restored on a physical standby database.

  B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.

  C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.

  D. Backups of control files taken on a physical standby database may be restored on the primary database.

  E. Backups of data files taken on a physical standby database may be restored on a pnmary database.

  F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

  Correct Answer: CEF

• Question 39:

  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.

  Correct Answer: C

• Question 40:

  Which two are true about rolling release upgrades in a Data Guard environment?

  A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure

  B. A physical standby database can be converted to a logical standby database temporarily.

  C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

  D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

  E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

  Correct Answer: BD