Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
A.
Each application that defines a DGTT has its own instance of the DGTT
B.
Two different applications cannot create DGTTs that have the same name
C.
DGTTs can only be used by the application that creates them, and only for the life of the
application
D.
Data stored in a DGTT can exist across transaction boundaries
The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for the current session. The declared temporary table description does not appear in the system catalog. It is not persistent and cannot be shared with other sessions. Each session that defines a declared global temporary table of the same name has its own unique description of the temporary table. When the session terminates, the rows of the table are deleted, and the description of the temporary table is dropped.
Invocation
This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.
Authorization
The privileges held by the authorization ID of the statement must include at least one of the following:
USE privilege on the USER TEMPORARY table space
SYSADM or DBADM authority
When defining a table using LIKE or a fullselect, the privileges held by the authorization ID of the statement must also include at least one of the following on each identified table or view:
SELECT privilege on the table or view
CONTROL privilege on the table or view
SYSADM or DBADM authority
0
0