CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?
Answer options
A
May reduce the amount of disk I/O for SELECT statements.
B
Stores an index in the EMPLOYEE table.
C
Increases the chance of full table scans.
D
Overrides the unique index.
Correct answer: May reduce the amount of disk I/O for SELECT statements.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.