Free Practice Oracle 1Z0-076 Exam Questions 2025

Stay ahead with 100% Free Oracle Database 19c: Data Guard Administration 1Z0-076 Dumps Practice Questions

Page: 1 / 102

Total 509 Questions | Updated On: Mar 26, 2025

Add To Cart

Question 1

Which RMAN command is used to recover a physical standby database after a switchover?

A : RECOVER DATABASE UNTIL CANCEL;

B : RECOVER STANDBY DATABASE FROM SERVICE;

C : RECOVER STANDBY DATABASE;

D : RECOVER DATABASE USING BACKUP CONTROLFILE;

Answer: C

Question 2

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

A : tnsnames.ora

B : init.ora

C : sqlnet.ora

D : listener.ora

Answer: D

Question 3

Which configuration file is used to specify the location of the Oracle binaries?

A : sqlnet.ora

B : listener.ora

C : tnsnames.ora

D : spfile.ora

Answer: D

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?

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 statement is true regarding database operating systems when creating a physical standby database using SQL commands in Oracle Data Guard?

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

Page: 1 / 102

Total 509 Questions | Updated On: Mar 26, 2025

Add To Cart