IBM Exam C2090-616 Topic 3 Question 11 Discussion

Actual exam question for IBM's C2090-616 exam

Question #: 11
Topic #: 3

Given the following statement:

DECLARE GLOBAL TEMPORARY TABLE TEMP1 (

ID INTEGER NOT NULL,

ITEM CHAR(30),

AMOUNT DECIMAL (10,2)

ON COMMIT DELETE ROWS NOT LOGGED;

Which of the following statements are TRUE? (Choose two.)

ATemp1 table is accessed under schema SESSION

BTemp1 definition is available for use by other sessions

CAt the end of a transaction, data is deleted automatically

DDefinition of the table Temp1 is stored in database catalog

ERows inserted by one session are visible in other sessions

Show Suggested Answer

Suggested Answer: A, C

by Viva at May 07, 2022, 05:20 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!