Multiple choice technology databases

Which one of the following contains only valid PL/SQL reserved words?

  1. TO_CHAR, INOUT

  2. PROC, PACKAGE

  3. PRAGMA, MULTI_ROW

  4. SELECT, EXCEPTION
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SELECT and EXCEPTION are both valid PL/SQL reserved words. SELECT is used for querying data, and EXCEPTION is used in exception handling blocks. The other options contain invalid words: INOUT is not a reserved word (it's a parameter mode), PROC is not reserved (PROCEDURE is), and MULTI_ROW is not a PL/SQL reserved term.

Keep practicing — related questions