IBM Exam Questions

Which two statements are correct in DB2 9?

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

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.