IBM
A2090-560 · Question #27
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
(38 responses)- A13% (5)
- B3% (1)
- C79% (30)
- D5% (2)
Community Discussion
No community discussion yet for this question.