D.B.M.S OF OU FOR MCA

Labels: - Monday, May 25, 2009

Answer one question from each unit
All questions carry equal marks.
Unit-I

1. Expalin the following :
(a) Aggression in E-R model
(b) Unified modeling language
(c) Foreign key Constraint
(d) Armstrong Axioms

Or

2. (a) Describe about 'Loss-Less Join Decoposition'.
(b) Explain how to find the minimal cover of a set of Functional Dependencies.
(c) Explain abot the followin.
(i) Views (ii) Attribute Closure



UnitII

3.(a) Give Syntax and examples for the following operations relational algebra.
Rename Division

(b) Differentiate between 'Tuple Relational calculys' and 'Domain Relational Calculus'. Give suitable examples

Or


4. (a) Explain the purpose of 'Group by' and 'Having' clasues in SQL



Unit-III


5 (a) Differentiate between 'Primary Indexing' and 'Secodary Indexing'


Or

6 (a) Discuss about 'Linear Hashing'.

(b) Explain Following

Hash Function Directory doubling Extendedable Hashing



Unit-IV


8. Differece between ;Conflict Equivalwent' and 'Conflict serializable'. Give an example


or

9. What is meant by 'Role based Authorization control' in sql.



Unit-V

10. Explain following

(1) Write- Ahead Logging

(b) Explain fallowing:

(i) Dirty page table (ii) Composition Log record