Punjab Technical University 2007 B.B.A ( 5/6sem)- DATA BASE MANAGEMENT SYSTEM (-1005) - Question Paper

BBA (Semester - fifth & 6th)

DATA BASE MANAGEMENT SYSTEM (BBA-1005)

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

Section-A
Q1) [15 × two = 30]
a) Why can the failure in a data base environment be more serious than
one in a non data base environment?
b) elaborate the benefits of a centralized data?
c) How does consistency of data outcome from controlling its redundancy?
d) Who are the users of a DBMS?
e) What can reason inconsistent data? How that can be avoided in a data
base?
f) What is data independence?
g) What do you mean by entity, attributes and relations in database?
h) elaborate the job responsibilities of a DBA?
i) What do you mean by redundancy? elaborate issues associated
with it?
j) elaborate ‘LOCKS’ used in DBMS?
k) What is data abstraction?
l) What is a candidate Key?
m) What do you mean by sharing data?
n) What do you mean by security of data?
o) What is a query? Who handles it in a DBMS?

Section-B
[9 × five = 45]
Q2) elaborate different Data Base Models? discuss in brief.
Q3) elaborate different characteristics of data used by an organization?
Q4) discuss the architecture of a DBMS?
Q5) elaborate different advantages and disadvantages of a Data Base Management
System?
Q6) Design a data base to be used by an educational institute for keeping record
of fee payments, books issued and performance of students.
Q7) How do you sort data in SQL? If there are more than 1 sort keys then
how do you indicate which 1 is the major key?
Q8) How do you join tables in SQL? discuss with the help of an example.
Q9) discuss the choose command and at lowest five clauses used with it?
Q10) How the shared updates reason concurrency issues in databases? discuss
the locking scheme used to deal with the concurrency issue.
Q11) discuss the concepts of ‘Replication’ and ‘Data Independence’.
Q12) What is the purpose of a distributed database? How is it various from a
centralized database?
Q13) elaborate different data definition and data manipulation commands?

Earning:   Approval pending.