Oracle 1Z0-066 Dumps Questions 2021

NEW QUESTION 1
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 2
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 3
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, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

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

Answer: AC

NEW QUESTION 5
Examine the Data Guard configuration:

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 6
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

• A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
• B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
• C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
• D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
• E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

Answer: B

NEW QUESTION 7
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 8
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 9
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 10
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 havingDelayMins set.

Answer: BF

NEW QUESTION 11
Which three statements are true about Data Guard configurations?

• A. All databases in one Data Guard environment must have the same database name.
• B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_nwhen performing switchovers or failovers.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. Up to 30 physical standby databases may exist within one configuration.
• F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Answer: AEF

NEW QUESTION 12
You have a Data Guard Broker configuration called Somewhere' as shown:

Which two are true about the output of this DGMGRL command?

• A. A far sync instance cannot have inconsistent properties because it has no database.
• B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.
• C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
• D. Any inconsistency reported is on an instance-specific basis.

Answer: CD

NEW QUESTION 13
Which three are benefits of using the Data Guard Broker to manage standby databases?

• A. it simplifies physical standby database creation
• B. It provides an easy failover capability using a single command.
• C. it coordinates database state transitions and updates database properties dynamically.
• D. it automatically changes database properties after the protection mode for a configuration is changed
• E. It provides an easy switchover capability using a single command.
• F. It simplifies logical standby database creation.

Answer: BCE

NEW QUESTION 14
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 15
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

NEW QUESTION 16
Which three are prerequisites for enabling Fast-Start Failover?

• A. The Fast-Start Failover target standby database must receive REDO directly from the primary database
• B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
• C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.
• D. The configuration must be operating in either Maximum Performance or Maximum Availability mode
• E. The configuration must be operating in either Maximum Performance or Maximum Protection mode
• F. The Data Guard environment must be managed by the Data Guard Broker.

Answer: BDF

NEW QUESTION 17
Examine the Data Guard configuration:

Identify two possible reasons for this error.

• A. The FastStartFailoverTarget property is not set on Sheep.
• B. The FastStartFailoverTarget property is not set on Dogs.
• C. The FastStartFailoverTarget property is not set on DogsFSI.
• D. The LogXptMode property is set to ASYNC on Dogs.
• E. The RedoRoutes property is not set on Dogs
• F. The RedoRoutes property is not set on DogsFSI

Answer: AD

NEW QUESTION 18
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?

• A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
• B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
• C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
• D. Fast start failover can be enabled when making the chance.
• E. Real time apply will be automatically turned on.

Answer: BC

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