Punjab Technical University 2007 B.B.A DATA BASE MANAGEMENT SYSTEM - Question Paper

Roll No. ......................
Total No. of ques. : 13] [Total No. of Pages : 02
Paper ID [B0148]
(Please fill this Paper ID in OMR Sheet)
BBA (1005) (S05) (Sem. - 5th/6th)

DATA BASE MANAGEMENT SYSTEM
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) part -A is Compulsory.
2) Attempt any 9 ques. from part - B.

part - A
(15 × two = 30)
Q1)
a) What is difference ranging from data and information?
b) What is a data base?
c) What do you mean by data Integrity?
d) discuss the concepts of file, record and field?
e) What do you mean by inconsistent data?
f) What do you mean by an entity in data base?
g) elaborate the job responsibilities of a system administrator?
h) What do you mean by redundancy? elaborate issues associated
with it?
i) Why do we need data recovery?
j) What do you mean by redundancy? elaborate issues associated
with it?
k) What is DML?
l) What is a primary Key?
m) What is a distributed data base?
n) elaborate the necessary fields in a data base for Library management
system?
o) What is a computer NETWORK? elaborate its advantages?
J-8032[S-9700449] P.T.O.

part - B
(9 × five = 45)
Q2) elaborate different components of a Data Base Management System?
discuss in brief.
Q3) discuss the three levels of a DBMS?
Q4) elaborate different issues associated with a Data Base Management
System? How the size of a data base can be a disadvantage?
Q5) What is meant by security of data? elaborate the different threats to the
security of data in a data base?
Q6) elaborate data models? elaborate main differences ranging from Hierarchical
and network model of data bases?
Q7) discuss the various kinds of keys used in relational data base models?
Q8) elaborate integrity rules? discuss different forms of these rules with the
help of an example data base.
Q9) elaborate relations in a RDBMS? For which kind of operations in a data
base they are helpful?
Q10) What is the purpose of subsequent commands in SQL:
(a) CREATE (b) INSERT (c) DELETE (d) UPDATE
(e) choose
Q11) How do you use in-built functions in SQL? discuss 4 in-built functions
of SQL.
Q12) elaborate different concurrency related issues in data bases? How they
can be controlled?
Q13) elaborate different techniques to recover data in a data base?
Q
J-8032[S-9700449] 2

Earning:   Approval pending.