Q28 Which two statements are true about GLOBAL TEMPORARY TABLES?
- A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- B) GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- C) A GLOBAL TEMPORARY TABLE’s definition is available to multiple sessions.
- D) A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- E) A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
Answers: C,D