Multiple choice technology programming languages

PL/SQL raises an exception, in which TWO of the following cases:

  1. When a SELECT statement returns no rows

  2. When a SELECT statement returns more than one row

  3. When the datatypes of SELECT clause and INTO clause do not match

  4. When INTO statement is missing in the SELECT statement
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

PL/SQL's implicit SELECT...INTO statement raises NO_DATA_FOUND when zero rows are returned and TOO_MANY_ROWS when multiple rows return. These are predefined runtime exceptions. Datatype mismatch raises VALUE_ERROR during assignment, and missing INTO causes a compile-time error.

Keep practicing — related questions