Pondicherry University 2009 M.C.A Database management system - Question Paper

1. What is database model? discuss all its kinds with an example.(15)

2. a. describe constraints and discuss all its kinds.(8)

b. discuss the three levels of database architecture also explain the advantage of having the three levels. (7)

3. a. Write about views with an example and discuss its major advantages and disadvantages of it.(8)

b. Write about DDL and DML with an example.(7)

4.a. elaborate the relation algebra operations? Write SQL statements for every operators(7)

b. presume the subsequent TABLE:(8)

Degree(degcode, name, subject)
Candidate(seatno, degcode, semester,month, year, result)
Marks(seatno, degcode, semester, month, year, papcode, marks)
Degcode-degree code, Name-name of the degree(MSc,MCOM)

Subject-subject of the course. E.g. Phy, Papcode- Paper code E.g. A1

Solve the subsequent queries using SQL:

(i) Write a choose statement to display all the degree codes which are there in the candidate table but not current in degree table in the order of degcode.
(ii) Write a choose statement to display the name of all the candidates who have got less than 40 marks in exactly two subjects.
(iii)Write a choose statement to display the name, subject and number of candidates for all degrees in which there are less than five candidates.
(iv) Write a choose statement to display the name of all the candidates who have got highest total marks in MSc.,(Maths)

5. discuss the following:(15)

a. elaborate stored procedures?
b. What is data fragmentation?
c. elaborate triggers? What purpose do they serve?
d. describe assertions.
e. Write about referential integrity?

6. What is normalization? discuss one NF, two NF, three NF and BCNF with suitable example.(15)

7. a.What is RAID? List the various levels in RAID technology and discuss its features.(7)
b. discuss the following: (i) Hashing (ii) B+ tree indices(iii) Specialization (iv) Generalization(8)

8. define the file organizations with their advantages and disadvantages.(15)

9. a.Describe the GRANT functions and discuss how it relates to security. What kinds of privileges may be granted? How are they
revoked?(8)
b. What is Deadlock? How does it occur? How programs be written to (i) Avoid deadlock (ii) Guarantee accurate outcomes. (9)

10. a. What is concurrency control? How is it implemented in DBMS? Explain(8)
b. discuss different recovery techniques during transaction in detail? (7)

Earning:   Approval pending.