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.

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

Which two statements are true regarding Data Guard Broker?

A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby

B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

C. it can be used to perform failovers and switchovers.

D. It can be used to create and manage standby databases.

E. It can be used to monitor redo transport and log apply services.

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

Your Data Guard environment consists of these components and settings:

1.

A primary database

2.

A remote physical standby database

3.

Real-time query is enabled

4.

The redo transport mode is set to SYNC.

5.

The protection mode is set to Maximum Availability.

You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

A. Change the protection mode to Maximum Performance.

B. Increase the size of the buffer cache on the standby database instance.

C. Reduce I/O latency for the storage used by the primary database.

D. Change the protection mode to Maximum Protection.

E. Increase the network bandwidth between the primary and standby databases

F. Increase the number of standby redo log files on the primary database