Oracle Exam 1Z0-066 Topic 1 Question 22 Discussion

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

Question #: 22
Topic #: 1

Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.)

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

BThey can be used to skip ALTER SYSTEM and ALTER DATABASE commands.

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

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

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

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

GThey can be used to skip CREATE TABLE commands.

Show Suggested Answer

Suggested Answer: A, C, F, G

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.

by An at May 08, 2022, 11:10 AM

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!