Multiple choice technology databases

create global temporary table employee (eno number, ename varchar(20));

  1. Error generates

  2. Temporary table is created with name "employee" and it get removed at the end of transaction.

  3. similar to normally creating table.

  4. created in database permenantly
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

GLOBAL TEMPORARY TABLE creates a table structure visible to all sessions but data is private to each session and temporary. Unlike permanent tables (D), the data is not persisted. The table definition persists but data is automatically cleaned up either at transaction end or session end depending on ON COMMIT settings. The syntax shown is valid SQL (Oracle), so no error is generated (A is incorrect).

Keep practicing — related questions