Empdet Is An External Table Containing The Columns Empno And #121
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 Concurrency Control - Insertion Deletion Predicate Reads - Quiz No.1.
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);Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
