Oracle Exam 1Z0-888 Topic 14 Question 4 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 4
Topic #: 14

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.)

AThere are three indexes on the table.

BThere is a redundant index on the dept_no column.

CThe secondary indexes are optimized for unique key look-ups.

DThe values on the emp_no column must be unique.

EThe selectivity of the dept_no column is the best of the indexed columns.

FThere is a redundant index on the emp_no column.

Show Suggested Answer

Suggested Answer: C, F

by Tawna at May 03, 2022, 01:21 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!