Online 1Z0-076 Practice Test

Question 1

Which of the following statements is true regarding a Logical Standby Database?

Options :

A :

It can be converted back to a physical standby database.

B :

It supports ETL (Extract, Transform, Load) processes.

C :

It allows read-only operations on the standby database.

D :

It is not a supported configuration in Oracle Data Guard.

Answer: B

Question 2

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 3

What is the purpose of the listener.ora file?

Options :

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 4

Which initialization parameter is used to specify the location of the redo logs in a physical standby database?

Options :

A :

LOG_ARCHIVE_DEST_1

B :

LOG_ARCHIVE_CONFIG

C :

STANDBY_FILE_MANAGEMENT

D :

DB_FILE_NAME_CONVERT

Answer: A

Question 5

Which command is used to view the configuration of the Oracle Net Listener?

Options :

A : ls

B : tnsping

C : lsnrctl status

D :

net status

Answer: C

EXPERTY DESIGNED 1Z0-076 PRACTICE TEST