Reply to Thread

Originally Posted by Arvind Kumar

As you are looking for MCA Database Management old question paper of Pondicherry University so here it is:

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

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

b. dhowtoexamuss 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 dhowtoexamuss 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 TABLE8)

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. dhowtoexamuss the following15)

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? dhowtoexamuss 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 dhowtoexamuss its features.(7)
b. dhowtoexamuss 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 dhowtoexamuss 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. dhowtoexamuss different recovery techniques during transaction in detail? (7)