1) Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation? a) DML(Data Manipulation Language) b) Query c) Relational Schema d) DDL(Data Definition Language) 2) Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database? a) DML(Data Manipulation Language) b) DDL(Data Definition Language) c) Query d) Relational Schema 3) The given Query can also be replaced with_______: SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID; a) Select name,course_id from teaches,instructor where instructor_id=course_id; b) Select name, course_id from instructor natural join teaches; c) Select name, course_id from instructor; d) Select course_id from instructor join teaches; 4) Which one of the following given statements possibly contains the error? a) select * from emp where empid = 10003; b) select empid from emp where empid = 10006; c) select empid from emp; d) select empid where empid = 1009 and Lastname = 'GELLER';

database management

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?