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

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

Answer options

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

Correct answer: A, C, F, G

Explanation

The correct answers A, C, F, and G pertain to valid uses of SQL Apply filters in a logical standby database. Option A is correct as filters can skip DML triggers while executing the DML. Option C is accurate since SQL Apply can be halted upon encountering an error. Option F is correct because filters can skip ALTER TABLE commands on specified tables, and option G is valid as filters can also skip CREATE TABLE commands. Options B, D, and E are incorrect as they do not accurately describe the capabilities of SQL Apply filters.