IBM Exam Questions

Which statement is correct?

Given the following CREATE TABLE statement:

Which statement is correct?

A.
A range-clustered table is created and only values from 1 to 1000000 can be stored in the
STUDENT_ID column.

B.
A range-partitioned table is created and only values from 1 to 1000000 can be stored in the
STUDENT_ID column.

C.
A range-clustered table is created and values outside the range of 1 to 1000000 can be stored
in the STUDENT_ID column.

D.
A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored
in the STUDENT_ID column.

Explanation: