Oracle Exam 1Z0-066 Topic 3 Question 32 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 32
Topic #: 3

[All 1Z0-066 Questions]

On your logical standby database, you specified these rules:

SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP_NEW');

SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP_OLD');

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP%');

Which is true regarding the execution of the UNSKIP procedure?

AIt succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

BIt succeeds but the SQL Apply filters are not deleted.

CIt deletes both the SQL Apply filters.

DIt returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.

EIt succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

Show Suggested Answer

Suggested Answer: D

The UNSKIP procedure reverses the actions of the SKIP procedure by finding the record, matching all the parameters, and removing the record from the system table. The match must be exact, and multiple skip actions can be undone only by a matching number of unskip actions. You cannot undo multiple skip actions using wildcard characters.

References:

https://docs.oracle.com/cd/B12037_01/appdev.101/b10802/d_lsbydb.htm#997823

by Cory at May 07, 2022, 10:08 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-066 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!