Free Oracle 1Z0-076 Exam Questions

Become Oracle Certified with updated 1Z0-076 exam questions and correct answers

Page: 1 / 110

Total 546 Questions | Updated On: Aug 02, 2026

Add To Cart

Question 1

In a snapshot standby database, what happens to the changes made to the standby database when it is converted back to a physical standby database?

A : They are merged with the changes made to the primary database.

B : They are discarded, and the standby database becomes an exact copy of the primary database.

C : They are automatically synchronized with the primary database.

D : They are lost and need to be re-applied from the primary database.

Answer: B

Question 2

What is the purpose of the SKIP_UNUSABLE_INDEXES initialization parameter in a Logical Standby Database?

A : It allows the primary database to ignore any unusable indexes on the standby database.

B : It skips the application of unusable indexes during SQL apply on the standby database.

C : It allows creation of unusable indexes on the standby database.

D : It skips the creation of unusable indexes on the primary database.

Answer: B

Question 3

What happens when the standby redo logs are not present on the standby database?

A : The standby database cannot be used for failover.

B : Redo logs from the primary database are not applied to the standby database.

C : Archive logs cannot be transferred to the standby database.

D : The standby database operates in manual recovery mode.

Answer: B

Question 4

What is the primary method used to create a logical standby database?

A : Data Pump

B : RMAN

C : SQL statements

D : Flashback Database

Answer: A

Question 5

Which configuration file is used to specify the network connection parameters for the primary and standby databases?

A : tnsnames.ora

B : listener.ora

C : sqlnet.ora

D : init.ora

Answer: C

Page: 1 / 110

Total 546 Questions | Updated On: Aug 02, 2026

Add To Cart