1Z0-888 Exam Dumps | Consider the index information for the dept_emp table in the employee's schema: (Exhibit) Which two conclusions

<< Prev Question Next Question >>

Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

A. The values on the emp_no column must be unique.

B. There is a redundant index on the dept_no column.

C. The selectivity of the dept_no column is the best of the indexed columns.

D. There is a redundant index on the emp_no column.

E. There are three indexes on the table.

F. The secondary indexes are optimized for unique key look-ups.

Download PDF File