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

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM 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, 2019
Paper No. 3.2
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

Time: Three Hours][Maximum Marks: 50

Note: Attempt any five questions in all selecting one question from each section. All questions carry equal marks.

Section-A

1. What is data ? Explain the term “DBMS”. how does DBMS is different from traditional file management system ?

2. Describe various aspects of file organization with respect to the physical allocation.

Section-B

3. Explain the following data models with examples :

  (i) Relational

  (ii) Hierarchical

  (iii) Network

4. What is the process of database design ? Describe “SQL” in detail.

Section-C

5. Explain various approaches for data integrity.

6. Write down about the following concepts :

  (a) Consistency

  (b) Security

  (c) Privacy

  (d) Authentication

Section-D

7. Describe the concept of data fragmentation in detail.

8. What do you mean by “Deadlock” ? What are the factors responsible for deadlock condition ? How deadlocks are prevented ?

_______________________________________

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 program or want to give any suggestion send email on hc78326@gmail.com

Created by-- HARSH CHAUHAN