EMPDET is an external table containing the columns EMPNO and ENAME. Which
command would work in relation to the EMPDET table?
A.
UPDATE empdet SET ename = ‘Amit’ WHERE empno = 1234;
B.
DELETE FROM empdet WHERE ename LIKE ‘J%’;
C.
CREATE VIEW empvu AS SELECT* FROM empdept;
D.
CREATE INDEX empdet_idx ON empdet(empno);