Breathing 1Z0-066 Exam Dumps 2021

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

Answer: ABD

NEW QUESTION 2
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 3
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations
• B. Far Sync Instances
• C. Fast-Start Failover
• D. Real Time Query
• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 4
Which three are required in order to use Real-Time Query without lagging behind the primary?

• A. There must be standby redo logs on the standby database
• B. There must be standby redo logs on the primary database.
• C. The primary must ship redo asynchronously.
• D. COMPATIBLE must be set to 11.1.0 or higher.
• E. Real-Time apply must be enabled on the standby.

Answer: ADE

NEW QUESTION 5
Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

• A. Change the protection mode to Maximum Performance.
• B. Increase the size of the buffer cache on the standby database instance.
• C. Reduce I/O latency for the storage used by the primary database.
• D. Change the protection mode to Maximum Protection.
• E. Increase the network bandwidth between the primary and standby databases
• F. Increase the number of standby redo log files on the primary database

Answer: AE

NEW QUESTION 6
Which two are true about the creation of a Data Guard Broker configuration?

• A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.
• B. A primary database profile may be added to the configuration prior to creating the primary database.
• C. A standby database profile may be added to the configuration prior to creating that standby database.
• D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
• E. A newly created broker configuration is in the disabled state

Answer: DE

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

Answer: AC

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

Answer: A

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

Answer: AD

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

Answer: BC

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

Answer: BDE

NEW QUESTION 13
Examine the Data Guard configuration after an accidental switchover to Sheep:

Which three will be true after a switchover to Dogs?

• A. Sheep will be a disabled logical standby database.
• B. Sheep will be an enabled logical standby database.
• C. Cats will be a disabled physical standby database that can be manually enabled.
• D. Cats will be an enabled physical standby database.
• E. Dogs will be the primary database.

Answer: BCE

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
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

• A. Cats will be an enabled logical standby database
• B. Cats will be a disabled logical standby database.
• C. Dogs will be a logical standby database.
• D. Dogs will be a physical standby database
• E. Sheep will be the primary database.

Answer: ACE

NEW QUESTION 16
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 17
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases Which three are true about upgrading Data Guard environments consisting of one physical
standby database running on a separate host from the primary?

• A. The upgrade requires downtime until the upgrade of the standby is completed.
• B. The broker must be disabled during the upgrade
• C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
• D. The upgrade requires downtime until the upgrade of the primary is completed.
• E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
• F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
• G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BDE

NEW QUESTION 18
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 theobserver
• 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 19
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 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