IBM
A2090-614 · Question #48
The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an…
The correct answer is D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person). See the full explanation below for the reasoning.
Question
The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
Options
- ACREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
- BCREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
- CCREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
- DCREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
How the community answered
(32 responses)- A9% (3)
- B3% (1)
- C6% (2)
- D81% (26)
Community Discussion
No community discussion yet for this question.