🎴 Flashcard Mode

SQL, Data Modeling, and PL/SQL Quiz

Card1 / 19
Mastered0
Review0
QuestionClick to flip

PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows

AnswerClick to flip back
A
True
💡 Explanation:

PL/SQL automatically raises NO_DATA_FOUND exception when a SELECT INTO statement returns no rows. This is a predefined exception that triggers when a single-row query fails to find any matching data. Unlike explicit error checking, this built-in mechanism handles empty result sets gracefully.

Change Mode