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?
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.