Consider the following statement: Which indexes should be created for optimal query performance?

Question

Options

• ACREATE INDEX emp_idx ON employee (workdept);
• BCREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON
• CCREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON
• DCREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX

• A
  5% (1)
• B
  5% (1)
• C
  79% (15)
• D
  11% (2)

No community discussion yet for this question.