Multiple choice

SQL*Plus will finish the statement and execute it when the user types in this:

  1. A left slash ( ) followed by [Enter].

  2. A colon ( : ) followed by [Enter].

  3. A semicolon ( ; ) followed by [Enter].

  4. A period ( . ) followed by [Enter].
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SQL*Plus, a semicolon followed by the Enter key signals that the SQL statement is complete and ready for execution. The semicolon acts as a statement terminator in SQL*Plus. Option A is incorrect - a forward slash (/) executes statements in the buffer but doesn't terminate statement entry. Option B's colon is used for bind variables, not statement termination. Option D's period has no special meaning in SQL*Plus statement termination.

Keep practicing — related questions