Multiple choice

Which of the following assumptions that the DBA can apply during changing process, triggers in Oracle P/L SQL?

  1. In order to change a trigger, use either the SQL Developer tool Edit or the DDL statement.

  2. The triggers state cannot be changed for the list of schema object types.

  3. Triggers cannot be changed in the list of triggers.

  4. Trigger cannot be used for managing the database operations in a frequent manner.

  5. Triggers can be used for data synchronisation.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Developer tools are mostly used in changing triggers. DDL statements CREATE TRIGGER with the OR REPLACE clause are also used.

Keep practicing — related questions