Empdet Is An External Table Containing The Columns Empno And #45
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 Transactions - Implementation of Isolation Levels - 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