Which command would work in relation to the EMPDET table?

Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

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