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.)

Posted by: Pdfprep Category: C2090-320 Tags: , ,

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

Leave a Reply

Your email address will not be published.