1Z0-066 Online Practice Questions and Answers

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

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 database. D. increase the PARALLEL_MAX_SERVER initialization parameter

D. Decrease the number of PREPARER processes

E. Increase the RECOVERY_PARALLEUSM initialization parameter

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

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.

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

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

A Data Guard environment has this configuration and these attributes:

1.

A primary database

2.

A Physical Standby Database named sbdb

3.

The configuration is in maximum availability protection mode.

Then sbdb is converted to a snapshot standby database When two statements are true?

A. Sdbd can still apply redo

B. The recovery point objective increases

C. The protection mode is lowered to maximum performance

D. The recovery time objective increases.

E. Sbdb can still receive redo

You are licensed to use Oracle Active Data Guard

Which two statements are true after enabling block change tracking on a physical standby database?

A. it allows fast incremental backups to be offloaded to the physical standby database

B. It starts the CTWR process on the physical standby database instance

C. it allows fast incremental backups to be taken on the primary database.

D. It starts the RVWR process on the physical standby database instance.

E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.

F. It starts the CTWR process on the primary database instance.

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_n when 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

The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.

Examine this list of possible steps:

1) Stop the observer on host1.

2) Disable Fast-Start Failover.

3) Update the broker configuration with the new observer hostname.

4) Enable Fast-Start Failover.

5) Start the Observer on host2.

Which contains the minimum required steps to move the observer to host2?

A. Execute only task 5.

B. Execute tasks 1, 3, and 5.

C. Execute tasks 1, 2, 3, 4, and 5.

D. Execute tasks 1 and 5.