Which command would work in relation to the EMPDET table?

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

A.
CREATE VIEW empvu AS SELECT* FROM empdept;

B.
CREATE INDEX empdet_dx ON empdet(empno);

C.
DELETE FROM empdet WHERE ename LIKE ‘J%’;

D.
UPDATE empdet SET ename = ‘Amit’ WHERE empno = 1234;

Explanation: