Oracle
1Z0-047 · Question #24
1Z0-047 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. In the ORD table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables the composite PRIMARY KEY is (ORD_NO, ITEM_NO). Which two CREATE INDEX statements are valid? (Choose two.)
Exhibit
Options
- ACREATE INDEX ord_idx
- BCREATE INDEX ord_idx
- CCREATE INDEX ord_idx
- DCREATE INDEX ord_idx
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.