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?
SQL Apply filters for a logical standby database can be used to skip ALTER SYSTEM and ALTER DATABASE commands, which means that certain administrative commands can be excluded from applying to the standby database. They can also be used to stop SQL Apply if it encounters an error by specifying rules that determine actions upon encountering errors. Additionally, these filters can skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB), providing control over SQL statements in a multitenant environment. They can also be used to skip ALTER TABLE commands on specific tables, allowing selective application of DDL changes to particular tables. Other options like skipping DML triggers or CREATE TABLE commands either are not feasible or need additional considerations, making options B, C, D, and F the true statements regarding SQL Apply filters.
I think D is TRUE (DBMS_LOGSTDBY.SKIP(stmt => 'CONTAINER', object_name => 'PDB1'); And I think A is FALSE. (At least I haven't found a way to skip the trigger and allow data modification). Therefore, in my opinion, the correct answer is CDFG
I THINK IS CDFG
B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands. It's another database. C. They can be used to stop SQL apply if it encounters an error. It continue with an error E. They can only be used to skip DML statements on a table. It's not only for skyp DML, skip error an skip transactions.
C,D,F,G SQL> execute DBMS_LOGSTDBY.SKIP(stmt => 'CONTAINER', object_name => 'DEV1'); PL/SQL procedure successfully completed. SQL> select error, statement_opt, name from dba_logstdby_skip; ERROR STATEMENT_ NAME ---------- ---------- ---------- N CONTAINER DEV1
Answer: C, D, F and G