Oracle
1Z0-514 · Question #65
You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)
The correct answer is A. addition of new data to the EMP table B. deletion of existing row from the EMP table E. queries that search for data based on a condition on the ENAME column. See the full explanation below for the reasoning.
Question
You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)
Options
- Aaddition of new data to the EMP table
- Bdeletion of existing row from the EMP table
- Cmodification of data in any column in the EMP table
- Dall queries that display data from the ENAME column
- Equeries that search for data based on a condition on the ENAME column
How the community answered
(28 responses)- A75% (21)
- C7% (2)
- D18% (5)
Community Discussion
No community discussion yet for this question.