Oracle 1Z0-066 Exam Questions 2021

NEW QUESTION 1
Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

• A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
• C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• D. backups of data files taken on the logical standby database, if not connected to arecovery catalog
• E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Answer: ADE

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

Answer: BCD

NEW QUESTION 3
Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

• A. The primary database must have FORCE LOGGING enabled.
• B. The primary database must be in archive log mode
• C. A backup of the primary database must exist.
• D. The primary host and the proposed standby database host must run the same operating system.
• E. The primary database instance must be started using an SPFILE.
• F. The primary database must have flashback enabled

Answer: AB

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

Answer: CD

NEW QUESTION 5
Examine this query and its output:

Which are true?

• A. The observer is not connected to the database on which the query was executed.
• B. Cats is a bystander database.
• C. The observer is connected to the database on which the query was executed.
• D. The observer is currently running on o17.example com
• E. The observer is not running, but should run on o17 example.com.

Answer: A

NEW QUESTION 6
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 7
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 8
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 9
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 10
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 11
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 12
After converting your physical standby database to a logical database, you get an error:

How can you rectify the error?

• A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
• B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
• C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
• D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Answer: D

NEW QUESTION 13
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 14
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 15
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 views or 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 16
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

• A. a remote physical standby database with RedoRoutesvia a far sync instance
• B. a snapshot standby database with synchronous redo transport
• C. a physical standby database with real-time query enabled
• D. a logical standby database
• E. a read mostly implementation of a physical standby database

Answer: BC