The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

technology databases

  1. select * from EMP where nvl(EMPNO, '00000') = '59384'

  2. select * from EMP where EMPNO = '59384'

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384'

  4. select 1 from EMP where EMPNO = '59834'

Show answer
Correct Option: A

Find more quizzes: