Download Model question papers & previous years question papers
Submit Previous Years University Question Papers
Posted Date: 09 Sep 2008 Posted By:: jalaj Member Level: Gold Points: 5 (Rs. 1)
2007 Punjab Technical University Administration B.B.A BBA(PTU 5/6sem)- DATA BASE MANAGEMENT SYSTEM (BBA-1005) Question paper
BBA (Semester - 5th & 6th)
DATA BASE MANAGEMENT SYSTEM (BBA-1005)
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) Section - A is compulsory.
2) Attempt any Nine questions from Section - B.
Q1) [15 × 2 = 30]
a) Why can the failure in a data base environment be more serious than
one in a non data base environment?
b) What are the benefits of a centralized data?
c) How does consistency of data result from controlling its redundancy?
d) Who are the users of a DBMS?
e) What can cause inconsistent data? How that can be avoided in a data
f) What is data independence?
g) What do you mean by entity, attributes and relations in database?
h) What are the job responsibilities of a DBA?
i) What do you mean by redundancy? What are problems associated
j) What are ‘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?
[9 × 5 = 45]
Q2) What are various Data Base Models? Explain in brief.
Q3) What are various characteristics of data used by an organization?
Q4) Explain the architecture of a DBMS?
Q5) What are various advantages and disadvantages of a Data Base Management
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 one sort keys then
how do you indicate which one is the major key?
Q8) How do you join tables in SQL? Explain with the help of an example.
Q9) Explain the SELECT command and at least 5 clauses used with it?
Q10) How the shared updates cause concurrency problems in databases? Explain
the locking scheme used to deal with the concurrency problem.
Q11) Explain the concepts of ‘Replication’ and ‘Data Independence’.
Q12) What is the purpose of a distributed database? How is it different from a
Q13) What are various data definition and data manipulation commands?
Return to question paper search
and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.