Question 1

Which initialization parameter specifies the destinations where archived redo logs are shipped in a Logical Standby Database configuration?

Options :

A :

LOG_ARCHIVE_DEST_STATE_1

B :

LOG_ARCHIVE_DEST_2

C :

LOG_ARCHIVE_DEST_STATE_2

D :

LOG_ARCHIVE_DEST_1

Answer: D

Question 2

Which command can be used to test the connectivity and synchronization between the primary and standby databases?

Options :

A :

ALTER DATABASE TEST STANDBY DATABASE;

B :

ALTER SYSTEM TEST LOGICAL STANDBY INTEGRITY;

C :

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD';

D :

ALTER PLUGGABLE DATABASE OPEN READ WRITE;

Answer: A

Question 3

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 4

Which SQL statement is used to enable the Flashback Database feature on the primary database before creating a physical standby database?

Options :

A :

ALTER SYSTEM ENABLE FLASHBACK DATABASE;

B :

ALTER TABLESPACE ENABLE FLASHBACK;

C :

ALTER DATABASE ENABLE FLASHBACK DATABASE;

D :

ALTER DATABASE SET FLASHBACK ON;

Answer: A

Question 5

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

Options :

A :

tnsping

B :

traceroute

C :

telnet

D : ping

Answer: A

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

Buying Options: