Accurate 1Z0-066 Exam Dumps 2021

NEW QUESTION 1
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 One Physical Standby Database
3. One Logical 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 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

Answer: C

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

Answer: CDF

NEW QUESTION 4
Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration:
DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs
Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE
Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO
Stuck Archiver NO Datafile Offline YES Oracle error Conditions
ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

• A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

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

NEW QUESTION 8
Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

• A. monitoring the redo apply rate on a physical standby
• B. monitoring the redo apply rate on a logical standby
• C. monitoring the undo generation rate on a logical standby
• D. monitoring the redo apply rate on a snapshot standby
• E. monitoring the transport lag
• F. monitoring the undo generation rate on the primary

Answer: AE

NEW QUESTION 9
Examine the Data Guard configuration:

Which three will be true after a switchover to Dogs?

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

Answer: BCE

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

Answer: BE

NEW QUESTION 11
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 12
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability Databases
dogs- Primary database
cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

• A. DGMGRL> convert database cats to physical standby,
• B. DGMGRL> convert database sheep to physical standby;
• C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
• D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
• E. None, because you can directly failover to a Snapshot Standby Database

Answer: C

NEW QUESTION 13
Which three statements are true about Data Guard configurations?

• A. All databases in one Data Guard environment must have the same database name.
• B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_nwhen performing switchovers or failovers.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. Up to 30 physical standby databases may exist within one configuration.
• F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Answer: AEF

NEW QUESTION 14
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 15
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

• A. FLASHBACK DATABASE must be enabled on the physical standby database.
• B. There must be connectivity between the primary and the physical standby database.
• C. FLASHBACK DATABASE must be enabled on the primary database.
• D. The physical standby database must have Real-Time Apply enabled.
• E. The logical standby database must have Real-Time Query enabled

Answer: CD

NEW QUESTION 16
Which two statements are true regarding Data Guard Broker?

• A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
• B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C. it can be used to perform failovers and switchovers.
• D. It can be used to create and manage standby databases.
• E. It can be used to monitor redo transport and log apply services.

Answer: BC

NEW QUESTION 17
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 18
Which three are true concerning database states after a successful switchover?

• A. If the former primary database became a logical standby database it will be in mount state
• B. The new primary database will be open read-write.
• C. The former primary database will always be open.
• D. If the former primary database became a logical standby database it will be open read- write.
• E. if the former primary database became a physical standby database it will always beopen read-only.
• F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

Answer: ABE

NEW QUESTION 19
Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements:
create sequence a global; create sequence b session; Neither sequence has been used since being created
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C