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: Sep 09, 2025

Add To Cart

Question 1

Your Data Guard configuration consists of these components and settings: 1. A primary database 2. A remote physical standby database 3. Real-time query is enabled 4. Redo transport mode is synchronous 5. Protection mode is maximum availability 6. The Data Guard broker is used You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time. Which is true in this scenario?

A : Real-time query will be disabled on the physical standby.

B : The protection mode will automatically change to Maximum Performance.

C : Synchronous redo transport mode connections to the standby database are terminated.

D : The physical standby database instance is shut down by the Data Guard broker.

Answer: C

Question 2

Which command is used to stop the Oracle Net Listener process?

A : tnsping

B : lsnrctl stop

C : net stop

D : sqlplus

Answer: B

Question 3

What is the primary difference between a snapshot standby database and a logical standby database?

A : A snapshot standby can be converted back to a physical standby, while a logical standby cannot.

B : A snapshot standby is based on physical replication, while a logical standby is based on logical replication.

C : A snapshot standby requires supplemental logging, while a logical standby does not.

D : A snapshot standby allows read/write access, while a logical standby allows read-only access.

Answer: B

Question 4

When would you use a Snapshot Standby database?

A : To create a copy of the primary database for testing purposes

B : To perform rolling upgrades of the Oracle database software

C : To offload read-only workloads from the primary database

Answer: B

Question 5

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

Page: 1 / 110

Total 546 Questions | Updated On: Sep 09, 2025

Add To Cart