Examine this statement:
On which two columns of the table will an index be created automatically? (Choose two.)
Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 71
Correct Answer: A, F
An index will be created automatically on columns defined with UNIQUE and PRIMARY KEY constraints. In this table, the ORDER_ID column is defined as PRIMARY KEY and SERIAL_NO column is defined as UNIQUE. Therefore, indexes will be created automatically on these two columns.
Discussion
lucemqyOptions: AF
UNIQUE and PRIMARY key constraints will have unique index created automatically