Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 121:

  You are licensed to use Oracle Active Data Guard

  Which two statements are true after enabling block change tracking on a physical standby database?

  A. it allows fast incremental backups to be offloaded to the physical standby database

  B. It starts the CTWR process on the physical standby database instance

  C. it allows fast incremental backups to be taken on the primary database.

  D. It starts the RVWR process on the physical standby database instance.

  E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.

  F. It starts the CTWR process on the primary database instance.

  Correct Answer: AB

• Question 122:

  Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

  A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners

  B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

  C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE

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

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

  Correct Answer: AB

• Question 123:

  Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database

  sheep- (*) Physical standby database cats- Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

  A. The switchover succeeds but Dogs need to be reinstated

  B. The switchover succeeds but Fast-Start Failover is suspended.

  C. The switchover succeeds and Cats become the new failover target.

  D. The switchover succeeds and Dogs become the new failover target

  E. it results in an error indicating that a switchover is not allowed.

  Correct Answer: D

• Question 124:

  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?

  A. a remote physical standby database with RedoRoutesvia a far sync instance

  B. a snapshot standby database with synchronous redo transport

  C. a physical standby database with real-time query enabled

  D. a logical standby database

  E. a read mostly implementation of a physical standby database

  Correct Answer: BC

• Question 125:

  You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

  A. The standby database must have supplemental logging enabled.

  B. The primary database must have FORCE LOGGING enabled

  C. The DG_BROKER_START parameter must be set to TRUE for both database instances.

  D. The primary database must have supplemental logging enabled.

  E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

  Correct Answer: BC

• Question 126:

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

  A. the network latency between the primary and standby databases

  B. the number of archiver processes on the standby database

  C. the number and size of standby redo logs on the primary database

  D. the rate of redo generation on the primary database

  E. the number and size of standby redo logs on the standby database

  Correct Answer: ABE

• Question 127:

  Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals Protection Mode: MaxAvailability Databases: Sheep- Primary database Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled) ORA-16661: the standby database needs to be reinstated Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration: DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs

  Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO Stuck Archiver NO Datafile Offline YES Oracle error Conditions ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over: SQL> select last_failover_reason from v$fs_failover_stats; LAST_FAILOVER_REASON ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

  A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.

  B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.

  C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep

  D. Open Dogs and let the broker reinstate Dogs automatically.

  Correct Answer: C

• Question 128:

  Examine the Data Guard configuration:

  

  Which three will be true after a switchover to Sheep?

  A. Dogs will be an enabled logical standby database.

  B. Sheep will be the primary database.

  C. Cats will be a disabled physical standby database.

  D. Dogs will be a disabled logical standby database

  E. Cats will be an enabled physical standby database.

  Correct Answer: ABE

• Question 129:

  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?

  A. Connect to the primary database as the AUXILIARY.

  B. Catalog the data file copy for RMAN to use on the primary database for restore.

  C. Back up the data file as copy on the standby host to a location on the standby host.

  D. Switch to the data file copy using the RMAN SWITCH command.

  E. Back up the data file as copy on the standby host to a location on the primary host

  F. Connect to the primary database as the TARGET.

  Correct Answer: ABD

• Question 130:

  Which three are always benefits of using a logical standby database?

  A. it can be used for database rolling release upgrades

  B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.

  C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.

  D. It can be used for reporting workloads requiring additional indexes or materialized views or both.

  E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

  F. it can be used for testing patches without affecting the primary database.

  Correct Answer: CDF