Evaluate the following CREATE TABLE command: Which statement is true regarding the above SQL statement?

Question

Exhibit

Options

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

• A
  85% (50)
• B
  2% (1)
• C
  8% (5)
• D
  5% (3)

No community discussion yet for this question.