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