Free Oracle 1Z0-076 Exam Questions

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

Page: 1 / 102

Total 509 Questions | Updated On: Jan 09, 2025

Add To Cart

Question 1

What is the benefit of converting a physical standby database into a Snapshot Standby database?

A : Provides a point-in-time copy of the primary database for testing.

B : Allows read-only access to the database for reporting purposes.

C : Enhances database performance and reduces IO workload.

D : Eliminates the need for recovery when the primary database fails.

Answer: A

Question 2

What is the main advantage of using a snapshot standby database over a physical standby database?

A : Improved performance for reporting and queries

B : Reduced disk space requirements

C : Ability to apply redo logs to update the standby database

D : Faster failover and switchover capabilities

Answer: A

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

Can read-only transactions be performed on a standby database in Oracle Active Data Guard?

A : No, read-only transactions are not supported on a standby database.

B : Read-only transactions can only be performed if the standby database is configured as a logical standby.

C : Read-only transactions can only be performed if the standby database is in a read-write mode.

D : Yes, read-only transactions can be performed on a standby database.

Answer: D

Question 5

What is the primary purpose of the DUPLICATE TARGET DATABASE FOR STANDBY command in RMAN when creating a physical standby database in Oracle Data Guard?

A : To create a new database instance for the standby database

B : To duplicate the primary database to the standby database

C : To recover the standby database from archived redo logs

D : To create a backup copy of the primary database

Answer: B

Page: 1 / 102

Total 509 Questions | Updated On: Jan 09, 2025

Add To Cart