PdfPrep.com

Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)

Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)
A . MAXPARTITIONS
B . ENDING AT clause on a CREATE INDEX statement for the table
C . MEMBER CLUSTER
D . ENDING AT clause on the CREATE TABLE statement
E . A LOB column specified as a column of the partitioning key

Answer: BE

Exit mobile version