3 Months Free Update
Examine this DECLARE section:
Which two lines are valid? (Choose two.)
line 5
line 6
line 7
line 4
line 3
line 2
Which block of code displays the error message “Incorrect price value”?
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
Which three are true about DDL triggers? (Choose three.)
They cannot include the WHEN clause.
They must be created in an enabled state.
They can be fired when a table is truncated.
They fire only when a DDL statement is executed by the owner of the trigger.
They can be fired either before or after a DDL statement executes.
They can be fired when a privilege is granted to a user.
They must be created in a disabled state.
TESTED 03 May 2024