Oracle
1Z0-146 · Question #143
Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables. Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which result will the…
The correct answer is C. May reduce the amount of disk I/O for SELECT statements. See the full explanation below for the reasoning.
Question
Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables. Evaluate this SQL statement:
CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which result will the statement provide?
Exhibit
Options
- AStore an index in the EMPLOYEE table.
- BIncrease the chance of full table scans.
- CMay reduce the amount of disk I/O for SELECT statements.
- DMay reduce the amount of disk I/O for INSERT statements.
- EOverride the unique index created when the FK relationship was defined.
How the community answered
(54 responses)- A6% (3)
- B4% (2)
- C76% (41)
- D2% (1)
- E13% (7)
Community Discussion
No community discussion yet for this question.