for Oracle certification, Real Success Guaranteed with Updated . 100% PASS 1Z0-066 Oracle Database 12c: Data Guard Administration exam Today!

Oracle 1Z0-066 Free Dumps Questions Online, Read and Test Now.

NEW QUESTION 1
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 reasons for this error

  • A. Fast-Start Failover is not yet enabled for this Data Guard configuration
  • B. The observer configuration file is marked read-only.
  • C. There is already an observer running for this Data Guard configuration.
  • D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
  • E. The broker configuration has not yet been created.

Answer: BD

NEW QUESTION 2
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 be open 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 3
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 4
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 5
Examine the Data Guard configuration after an accidental switchover to Sheep:
1Z0-066 dumps exhibit
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 6
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 7
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 8
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 9
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 10
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 11
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 12
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, unlessLOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

NEW QUESTION 13
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 14
Examine this list of possible steps:
1 Raise the compatibility level on both databases
2.Restart SQL Apply on the upgraded logical standby database 3 Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

  • A. 5,2.4,3,6,1
  • B. 1,5,2,4,6,3
  • C. 5,2,4,6,3,1
  • D. 4,6,5,2,3,1
  • E. 5,2,4,1

Answer: A

NEW QUESTION 15
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 reasons for this error

  • A. Fast-Start Failover is not yet enabled for this Data Guard configuration
  • B. The observer configuration file is marked read-only.
  • C. There is already an observer running for this Data Guard configuration.
  • D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
  • E. The broker configuration has not yet been created.

Answer: BD

NEW QUESTION 16
You edit the DGConnectldentifier database property using the edit database set property
DGMGRL command Which two are effects of this change?

  • A. The fal_client database initialization parameter on all standby databases is updated with the new value.
  • B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
  • C. The fal_client database initialization parameter for the specified database is updated with the new value
  • D. The broker configuration must be disabled and then enabled to use the new connection property.
  • E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value

Answer: AB

NEW QUESTION 17
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 18
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 19
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 20
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

Recommend!! Get the Full 1Z0-066 dumps in VCE and PDF From 2passeasy, Welcome to Download: https://www.2passeasy.com/dumps/1Z0-066/ (New 184 Q&As Version)