Question 1

What is the purpose of the LOCAL_LISTENER parameter in the listener.ora file?

Options :

A : It specifies the database service name.

B : It specifies the port number for the listener.

C : It specifies the address of the listener.

D : It specifies the location of the listener log file.

Answer: C

Question 2

Which type of transactions are not allowed on a read-only standby database?

Options :

A : Read-only transactions

B : DDL transactions

C : Data manipulation transactions

D : Write transactions

Answer: D

Question 3

Which Oracle Data Guard role is recommended for a Logical Standby Database?

Options :

A : Primary Database

B : Far Sync Instance

C : Observer

D : Broker Configuration

Answer: D

Question 4

What is the purpose of the SKIP clause in a logical standby database configuration?

Options :

A : To skip applying specific SQL statements to the standby database

B : To skip applying specific redo logs to the standby database

C : To skip applying specific network configurations to the standby database

D : To skip applying specific supplemental logging settings to the standby database

Answer: A

Question 5

How does Oracle Active Data Guard handle redo data on a read-only standby database?

Options :

A : It discards redo data after applying it to the standby database.

B : It encrypts the redo data to ensure data security on the standby database.

C : It keeps the redo data indefinitely to ensure consistency with the primary database.

D : It compresses the redo data to save storage space on the standby database.

Answer: A