Multiple choice technology databases

In NPS, by default, what is used to signal the end of a line or SQL command within an nzsql session?

  1. single quote

  2. semicolon

  3. double quote

  4. colon

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The semicolon is the standard SQL command terminator in nzsql (Netezza's SQL interface, similar to PostgreSQL). It signals to the SQL parser that the command is complete and ready for execution. Quotes are for string literals, not command termination.