Dr.C.M-DBMS Quiz

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

• DML(Data Manipulation Language)

• Query

• Relational Schema

• DDL(Data Definition Language)

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?

• DML(Data Manipulation Language)

• DDL(Data Definition Language)

• Query

• Relational Schema

The given Query can also be replaced with_______:

SELECT name, course_id  

FROM instructor, teaches  

WHERE instructor_ID= teaches_ID;  

• Select name,course_id from teaches,instructor where instructor_id=course_id;

• Select name, course_id from instructor natural join teaches;

• Select name, course_id from instructor;

• Select course_id from instructor join teaches;

Which one of the following given statements possibly contains the error?

• select * from emp where empid = 10003;

• select empid from emp where empid = 10006;

• select empid from emp;

• select empid where empid = 1009 and Lastname = 'GELLER';

What do you mean by one to many relationships?

a. One class may have many teachers

b. One teacher can have many classes

c. Many classes may have many teachers

d. Many teachers may have many classes

• A

• B

• C

• D

In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?

SELECT *  

FROM instructor  

ORDER BY salary ____, name ___;  

• Ascending, Descending

• Asc, Desc

• Desc, Asc

• All of the above

A Database Management System is a type of _________software.

• It is a type of system software

• It is a kind of application software

• It is a kind of general software

• Both A and C

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

• Conceptual Level

• Physical Level

• File Level

• Logical Level

In general, a file is basically a collection of all related______.

• Rows & Columns

• Fields

• Database

• Records

In a relation database, every tuples divided into the fields are known as the______.

• Queries

• Domains

• Relations

• All of the above