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 database. D. increase the PARALLEL_MAX_SERVER initialization parameter
D. Decrease the number of PREPARER processes
E. Increase the RECOVERY_PARALLEUSM initialization parameter
Which three statements are true about snapshot standby databases?
A. Snapshot standby databases may be used for rolling release upgrades.
B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
D. a snapshot standby database can have Real-Time Query enabled
E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.
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
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
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.
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 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
Which two are true regarding the DelayMins Database Property for the standby database?
A. it can only be enabled for a configuration in Maximum Performance mode.
B. It allows user errors on the primary to be recovered by using the physical standby database.
C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
D. it can only be enabled for a configuration in Maximum Availability mode.
E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
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
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
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
Which two statements are true for Data Guard environments with mufti-tenant databases?
A. Different pluggable databases within a logical standby database may have different guard statuses.
B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.
E. A multi-tenant standby database can have fewer pluggable databases than the primary container database
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.