Punjab Technical University 2009 M.C.A RDBMS - Question Paper

Roll No. …………………
Total No. of ques. : 13 [Total No. of Pages:02]

Paper ID[A0514]
MCA(304)(S05)(O)(LE)(Sem. – 3rd)
RDBMS

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

part A
Q1) (15x2=30)
a) What is database? provide 2 examples.
b) Describe few disadvantages of databases.
c) Define data independence. define its kinds.
d) What is partial key?
e) Differentiate referential integrity constraints and entity integrity constraints.
f) Describe the recursive closure operation in relation algebra.
g) Describe the difference ranging from relational algebra and relational calculus.
h) What is join dependency?
i) What is the need of normalization?
j) Describe DML statements in SQL.
k) What is the difference ranging from UNDO and REDO operations?
l) What is database security?
m) Describe in place updating and dirty learn in concurrency issue.
n) What is the difference ranging from horizontal and vertical fragmentation?
o) Describe WAL(write ahead logging) protocol.

part B
(9 x 5= 45)
Q2) What is database administrator? discuss its responsibilities.
Q3) Explain 3 level architecture of database.
Q4) What is relational model? How it differ from hierarchical model? discuss.
Q5) Explain the naming conventions in design of E-R model.
Q6) What is relational algebra? discuss various set relational algebra operations.
Q7) Explain various constraints in SQL.
Q8) What is normalization? discuss fourth and fifth normal forms.
Q9) What are inference rules? Derive 4th, fifth and sixth rules using Armstrong rules.
Q10) What is database recovery? discuss advantages and disadvantages of shadow paging over other recovery techniques.
Q11) What is the need of concurrency control? discuss various concurrency control techniques.
Q12) Explain the structure of distributed databases.
Q13) What is database security? discuss various security techniques.

Earning:   Approval pending.