1Z0-066 | Oracle 1Z0-066 Dumps 2021

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

Answer: D

NEW QUESTION 2
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 3
Examine the Data Guard configuration;

What can you conclude based on this error?

• A. Cats is a snapshot standby database
• B. The redo transport mode is set to ASYNC for the standby database Sheep
• C. The redo transport mode is set to ASYNC for both standby databases
• D. The redo transport mode is set to ASYNC for the standby database Cats

Answer: B

NEW QUESTION 4
Which two are true about offloading backups to a physical standby database in a Data Guard environment?

• A. The standby database must be registered in an RMAN catalog after the primary database has been registered
• B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
• C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file onthe primary database.
• D. The standby database must be registered in an RMAN catalog before the primary database has been registered

Answer: BC

NEW QUESTION 5
Which two are true about database roles in an Oracle Data Guard Configuration?

• A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B. A Logical Standby Database can be converted to a Snapshot Standby Database.
• C. A Logical Standby Database can cascade redo to a terminal destination
• D. A Snapshot Standby Database can be a fast-start failover target
• E. A Physical Standby Database can be converted into a Logical Standby Database.

Answer: BE

NEW QUESTION 6
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 7
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 8
Which four database parameters might be affected by or influence the creation of standby databases?

• A. DB_NAME
• B. ARCHIVE_LAG_TARGET
• C. COMPATIBLE
• D. DB_FILE_NAME_CONVERT
• E. DB_UNIQUE_NAME
• F. FAL_SERVER
• G. STANDBY_ARCH1VE_DEST

Answer: ADEF

NEW QUESTION 9
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 10
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 11
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 arecovery catalog
• E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Answer: ADE

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

Answer: CD

NEW QUESTION 13
Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports
produced.
4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

• A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.

Answer: B

NEW QUESTION 14
A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. physt1 and physt2 have Real-Time Query enabled
A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

• A. The sequence is usable on physt1 and physt2
• B. The sequence is usable on physt1 but not usable on physt2.
• C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primarydatabase.
• D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

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

Answer: AD

NEW QUESTION 16
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

• A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
• C. It checks that the current data protection level is consistent with the broker's configured data protection mode.
• D. it modifies the database configurable parameters to match the values set for the broker configuration.
• E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Answer: ABC

NEW QUESTION 17
A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

• A. Recover the datafile by using the RMAN RECOVER DATAFILE command
• B. Restart the redo apply.
• C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
• D. Stop the redo apply.
• E. Recover the database by using the RMAN RECOVER DATABASE command.

Answer: CDE

NEW QUESTION 18
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?

• A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
• B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
• C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
• D. Fast start failover can be enabled when making the chance.
• E. Real time apply will be automatically turned on.

Answer: BC

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

Answer: BCD

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

Answer: BE