Question 1

What is the purpose of the sqlnet.ora file in Oracle Net Services?

Options :

A :

to specify network timeout settings

B :

to specify listener settings

C :

to specify database connection settings

D :

to specify network encryption settings

Answer: D

Question 2

What is Oracle Net Services?

Options :

A :

A database security feature

B :

A data guard administration tool

C :

A networking protocol

D :

A database management system

Answer: C

Question 3

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

Options :

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

Which command is used to enable or disable Fast-Start Failover in Oracle Data Guard?

Options :

A :

ALTER BROKER

B :

ALTER DATABASE

C :

ALTER SYSTEM

D :

ALTER SESSION

Answer: A

Question 5

What is the main benefit of using Data Guard for disaster recovery?

Options :

A :

Continuous availability of critical data

B :

Increased database security

C :

Improved query performance

D :

Reduced backup and recovery time

Answer: A

Higher Test Marks with Free Online 1Z0-076 Exam Practice

Buying Options: