Zend
200-530 · Question #19
200-530 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 200-530 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
Given a table created as shown below: create table foo (c1 int, c2 int, c3 int, c4 char(10)) If column c1 has a cardinality of 10, column c2 has a cardinality of 5000, and column c3 has a cardinality of 5000000, which of the following indexes would optimize the following statement? Select c1,c2,c3 from foo where c1=100 and c2= 100 and c3 = 100
Options
- Acreate index foox on foo (c1,c2,c3)
- Bcreate index foox on foo (c2,c1,c3)
- Ccreate index foox on foo (c3,c2,c1)
- Dcreate index foox on foo (c3,c1,c2)
Unlock 200-530 to see the answer
You've previewed enough free 200-530 questions. Unlock 200-530 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.