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 *