1.

EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?

A. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234;
B. DELETE FROM empdetWHERE ename LIKE 'J%';
C. CREATE VIEW empvuASSELECT * FROM empdept;
D. CREATE INDEXempdet_idxON empdet(empno);
Answer» D. CREATE INDEXempdet_idxON empdet(empno);


Discussion

No Comment Found

Related MCQs