Which statements are true? (Choose all that apply)
A.
If errors occur during the compilation of a trigger, the trigger is still created.
B.
If errors occur during the compilation of a trigger you can go into SQL *Plus and query the
USER_TRIGGERS data dictionary view to see the compilation errors.
C.
If errors occur during the compilation of a trigger you can use the SHOW ERRORS command
within iSQL *Plus to see the compilation errors.
D.
If errors occur during the compilation of a trigger you can go into SQL *Plus and query the
USER_ERRORS data dictionary view to see compilation errors.
Explanation:
A: If there is a compilation error in the CREATE TRIGGER statement, the trigger is still created.
C: You may view the compilation errors in SQL*Plus by issuing the SHOW ERRORS command.
D: The TEXT column of the USER_ERRORS View contains the compilation errors. The LINE
Column stored the LINE number of the error and the POSITION column contains the character
POSITION of the LINE identified in the line COLUMN .