DBMS-II ECE

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

• 1. DML(Data Manipulation Language)

• Query

• Relational Schema

• 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?

• 1. DML(Data Manipulation Language)

• 1. DDL(Data Definition Language)

• 1. Query

• Relational Schema

3) The given Query can also be replaced with_______:

1. SELECT name, course_id  

2. FROM instructor, teaches  

3. WHERE instructor_ID= teaches_ID;  

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

• 1. Select name, course_id from instructor natural join teaches;

• 1. Select name, course_id from instructor;

• Select course_id from instructor join teaches;

4.What do you mean by one to many relationships?

• 1. One class may have many teachers

• 1. One teacher can have many classes

• 1. Many classes may have many teachers

• Many teachers may have many classes

5.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?

1. SELECT *  

2. FROM instructor  

3. ORDER BY salary ____, name ___;  

• 1. Ascending, Descending

• 1. Asc, Desc

• 1. Desc, Asc

• All of the above

6.A Database Management System is a type of _________software.

• 1. It is a type of system software

• 1. It is a kind of application software

• 1. It is a kind of general software

• Both A and C

7.

A huge collection of the information or data accumulated form several different sources is known as ________:

• 1. Data Management

• 1. Data Mining

• 1. Data Warehouse

• Both B and C

8.Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.

• 1. Data Repository

• 1. Data Inconsistency

• 1. Data Mining

• Data Redundancy

9.Which one of the following refers to the "data about data"?

• 1. Directory

• 1. Sub Data

• 1. Warehouse

• Meta Data

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

• 1. Conceptual Level

• 1. Physical Level

• 1. File Level

• Logical Level