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 type of redo records are not supported by a Logical Standby Database?

Options :

A :

SELECT statements

B :

Transaction Control Statements

C :

DML statements

D :

DDL statements

Answer: D

Question 3

Which command is used to test a network connection using TNSPING utility?

Options :

A :

tnsping

B :

traceroute

C :

telnet

D : ping

Answer: A

Question 4

How does Oracle Active Data Guard handle redo data on a read-only standby database?

Options :

A :

It discards redo data after applying it to the standby database.

B :

It encrypts the redo data to ensure data security on the standby database.

C :

It keeps the redo data indefinitely to ensure consistency with the primary database.

D :

It compresses the redo data to save storage space on the standby database.

Answer: A

Question 5

Which command is used to start the Oracle Net Listener process?

Options :

A :

lsnrctl start

B :

sqlplus

C :

tnsping

D :

net start

Answer: A

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

Buying Options: