Oracle
1Z0-047 · Question #113
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…
The correct answer is B. CREATE INDEX ord_idx C. CREATE INDEX ord_idx. See the full explanation below for the reasoning.
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
How the community answered
(38 responses)- A16% (6)
- B79% (30)
- D5% (2)
Community Discussion
No community discussion yet for this question.