Question 1

True or False: In a read-only standby database with Oracle Active Data Guard, users can execute DML statements.

Options :

A : FALSE

B : TRUE

Answer: A

Question 2

What happens to the redo logs on the physical standby database during the process of redo apply?

Options :

A : They are copied to the FRA (Fast Recovery Area) on the standby database.

B : They are automatically deleted after being applied to the standby database.

C : They are archived to the configured archival destination on the standby database.

D : They are overwritten with new redo data from the primary database.

Answer: B

Question 3

Which Oracle Data Guard mode allows real-time synchronization between the primary and standby databases?

Options :

A : Maximum Protection mode

B : Maximum Readability mode

C : Maximum Performance mode

D : Maximum Availability mode

Answer: A

Question 4

What are the two main components of Oracle Data Guard?

Options :

A : Primary database and standby database

B : Synchronous mode and asynchronous mode

C : Physical standby and logical standby

D : Data files and control files

Answer: A

Question 5

What is the purpose of starting the standby database in read-only mode during the physical standby database creation process?

Options :

A : To synchronize data between the primary and standby databases

B : To enable real-time query on the standby database

C : To allow read-only transactions on the standby database

D : To perform monitoring and management tasks on the standby database

Answer: C