Server Scripting Quizzes MCQs Quizzes PL/SQL Quiz MCQs

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

Option A):
When the datatypes of SELECT clause and INTO clause do not match
Option B):
When a SELECT statement returns no rows
Option C):
When a SELECT statement returns more than one row
Option D):
When INTO statement is missing in the SELECT statement

Correct Answer is Option B):
When a SELECT statement returns no rows