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: Dec 05, 2025

Add To Cart

Question 1

What is the benefit of creating a logical standby database compared to a physical standby database?

A : A logical standby database consumes less storage space than a physical standby database.

B : A logical standby database allows read/write access for reporting purposes.

C : A logical standby database requires less network bandwidth for redo transfer.

D : A logical standby database provides faster recovery times in case of failures.

Answer: B

Question 2

Which of the following is NOT a benefit of using a snapshot standby database?

A : Accelerating data recovery in case of primary database failure.

B : Simplifying patching and upgrade processes by utilizing the snapshot database.

C : Providing a read-write copy of the database for testing and development purposes.

D : Reducing the load on the primary database by offloading reporting and queries.

Answer: A

Question 3

What is the purpose of the redo transport service in Oracle Data Guard?

A : To transport data files from the primary database to the standby database.

B : To transport backup files from the primary database to the standby database.

C : To transport control files from the primary database to the standby database.

D : To transport redo data from the primary database to the standby database.

Answer: D

Question 4

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 5

What is a switchover operation in an Oracle Data Guard configuration?

A : Upgrading the database software on both the primary and standby databases.

B : Transferring data between the primary and standby databases.

C : Switching the roles of the primary and standby databases.

D : Adding a new standby database to the configuration.

Answer: C

Page: 1 / 110

Total 546 Questions | Updated On: Dec 05, 2025

Add To Cart