Accurate 1Z0-066 Study Guides 2021

NEW QUESTION 1
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 2
Which three factors can influence the rate of redo apply on a physical standby database?

• A. the network latency between the primary and standby databases
• B. the number of archiver processes on the standby database
• C. the number and size of standby redo logs on the primary database
• D. the rate of redo generation on the primary database
• E. the number and size of standby redo logs on the standby database

Answer: ABE

NEW QUESTION 3
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

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

Answer: ABE

NEW QUESTION 4
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 5
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

• A. Increase the PROCESSES initialization parameter
• B. Increase the value for the MAX_SERVERS SQL apply parameter.
• C. Decrease the number of archiver processes on the standby databas
• D. increase the PARALLEL_MAX_SERVER initialization parameter
• E. Decrease the number of PREPARER processes
• F. Increase the RECOVERY_PARALLEUSM initialization parameter

Answer: BE

NEW QUESTION 6
Which four requirements can be met by deploying a logical standby database?

• A. Support for workloads requiring additional indexes.
• B. it can be used to create additional schemas.
• C. it can be used to create additional tables.
• D. It must have the same physical structure as the primary database.
• E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• F. Support for workloads requiring additional materialized views.
• G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

Answer: ACEG

NEW QUESTION 7
Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals
Protection Mode: MaxAvailability Databases:
dogs- Primary database
sheep- (*) Physical standby database cats- Physical standby database
Fast-Start Failover: ENABLED Configuration Status: SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

• A. The switchover succeeds but Dogs need to be reinstated
• B. The switchover succeeds but Fast-Start Failover is suspended.
• C. The switchover succeeds and Cats become the new failover target.
• D. The switchover succeeds and Dogs become the new failover target
• E. it results in an error indicating that a switchover is not allowed.

Answer: D

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

Answer: ABE

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

NEW QUESTION 11
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 12
Which four are true about DGMGRL show command?

• A. It can be used to show properties of a pluggable standby database.
• B. it can be used to show properties of a pluggable primary database.
• C. it can be used to show instance-specific properties for a RAC database.
• D. it can be used to show properties of a far sync instance
• E. it can be used to show Fast Start Failover properties.
• F. It can be used to show properties of a primary container database.

Answer: ABEF

NEW QUESTION 13
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

• A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
• B. Put the primary database into archivelog mode
• C. Startup nomount the standby database instance.
• D. Configure Oracle Net connectivity on the primary host to the standby database instance.
• E. Establish user equivalence for the database software owner between the primary host and standby host.

Answer: CDE

NEW QUESTION 14
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

What is true concerning this configuration?

• A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
• B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
• C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
• D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
• E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Answer: A

NEW QUESTION 15
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 16
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

• A. a snapshot standby database is the only standby database in the Data Guard configuration.
• B. A logical standby database is the only standby database in the data guard configuration.
• C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
• D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
• E. The primary and standby databases are hosted on different operating systems.

Answer: BE

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

Answer: ACE

NEW QUESTION 18
Which two are true about rolling release upgrades in a Data Guard environment?

• A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure
• B. A physical standby database can be converted to a logical standby database temporarily.
• C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.
• D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
• E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Answer: BD

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

Answer: DE