Oracle 1z0-066 Exam Dumps

Oracle Database 12c: Data Guard Administration

702 Reviews

Exam Code	1z0-066
Exam Name	Oracle Database 12c: Data Guard Administration
Questions	112 Questions Answers With Explanation
Update Date	04, 14, 2026
Price	Was : $81 Today : $45 Was : $99 Today : $55 Was : $117 Today : $65

Add To Cart

Demo Questions

Question # 1

Which three statements are true about snapshot standby databases? 

A. Tablespaces can be dropped.  
B. Tables can be dropped  
C. The broker may be used to fail over to a snapshot standby database.  
D. A logical standby database can be converted into a snapshot standby database.  
E. Tablespaces can be created.  

Show Answer

Question # 2

You administer a Data Guard environment consisting of a primary and three physicalstandby databases.One physical standby database is used for disaster recovery, one is used for reporting, andone is used as a replica for testing.The standby database used for testing is occasionally converted into a snapshot standbydatabase and then converted back to a physical standby.The physical standby database is the only standby that is a mandatory destinationThe broker configuration operates in MAXIMUM PERFORMANCE mode.Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated onthe primary database are not deleted before they are consumed appropriately on each ofthe standby databases, but which allows them to be deleted form the primary as soon as itis safe to do so?

A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY  
B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;  
C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;  
D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,  
E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;  

Show Answer

Question # 3

Which two statements are true about Real-Time Query? 

A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.  
B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
C. Real-Time Query sessions can be connected to a Far Sync instance. 
D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment. 
E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration

Show Answer

Question # 4

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. 

Show Answer

Question # 5

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.  

Show Answer

Question # 6

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

A. They are required on a logical standby for real-time apply  
B. They are required only for synchronous redo transport.  
C. Only standby databases can write redo to them.  
D. It is recommended to have them on the primary database.  
E. They are required on a physical standby for real-time apply.  
F. The LGWR process writes to them on a standby database.  

Show Answer

Question # 7

Your Data Guard environment consists of these components and settings:1. A primary database supporting an OLTP workload 2 A remote physical standbydatabase3. Real-time query is enabled4. The redo transport mode is set to SYNC.5. The protection mode is set to Maximum AvailabilityWhich two are true regarding the DelayMins Database Property for the standby database?

A. it can only be enabled for a configuration in Maximum Performance mode. 
B. It allows user errors on the primary to be recovered by using the physical standby database. 
C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
D. it can only be enabled for a configuration in Maximum Availability mode. 
E. It allows logical corruptions on the primary to be recovered by using the physical standby database. 
F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set. 

Show Answer

Question # 8

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. 

Show Answer

Question # 9

Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

A. a flash recovery area must be configured  
B. The database must be in MOUNT state.  
C. The database must be in ARCHIVELOG mode.
D. A far sync instance must be configured to flash back a standby when the primary has been flashed back
E. The Data Guard Broker must be used.  

Show Answer

Question # 10

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.  

Show Answer

Question # 11

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.  

Show Answer

Question # 12

You must configure an Oracle Data Guard environment consisting of:1. A primary database2 One Physical Standby Database3. One Logical Standby DatabaseYou must meet these requirements:1. Primary database availability should not be compromised by the availability of thestandby databases.2. Under normal operations, transactions executed on the primary database should notcommit before redo is written to disk on both the primary database and at least onestandby database.Which redo transport mode and which protection mode would you configure to meet theserequirements?

A. SYNC AFFIRM and Maximum Protection  
B. SYNC NOAFFIRM and Maximum Protection  
C. SYNC AFFIRM and Maximum Availability  
D. SYNC NOAFFIRM and Maximum Availability  
E. ASYNC and Maximum Performance

Show Answer

Question # 13

You administer a Data Guard environment consisting of a primary and three physicalstandby databases.One physical standby database is used for disaster recovery, one is used for reporting, andone is used as a replica for testing.The standby database used for testing is occasionally converted into a snapshot standbydatabase and then converted back to a physical standby.The physical standby database is the only standby that is a mandatory destinationThe broker configuration operates in MAXIMUM PERFORMANCE mode.Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated onthe primary database are not deleted before they are consumed appropriately on each ofthe standby databases, but which allows them to be deleted form the primary as soon as itis safe to do so?

A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY  
B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;  
C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;  
D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,  
E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;  

Show Answer

Question # 14

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.

Show Answer

Question # 15

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.

Show Answer

Question # 16

You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2 One Physical Standby Database 3. One Logical Standby DatabaseYou must meet these requirements: 1. Primary database availability should not be compromised by the availability of the standby databases. 2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database. Which redo transport mode and which protection mode would you configure to meet these requirements?

A.  SYNC AFFIRM and Maximum Protection
B.  SYNC NOAFFIRM and Maximum Protection
C. SYNC AFFIRM and Maximum Availability
D.  SYNC NOAFFIRM and Maximum Availability
E. ASYNC and Maximum Performance

Show Answer

Question # 17

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

Show Answer

Question # 18

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

Show Answer

Question # 19

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

Show Answer

Question # 20

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-datereplica 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

Show Answer

Question # 21

Which three statements are true about snapshot standby databases?

A.  Snapshot standby databases may be used for rolling release upgrades.
B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
D. a snapshot standby database can have Real-Time Query enabled
E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Show Answer

Question # 22

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

Show Answer

Question # 23

Your Data Guard environment consists of these components and settings: 1. A primary database 2. Two remote physical standby databases 3. The redo transport mode is set to SYNC. 4. Real-time query is enabled for both standby databases. 5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.  You notice an increase in redo apply lag time on both standby databases. Which two would you recommend to reduce the redo apply lag on the standby databases?

A.  Increase the size of the buffer cache on the physical standby database instances.
B.  Increase the number of standby redo log files on the standby databases.
C. Decrease the redo log file size on the primary database.
D.  Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
E.  Increase the size of standby redo log files on the standby databases.

Show Answer

Question # 24

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

Show Answer

Question # 25

A Data Guard environment has this configuration and these attributes:  1. A primary database 2. A Physical Standby Database named sbdb 3. The configuration is in maximum availability protection mode.  Then sbdb is converted to a snapshot standby database When two statements are true?

A.  Sdbd can still apply redo
B.  The recovery point objective increases
C.  The protection mode is lowered to maximum performance
D.  The recovery time objective increases.
E.  Sbdb can still receive redo

Show Answer