Exam 1z0-066 topic 1 question 62 discussion

Actual exam question from Oracle's 1z0-066

Question #: 62
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by alexz1 at Nov. 21, 2022, 6:46 a.m.

Comments

Submit Cancel

ScottL

1 year, 7 months ago

Selected Answer: B

SQL> EXECUTE DBMS_LOGSTDBY.UNSKIP (STMT=>'DML',SCHEMA_NAME => 'HR', OBJECT_NAME=> 'EMP%'); PL/SQL procedure successfully completed. SQL> select error, statement_opt, name from dba_logstdby_skip where owner='HR'; ERROR STATEMENT_ NAME ---------- ---------- ---------- N DML EMP_NEW N DML EMP_OLD SQL> EXECUTE DBMS_LOGSTDBY.UNSKIP (STMT=>'DML',SCHEMA_NAME => 'HR', OBJECT_NAME=> 'EMP_NEW'); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_LOGSTDBY.UNSKIP (STMT=>'DML',SCHEMA_NAME => 'HR', OBJECT_NAME=> 'EMP_OLD'); PL/SQL procedure successfully completed. SQL> select error, statement_opt, name from dba_logstdby_skip where owner='HR'; no rows selected SQL>

upvoted 2 times

...

JESUSBB

2 years, 1 month ago

Answer: B

upvoted 1 times

...

alexz1

2 years, 6 months ago

Selected Answer: B

Answer: B (tested)

upvoted 1 times

...