Q:

EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?

mhmadesk

Save to bookmark

|

2022-07-19

|

330

Medium

0

EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?

UPDATE empdet SET ename = \'Amit\' WHERE empno = 1234;
DELETE FROM empdet WHERE ename LIKE \'J%\';
CREATE VIEW empvu AS SELECT * FROM empdept;
CREATE INDEX empdet_idx ON empdet(empno);

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-19

need an explanation for this answer? contact us directly to get an explanation for this answer

(c).CREATE VIEW empvu
AS
SELECT * FROM empdept;

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)