PrepAway - Latest Free Exam Questions & Answers

Which two statements are correct in DB2 9?

Which two statements are correct in DB2 9? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
WORKFILE database is used for storing DB2 global temporary tables.

B.
WORKFILE database supports 4 KB, 8 KB, 12 KB or 32 KB page sizes.

C.
In a data sharing environment, all data sharing members use a single WORKFILE database.

D.
TEMP database is used for storing external (user-defined) declared global temporary tables.

E.
WORKFILE database is used for processing SQL with materializing views, triggers,nested table
expressions.


Leave a Reply