Oracle
1Z0-882 · Question #8
1Z0-882 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
Which of the following will CREATE a table with exactly one multi-column index?
Options
- ACREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id), INDEX
- BCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id), INDEX(name) )
- CCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX name_id(id, name) )
- DCREATE TABLE names ( id INT, name CHAR(20) NOT NULL, INDEX(id,name) )
- EAn index cannot be made to extend across multiple columns.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.