Oracle Oracle Certifications 1Z0-066 Questions & Answers

• Question 111:

  Which four factors can influence the rate of SQL apply on a logical standby database?

  A. the size of the undo tablespace on the logical standby database

  B. the number of full table scans performed by SQL apply

  C. the number of coordinator processes on the standby database instance

  D. the size of the shared pool

  E. the number of APPLIER processes

  F. the number of PREPARER processes

  Correct Answer: BDEF

• Question 112:

  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.

  Correct Answer: A

• Question 113:

  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

  Correct Answer: ADE

• Question 114:

  On your logical standby database, you specified these rules: Which is true regarding the execution of the UNSKIP procedure?

  

  A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter

  B. it succeeds but the SQL Apply fitters are not deleted.

  C. It deletes both the SQL Apply filters.

  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

  E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

  Correct Answer: D

• Question 115:

  Which three statements are true about Far Sync instances?

  A. The Data Guard Broker must be used to deploy and manage Far Sync instances.

  B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.

  C. A primary database can ship redo directly to multiple Far Sync instances.

  D. They use as spfile, a standby controlfile, and standby redo logs.

  E. They work with any protection level.

  Correct Answer: ABD

• Question 116:

  A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows

  As a result of this, you decide that an upgrade may use logical standby databases.

  Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary?

  A. The upgrade always requires downtown until the upgrade of the logical standby is completed

  B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

  C. The upgrade always required downtime until the upgrade of the primary is completed

  D. Using manual upgrade, catupgr.sql needs to run on the primary database only.

  E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.

  F. Fast-Start Failover can be used to protect the primary database during the upgrade.

  Correct Answer: BE

• Question 117:

  Which four statements are true regarding SQL Apply filters for a logical standby database?

  A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

  B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands

  C. They can be used to stop SQL apply if it encounters an error.

  D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

  E. They can only be used to skip DML statements on a table

  F. They can be used to skip ALTER TABLE commands on a specific tables

  G. They can be used to skip CREATE TABLE commands

  Correct Answer: ACFG

• Question 118:

  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 ways to start the observer successfully

  A. Set the Observer Override property to TRUE before starting the observer

  B. Create a broker configuration and enable Fast-Start Failover before starting the observer

  C. Start the observer using a different observer configuration file.

  D. start the observer in a different working directory.

  E. Enable Fast-Start Failover before starting the observer

  Correct Answer: CD

• Question 119:

  Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?

  A. Real Time Query must be enabled on the primary database

  B. Real Time Query must be enabled on the physical standby database.

  C. |f a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.

  D. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved

  E. if a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.

  F. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

  Correct Answer: BCD

• Question 120:

  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