Oracle 1Z0-066 Exam Questions and Answers 2021

NEW QUESTION 1
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

• A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
• C. It checks that the current data protection level is consistent with the broker's configured data protection mode.
• D. it modifies the database configurable parameters to match the values set for the broker configuration.
• E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Answer: ABC

NEW QUESTION 2
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 3
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 4
Which two statements are true for Data Guard environments with multi-tenant databases?

• A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
• B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
• C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
• D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database
• E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Answer: AD

NEW QUESTION 5
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 6
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

Answer: ABE

NEW QUESTION 7
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 onthe primary database.
• D. The standby database must be registered in an RMAN catalog before the primary database has been registered

Answer: BC

NEW QUESTION 8
You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

• A. 2,3, 4, and 5
• B. 1,2, 3,4, and 5
• C. 1 and 2
• D. only requirement 5
• E. only requirement 1

Answer: C

NEW QUESTION 9
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 10
Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements:
create sequence a global; create sequence b session; Neither sequence has been used since being created
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 11
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

• A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
• B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
• C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
• D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Answer: C

NEW QUESTION 12
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 13
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 14
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

• A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
• B. Put the primary database into archivelog mode
• C. Startup nomount the standby database instance.
• D. Configure Oracle Net connectivity on the primary host to the standby database instance.
• E. Establish user equivalence for the database software owner between the primary host and standby host.

Answer: CDE

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