1Z0-066 | Oracle 1Z0-066 Exam Dumps 2021

NEW QUESTION 1
Your Data Guard environment has two remote physical standby databases
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover
Which will fulfill this requirement?

• A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
• B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.

Answer: A

NEW QUESTION 2
On your logical standby database, you specified these rules:

Which is true regarding the execution of the UNSKIP procedure?

• A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
• B. it succeeds but the SQL Apply fitters are not deleted.
• C. It deletes both the SQL Apply filters.
• D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
• E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Answer: D

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

Answer: BF

NEW QUESTION 4
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 5
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 6
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 7
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

• A. Sheep will be in the disabled state.
• B. Sheep will be in the enabled state.
• C. Dogs will be in the disabled state and has to be manually reinstated
• D. The configuration will be in Maximum Performance mode.
• E. The configuration will be in Maximum Availability mode.

Answer: BCD

NEW QUESTION 8
Examine the Fast-start configuration

Oracle Error Conditions: (none) Which three are true?

• A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
• B. An automatic failover will be initiated even if the target standby database lags behind the primary
• C. The observer is running
• D. a failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
• E. The configuration operates in Maximum Availability mode
• F. The configuration operates in Maximum Performance mode

Answer: ACE

NEW QUESTION 9
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

• A. Connect to the primary database as the AUXILIARY.
• B. Catalog the data file copy for RMAN to use on the primary database for restore.
• C. Back up the data file as copy on the standby host to a location on the standby host.
• D. Switch to the data file copy using the RMAN SWITCH command.
• E. Back up the data file as copy on the standby host to a location on the primary host
• F. Connect to the primary database as the TARGET.

Answer: ABD

NEW QUESTION 10
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot 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 the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should 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 11
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 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
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 14
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 15
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 16
Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

• A. Backups of data files taken on the primary database may be restored on a physical standby database.
• B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
• C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
• D. Backups of control files taken on a physical standby database may be restored on the primary database.
• E. Backups of data files taken on a physical standby database may be restored on a pnmary database.
• F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Answer: CEF

NEW QUESTION 17
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2 The primary database must be protected against a regional disaster
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 18
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 19
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 20
Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

• A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
• B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
• D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
• E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host

Answer: AB