Oracle 1Z0-076 Exam Real Questions

Prepare and pass your Oracle Database 19c: Data Guard Administration with free 1Z0-076 exam questions.

Page: 1 / 102

Total 509 Questions | Updated On: Oct 11, 2024

Add To Cart

Question 1

Which Data Guard mode ensures that transactions are not committed on the primary database until they are safely written to disk on the standby database?

A : Maximum Safety

B : Maximum Performance

C : Maximum Protection

D : Maximum Availability

Answer: C

Question 2

What is the purpose of the listener.ora file?

A : To specify the location of the Oracle binaries

B : To define the connection string for a specific database

C : To configure network connectivity between the primary and standby databases

D : To define the network names of all the databases on a server

Answer: C

Question 3

What is the purpose of the LogMiner utility in a logical standby database?

A : To perform log shipping between primary and standby databases

B : To manage data backup and recovery operations

C : To manage network connectivity between primary and standby databases

D : To analyze and extract data from redo logs

Answer: D

Question 4

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 5

Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

A : Their usage will always have a performance impact on the primary database.

B : Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.

C : If the CACHE option is set then the size of the cache must be at least 100.

D : Their usage may have a performance impact on the physical standby database if the CACHE size is too small.

E : They must have the NOORDEK and CACHE options set.

Answer: A,D,E

Page: 1 / 102

Total 509 Questions | Updated On: Oct 11, 2024

Add To Cart