Punjab Technical University 2008 B.C.A Computer Application Database management system - Question Paper
[Total No. of Pages : 02
Roll No............................
Total No. of Questions : 13]
(Please fill this Paper ID in OMR Sheet)
BCA (402) (Old) (Sem. - 4th)
DBMS
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) Section - A is Compulsory.
2) Attempt any Nine questions from Section - B.
Section - A
a) What is database?
b) Describe few disadvantages of databases.
c) Define data independence.
d) What is partial key?
e) Differentiate referential integrity constraints and entity integrity constraints.
f) Describe the division operation in relation algebra.
g) Describe the types of relational calculus.
h) What is multivalued dependency?
i) What is the need of normalization? j) Describe DML statements in SQL.
k) What is the difference between UNDO and REDO operation?
l) What is database audit?
m) Describe inplace updating and dirty read in concurrency problem.
n) What is the difference between horizontal and vertical fragmentation?
o) Describe WAL (write ahead logging) protocol.
Q2) What is database administrator? Explain its responsibilities.
Q3) Explain three level architecture of database.
Q4) Compare Network, Hierarchical and Relational models.
Q5) Explain the naming conventions in design of E-R model.
Q6) What is relational algebra? Explain different relational algebra operations.
Q7) Explain different constraints in SQL.
Q8) What is normalization? Explain first three normal forms.
Q9) What are inference rules? How we can derive further rules using Armstrong rules.
QIO) What is database recovery? Explain immediate update and deffered update technique of recovery.
QII) What is shadow paging? Explain its advantages and disadvantages.
Q12) Explain the structure of distributed databases.
Q13) What is database security? Explain different security techniques.
D - 278 P
Attachment: |
Earning: Approval pending. |