click below
click below
Normal Size Small Size show me how
database f4
| Question | Answer |
|---|---|
| The ____ trigger timing executes the trigger body before the triggering DML event on a table. | BEFORE |
| The conditional predicates are: _______, DELETING, UPDATING. | INSERTING |
| DML Trigger is classified in two ways: when they execute, how they execute. Group of answer choices True False | FALSE |
| The Conditional Predicates keywords are automatically declared Boolean variables which are set to TRUE or FALSE by the Oracle server. These keywords maybe used in the trigger body instead of UPDATE, INSERT, DELETE. | TRUE |
| The EXECUTE is a statement is used to invoke procedure in a trigger. | FALSE |
| Which DDL statements cause a DDL trigger to fire? Group of answer choices ALTER, DROP CREATE, ALTER, DROP CREATE, DROP CREATE, ALTER | CREATE, ALTER, DROP |
| An ON DATABASE fires the trigger for ____ on all schemas in the database. Group of answer choices EVENTS DML DDL Not in the options | DDL |