Question 1

What is the purpose of the sqlnet.ora file?

Options :

A :

To specify the location of the Oracle binaries

B :

To specify network encryption and data integrity parameters

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: B

Question 2

Which Oracle Data Guard feature is NOT supported on a snapshot standby database?

Options :

A :

Far Sync

B :

Fast-Start Failover

C :

Broker Configurations

D :

Real-Time Apply

Answer: D

Question 3

Which Oracle Active Data Guard feature allows users to query a standby database without impacting recovery?

Options :

A :

Active Data Guard Real-Time Query

B :

Flashback Database

C :

Snapshot Standby Database

D :

Data Guard Broker

Answer: A

Question 4

Which feature of Oracle Active Data Guard allows for automatic block correction on the standby database?

Options :

A :

Real-Time Apply

B :

Active Data Guard Broker

C :

Far Sync

D :

Flashback Database

Answer: A

Question 5

Which configuration file is used to specify the location of the Oracle binaries?

Options :

A :

sqlnet.ora

B :

listener.ora

C :

tnsnames.ora

D :

spfile.ora

Answer: D

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

Buying Options: