Question 1

Which Data Guard protection mode ensures zero data loss in the event of a primary database failure?

Options :

A :

Maximum Performance

B :

Maximum Availability

C :

Maximum Durability

D :

Maximum Protection

Answer: D

Question 2

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

Question 3

True or False: In a read-only standby database with Oracle Active Data Guard, users can execute DML statements.

Options :

A : FALSE

B : TRUE

Answer: A

Question 4

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting. Switchovers or failovers are possible due to testing or in case of a disaster.Clients use local TNSNAMES.ORA files to define connection strings to the database instances. Which three will prevent clients from connecting to the wrong database instances?

Options :

A :

Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

B : The LOCAL_LISTENER parameter on the primary database instance must always be set.

C :

The client applications must use the correct TNS entries when requesting connections to the database instances.

D : Client TNS entries for the databases use the correct service names for the intended service.

E :

The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment

F : A service name is registered with the local listener of each database instance.

Answer: B,D,E

Question 5

What is the purpose of the SQLNET.INBOUND_CONNECT_TIMEOUT parameter?

Options :

A :

It specifies the maximum time a client can spend processing a query.

B :

It specifies the maximum time a client can wait for a response from a database.

C :

It specifies the maximum time a client can attempt to connect to a database.

D :

It specifies the maximum time a client can spend in an idle state.

Answer: B

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: