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 primary database.
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.
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?
A. it allows fast incremental backups to be offloaded to the physical standby database
B. It starts the CTWR process on the physical standby database instance
C. it allows fast incremental backups to be taken on the primary database.
D. It starts the RVWR process on the physical standby database instance.
E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
F. It starts the CTWR process on the primary database instance.
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.
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
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.
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
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.
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.
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.
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 on the primary database.
D. The standby database must be registered in an RMAN catalog before the primary database has been registered
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-066 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.