Question 1

What happens to a read-only transaction in a read-only standby database if the primary database fails?

Options :

A : The transaction is queued and executed once the primary database is restored

B : The transaction is automatically redirected to the standby database

C : The transaction is rolled back and not applied to the standby database

D : The transaction is permanently lost

Answer: C

Question 2

Which file is used to configure Oracle Net Services?

Options :

A : spfile.ora

B : listener.ora

C : tnsnames.ora

D : sqlnet.ora

Answer: B

Question 3

Which statement is true regarding database operating systems when creating a physical standby database using SQL commands in Oracle Data Guard?

Options :

A : The operating system of the primary database must be a higher version than that of the standby database.

B : The primary and standby databases must be installed on the same operating system.

C : The primary and standby databases can be installed on different operating systems.

D : The operating system of the standby database must be a higher version than that of the primary database.

Answer: C

Question 4

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:Which three statements are true regarding the execution of the command?

Options :

A : The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

B : The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

C : The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

D : The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

E : The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

F : The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

Answer: A,D,E

Question 5

Which listener configuration file is used to specify the network connection parameters for the databases in a Data Guard environment?

Options :

A : tnsnames.ora

B : init.ora

C : sqlnet.ora

D : listener.ora

Answer: D