EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET t
Posted: Wed Jun 07, 2023 6:11 am
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);
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);