You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?A. CREATE index empno_idx ON employee, empno;B. CREATE index emp_empno_idx FOR employee, empno;C. CREATE index emp_empno_idx ON employee(empno);D. CREATE emp_empno_idx index ON employee(empno);

C

Showing Answers 1 - 5 of 5 Answers

bhawesh

  • Nov 5th, 2007
 

Third option i.e c is Correct

  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