nerdexam
IBM

A2090-614 · Question #33

Given the following CREATE TABLE statement: Which statement is correct?

The correct answer is C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in. See the full explanation below for the reasoning.

Question

Given the following CREATE TABLE statement:

Which statement is correct?

Exhibit

A2090-614 question #33 exhibit

Options

  • AA range-clustered table is created and only values from 1 to 1000000 can be stored in the
  • BA range-partitioned table is created and only values from 1 to 1000000 can be stored in the
  • CA range-clustered table is created and values outside the range of 1 to 1000000 can be stored in
  • DA range-partitioned table is created and values outside the range of 1 to 1000000 can be stored

How the community answered

(54 responses)
  • A
    9% (5)
  • B
    4% (2)
  • C
    72% (39)
  • D
    15% (8)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice