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
Complety answer
EMPDET is an external table containing the columns EMPNO and ENAME.
Which command would work in relation to the EMPDET table?
C
The correct answer should be rectified.
“C.
CREATE VIEW empvu
AS
SELECT* FROM empdept;”
In the statement, it reads “emptdePt”. This statement would not work.
It probably should read “empdet” like in the other two answers.