Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 48 of 50

Marks: +1, -0

Evaluate the following CREATE TABLE command:

Which statement is true regarding the above SQL statement?

It would execute successfully and only ORD_ITM_IDX index would be created.
It would give an error because the USING INDEX clause cannot be used on a composite primary.
It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command

Go to Question:

Prev Question

Next Question