INTRODUCTION TO DATABASE MANAGEMENT SYSTEM - 2018 | B.SC CS 3RD YEAR | MJPRU | EXAM PAPER | My CS Tutorial

Database management system | My CS Tutorial

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?

_______________________________________

Please share this post and blog link with your friends.For more programs use this blog.

If you have any problem, please comment in comment box, subscribe this blog for notifications of new post on your email and follow this blog.If you have any method of this tutorial or program or want to give any suggestion send email on hc78326@gmail.com

Created by-- HARSH CHAUHAN