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


Showing Answers 1 - 3 of 3 Answers


  • 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