Oracle 1Z0-066 Exam Questions and Answers 2021

NEW QUESTION 1
Which two are true about the usage of DBMS_ROLLING?

• A. The leading group contains the original primary database.
• B. The trailing group contains the original primary database.
• C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
• D. At least one logical standby database must be part of the initial Data Guard configuration
• E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

Answer: DE

NEW QUESTION 2
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

Answer: C

NEW QUESTION 3
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

Answer: BDEF

NEW QUESTION 4
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

• A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
• B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
• C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
• D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
• E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: ADE

NEW QUESTION 5
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

Answer: ACFG

NEW QUESTION 6
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database You 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 the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should 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

Answer: C

NEW QUESTION 7
Which two are true about management of a far sync instance when using the Data Guard Broker?

• A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
• B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
• C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
• D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

NEW QUESTION 8
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.

Answer: AB

NEW QUESTION 9
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.

Answer: AB

NEW QUESTION 10
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is 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;

Answer: B

NEW QUESTION 11
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

Answer: BC

NEW QUESTION 12
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
• C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• E. A TNS entry or entries enabling connectivity to standby database instance(s) must bedefined on the primary database host.

Answer: D

NEW QUESTION 13
Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

• A. performing role transitions when switchover requests are made
• B. communicating with DMON processes in other database instances that are part of the broker configuration
• C. activating role-based services appropriately in the various database instances of the configuration, based on the database role
• D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
• E. maintaining information about all members of the broker configuration in binary configuration files

Answer: ABE

NEW QUESTION 14
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.

Answer: BD

NEW QUESTION 15
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2 The primary database must be protected against a regional disaster
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 16
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 viewsor 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.

Answer: CDF

NEW QUESTION 17
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

Answer: AB

NEW QUESTION 18
After converting your physical standby database to a logical database, you get an error:

How can you rectify the error?

• A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
• B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
• C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
• D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Answer: D

NEW QUESTION 19
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 Three Physical Standby Databases
You must meet these requirements:
✑ A designated physical standby database should become the primary database automatically whenever the primary database falls
✑ The chosen protection mode should provide the highest level of protection
possible without violating the other requirement
Which redo transport mode and protection mode would you configure to meet these requirements?

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

Answer: D