Zend
ZF-100-500 · Question #16
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 A. 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
Options
- Acreate unique index foox on foo (c1) include (c3)
- Bcreate index foox on foo (c1)
- Ccreate index foox on foo (c1,c3)
- Dcreate unique index foox on foo (c1,c3)
How the community answered
(25 responses)- A72% (18)
- B8% (2)
- C16% (4)
- D4% (1)
Community Discussion
No community discussion yet for this question.