Explanation/Reference:
Incorrect Answers:
B: CREATE INDEX
Syntax:
CREATE INDEX [schema.]index ON [schema.]table (column)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
[PARAMETERS ('index_params [physical_storage_params]' )]
[{ NOPARALLEL | PARALLEL [ integer ] }];
C, D: A specific degree of parallelism (DOP) can be requested from Oracle Database for both tables and indexes. For example, you can set a fixed DOP at a table level with the following:
ALTER TABLE sales PARALLEL 8;
ALTER TABLE customers PARALLEL 4;
References: https://docs.oracle.com/database/122/VLDBG/degree-parallel.htm#VLDBG1390