Quiz 1z0-144

Quiz 1Z0-144, Oracle Database 11g, Program with PL/SQL

Which two clauses should be used to fill in the blanks and complete the above code?

Why does it generate an error?

What is the outcome?

Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions?

Which statement correctly describes the output?

Which two statements correctly differentiate functions and procedures?

What is the outcome on execution of the above code?

Which two statements are true about triggers?

Which statement is correct about the unnamed block of code at the end of a package body?

Which two statements are true about the %ROWTYPE attribute?