Introduction To Database Management System 2018 – BSc Computer Science Part 3

Paper code: 13526
1526
B.Sc. (Computer Science) (Part 3)
Examination, 2018
Paper No. 3.2
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

Time: Three Hours] [Maximum Marks: 50

Note: Attempt any five questions. All questions carry equal marks.

1. Draw and explain the detailed system architecture of DBMS.

2. (a) What is a view? Explain it.

(b) What are various advantages of DBMS? Explain.

3. (a) Explain the different data types in SQL.

(b) Write the syntax for UPDATE command in SQL.

4. Explain briefly abut 3NF, 4NF and BCNF.

5. Differentiate between the following:

1. Homogenous vs. heterogeneous system
2. Flat file system and DBMS

6. (a) What is hash based indexing?

(b) What is data fragmentation?

7. Define the following:

1. DDL
2. DML
3. DCL

8. (a) What is 2-phase locking protocol? How it guarantee serializability?

(b) What do you mean by Concurrency Control?

……..End……..