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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Abdulali Aliyev

Abdulali Aliyev

C

Prabhmeet

Prabhmeet

No update, insert, delete allowed on external tables. Also we cannot create index on it. So answer is C