Which four statements are true regarding SQL Apply filt…

Which four statements are true regarding SQL Apply filters for a logical standby database?

Which four statements are true regarding SQL Apply filters for a logical standby database?

A.
They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

B.
They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.

C.
They can be used to stop SQL apply if it encounters an error.

D.
They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a
standby multitenant container database (CDB).

E.
They can only be used to skip DML statements on a table.

F.
They can be used to skip ALTER TABLE commands on a specific tables.

G.
They can be used to skip CREATE TABLE commands.

Explanation:
A: The DDL fires DML triggers defined on the target table. Since the triggered DMLs occur in the same
transaction as the DDL, and operate on the table that is the target of the DDL, these triggered DMLs will not be
replicated at the logical standby.
C: The SKIP_ERROR Procedure specifies rules regarding what action to take upon encountering errors
F: You can specify rules to prevent application of DML and DDL changes to the specific table.G: Use the SKIP procedure with caution, particularly when skipping DDL statements. If a CREATE TABLE
statement is skipped, for example, you must also specify other DDL statements that refer to that table in the
SKIP procedure. Otherwise, the statements will fail and cause an exception. When this happens, SQL Apply
stops running.
Incorrect Answers:
B: ALTER SYSTEM and ALTER DATABASE commands cannot be skipped.
E: You can specify rules to prevent application of DML and DDL changes to the specific table.
https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ls.htm#SBYDB4805
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lsbydb.htm



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Chunn

Chunn

Correct Ans: C,D,F,G

Chirag

Chirag

C) We cannot stop SQL apply using this feature. But you can skip errors
SQL> EXECUTE DBMS_LOGSTDBY.SKIP_ERROR(‘GRANT’);

Correct Answer- D,E,F,G

tania

tania

E is wrong , you cannot only skip DDL but DML as well.
C is correct
correct answers are : C , D , F , G