Exam C2090-616 topic 1 question 31 discussion

I agree the correct answer is A & C

You have also the statement CREATE GLOBAL TEMPORARY, which is different of "DECLARE GLOBAL TEMPORARY" statement. The CREATE GLOBAL TEMPORARY TABLE statement creates a description of a temporary table at the current server. But, each session that selects from a created temporary table retrieves only rows that the same session has inserted. When the session terminates, the rows of the table associated with the session are deleted. See reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0053719.html

The correct answer are : A. Temp1 table is accessed under schema SESSION C. At the end of a transaction, data is deleted automatically See reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0003272.html he 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.