Multiple choice technology databases

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

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

  2. When a SELECT statement returns more than one row

  3. When a SELECT statement returns no rows

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

In PL/SQL, a SELECT INTO statement raises a NO_DATA_FOUND exception if it returns zero rows, and a TOO_MANY_ROWS exception if it returns more than one row. Mismatched datatypes raise different runtime errors, while a missing INTO clause is a syntax/compilation error rather than a raised runtime exception.

Keep practicing — related questions