Printable 1Z0-066 Dumps Questions 2021

NEW QUESTION 1
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 2
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 3
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 4
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A. if the CACHE option is set then the size of the cache must be at least 100
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Answer: BDE

NEW QUESTION 5
Examine this list of possible steps:
1 Raise the compatibility level on both databases
2.Restart SQL Apply on the upgraded logical standby database 3 Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

• A. 5,2.4,3,6,1
• B. 1,5,2,4,6,3
• C. 5,2,4,6,3,1
• D. 4,6,5,2,3,1
• E. 5,2,4,1

Answer: A

NEW QUESTION 6
Which two are true about database roles in an Oracle Data Guard Configuration?

• A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B. A Logical Standby Database can be converted to a Snapshot Standby Database.
• C. A Logical Standby Database can cascade redo to a terminal destination
• D. A Snapshot Standby Database can be a fast-start failover target
• E. A Physical Standby Database can be converted into a Logical Standby Database.

Answer: BE

NEW QUESTION 7
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 8
You must design an Oracle Data Guard configuration for an OLTP database 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:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

• A. a primary database with three physical standby databases
• B. a primary database with one logical and two physical standby databases
• C. a primary database with one logical standby database
• D. a primary database with one logical and one physical standby database
• E. a primary database with two physical standby databases
• F. a primary database with one physical standby database

Answer: D

NEW QUESTION 9
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 10
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A. if the CACHE option is set then the size of the cache must be at least 100
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Answer: BDE

NEW QUESTION 11
Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports produced.
4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

• A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.

Answer: B

NEW QUESTION 12
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 13
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 14
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 15
Which three are required in order to use Real-Time Query without lagging behind the primary?

• A. There must be standby redo logs on the standby database
• B. There must be standby redo logs on the primary database.
• C. The primary must ship redo asynchronously.
• D. COMPATIBLE must be set to 11.1.0 or higher.
• E. Real-Time apply must be enabled on the standby.

Answer: ADE

NEW QUESTION 16
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 17
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases Which three are true about upgrading Data Guard environments consisting of one physical
standby database running on a separate host from the primary?

• A. The upgrade requires downtime until the upgrade of the standby is completed.
• B. The broker must be disabled during the upgrade
• C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
• D. The upgrade requires downtime until the upgrade of the primary is completed.
• E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
• F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
• G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BDE

NEW QUESTION 18
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations
• B. Far Sync Instances
• C. Fast-Start Failover
• D. Real Time Query
• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 19
Which three are true about using RMAN in a Data Guard environment?

• A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
• B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
• C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
• D. Backups of control files taken on a physical standby are not interchangeable with a primary.
• E. Backups of data files taken on a physical standby are interchangeable with a primary.

Answer: BCE