IBM

P2090-050 · Question #23

When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?

The correct answer is C. Statistics will automatically be generated. See the full explanation below for the reasoning.

Question

When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?

Options

AGroom will be automatically invoked.
BPrimary key constraints will be checked.
CStatistics will automatically be generated.
DMaterialized views will be automatically generated.

How the community answered

(31 responses)

A
13% (4)
B
6% (2)
C
77% (24)
D
3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full P2090-050 Practice