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_dx
ON empdet(empno);
C
No update, insert, delete allowed on external tables. Also we cannot create index on it. So answer is C