Multiple choice technology programming languages

What can be said of the following SQL statement? CREATE GLOBAL TEMPORARY TABLE extra_area (startdate DATE, enddate DATE, class CHAR(15)) ON COMMIT DELETE ROWS

  1. It is a session specific table.

  2. It is an invalid SQL statement.

  3. It is only available in Oracle 7

  4. It is a transaction specific table.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The ON COMMIT DELETE ROWS clause makes this a transaction-specific temporary table - rows are automatically deleted when the transaction commits. This differs from ON COMMIT PRESERVE ROWS (session-specific) where rows persist for the entire session. Global temporary tables with ON COMMIT DELETE ROWS are cleaned up at transaction end, not session end.

Keep practicing — related questions