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

Based on the Oracle Database 19c documentation, the correct answers about SQL Apply filters for a logical standby database are:

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 CREATE TABLE commands.

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

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

Comprehensive Detailed Explanation:

SQL Apply filters in a logical standby database can be set to control which SQL operations are applied to the standby. These filters allow for certain commands to be skipped, ensuring that they do not impact the standby database. For example, filters can be used to skip the execution of DML triggers to prevent them from firing during SQL Apply, while still allowing the underlying DML to be executed on the logical standby database. This is particularly useful when certain triggers are not desired to run in a standby environment. CREATE TABLE, ALTER SYSTEM, ALTER DATABASE, and specific ALTER TABLE commands can also be skipped using SQL Apply filters to prevent unwanted structural changes or administrative operations from affecting the logical standby database. These capabilities provide a level of control to ensure that the logical standby database reflects only the desired state of the primary database.