Zend
200-530 · Question #476
You have a table created as follows: create table foo (c1 int, c2 char(30), c3 int, c4 char(10)) If column c1 is unique, which of the following indexes would optimize the statement given below?…
The correct answer is B. create unique index foox on foo (c1) include (c3). See the full explanation below for the reasoning.
Question
You have a table created as follows: create table foo (c1 int, c2 char(30), c3 int, c4 char(10)) If column c1 is unique, which of the following indexes would optimize the statement given below? Select distinct (c1), c3 from foo where c1=10 Zend 200-530 Exam
Options
- Acreate index foox on foo (c1,c3)
- Bcreate unique index foox on foo (c1) include (c3)
- Ccreate unique index foox on foo (c1,c3)
- Dcreate index foox on foo (c1)
How the community answered
(29 responses)- A14% (4)
- B76% (22)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.