IBM Exam Questions

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy Tabl

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement
to copy TableA to TableB? (Choose two.)

A.
“The views on TableA.

B.
“The privileges on TableA.

C.
“The distribution key of TableB.

D.
“The materialized views on TableB.

E.
“The order of the data stored in TableB.

Explanation: