IBM

C2090-320 · Question #22

Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?

The correct answer is B. The qualifier for a DGTT is SESSION. eglobaltemptable.html

Information Analyzer Architecture and Components

Question

Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?

Options

AA DGTT is only stored in memory
BThe qualifier for a DGTT is SESSION
CThe DGTT can be specified in a referential constraint
DAll privileges associated with the DGTT are stored in the DB2 catalog

How the community answered

(40 responses)

A
10% (4)
B
83% (33)
C
5% (2)
D
3% (1)

Explanation

eglobaltemptable.html

Topics

#DGTT#SESSION qualifier#temporary table#DECLARE GLOBAL

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-320 Practice