The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?A. select * from EMP where nvl(EMPNO, '00000') = '59384';B. select * from EMP where EMPNO = '59384';C. select EMPNO, LASTNAME from EMP where EMPNO = '59384';D. select 1 from EMP where EMPNO = '59834';

  • Interview Candidate
  • 9
  • 20077

Showing Answers 1 - 9 of 9 Answers

vadivel

  • Feb 6th, 2006
 

answer is : D because 1 is not a column name

  Was this answer useful?  Yes

nishathfaiza

  • Feb 22nd, 2011
 

Option A

The index will be automatically created on the primary key column.
If any of the functions are used on that column then the index created on that column will not work.

In option 'A' nvl() is used on EMPNO so this statement will not use the associated index on EMPNO

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.