Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 67

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?

Answer options

• A. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.
• B. It succeeds but the SQL Apply filters are not deleted.
• C. It deletes both the SQL Apply filters.
• D. It 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.
• E. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

Correct answer: B

Explanation

The correct answer is B because the UNSKIP procedure can be executed successfully even if the filters remain in place. Options A, C, D, and E are incorrect because they all imply conditions or outcomes that do not apply to the nature of the UNSKIP command regarding the filters set previously.