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';

Showing Answers 1 - 13 of 13 Answers

vadivel

  • Feb 6th, 2006
 

answer is : D because 1 is not a column name

  Was this answer useful?  Yes

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.

 

Related Answered Questions

 

Related Open Questions