Multiple choice

SQL*Plus will finish the statement and execute it when the user types _______.

  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

The semicolon is the standard SQL statement terminator in SQL*Plus. When you type a semicolon and press Enter, SQL*Plus recognizes the statement as complete and executes it. The forward slash (/) is used to execute the contents of the SQL buffer, not terminate a new statement. The colon (:) is used for bind variables in SQL*Plus. The period (.) is used in some SQL implementations but not in Oracle SQL*Plus for statement termination.

Keep practicing — related questions