Database Management System Set 1

1.

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)

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?

DML(Data Manipulation Language) DDL(Data Definition Language) Query Relational Schema

3.

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;

4.

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';

5.

What do you mean by one to many relationships?

One class may have many teachers One teacher can have many classes Many classes may have many teachers Many teachers may have many classes

6.

Ascending, Descending Asc, Desc Desc, Asc All of the above

7.

8.

A Database Management System is a type of _________software.

It is a type of system software It is a kind of application software t is a kind of general software Both A and C

9.

The term "FAT" is stands for_____

File Allocation Tree File Allocation Table ile Allocation Graph All of the above

10.

Which of the following can be considered as the maximum size that is supported by FAT?

8GB 4GB 4TB None of the above

Database Management System Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Database Management System Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner