Multiple choice technology databases

What is the smallest possible PL/SQL block?

  1. Begin null; end;

  2. Declare x varchar2(100); begin dbms_output.put_line(x); end;

  3. Begin .. statement1; exception ... end;

  4. Begin dbms_output.put_line(sysdate); end;;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The smallest possible PL/SQL block is 'BEGIN NULL; END;'. This is a valid PL/SQL block that does nothing - it executes a NULL statement. PL/SQL requires at least one executable statement between BEGIN and END, and NULL is the minimal statement that satisfies this requirement. Options B and D include additional statements or declarations, making them larger than minimal. Option C is incomplete syntax with '.. statement1' placeholder.

Keep practicing — related questions