Oracle 1Z0-066 Free Practice Questions

NEW QUESTION 1
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
• C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

Answer: D

NEW QUESTION 2
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 3
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 4
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 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 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 7
Which two are true about rolling release upgrades in a Data Guard environment?

• A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure
• B. A physical standby database can be converted to a logical standby database temporarily.
• C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.
• D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
• E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Answer: BD

NEW QUESTION 8
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 9
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 10
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 11
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 12
Which three statements are true about snapshot standby databases?

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. a snapshot standby database can have Real-Time Query enabled
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 13
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 14
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 15
Examine the Data Guard configuration;

What can you conclude based on this error?

• A. Cats is a snapshot standby database
• B. The redo transport mode is set to ASYNC for the standby database Sheep
• C. The redo transport mode is set to ASYNC for both standby databases
• D. The redo transport mode is set to ASYNC for the standby database Cats

Answer: B

NEW QUESTION 16
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 beopen 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 17
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 18
Which two are true about management of a far sync instance when using the Data Guard Broker?

• A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
• B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
• C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
• D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

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