Skip to content
CampusPrep
AD-402 · Database Management System/Unsolved PYQ Paper

AD-402 Database Management System - Jun 2022 Question Paper

  1. Unit 1
    7 Marks
    aDescribe various disadvantages of file system compare to Data base management system.
  2. Unit 1
    7 Marks
    bDifferentiate specialization and generalization with help of example.
  3. Unit 2
    7 Marks
    aExplain in detail about various key constraints used in database system.
  4. Unit 1
    7 Marks
    bExplain the components of DBMS with a neat diagram.
  5. Unit 1
    7 Marks
    aDefine and explain following terms :- Levels of data abstraction, Instances, Schema, Physical data independence, Logical data independence.
  6. Unit 2
    4 Marks
    iConsider the following relational schema: Doctor (DName, Reg_no) Patient (Pname, Disease) Assigned To (Pname, Dname) Give expression in both SQL and relational algebra for each of the queries: Get the names of patients who are assigned to more than one doctor.
  7. Unit 2
    3 Marks
    iiConsider the following relational schema: Doctor (DName, Reg_no) Patient (Pname, Disease) Assigned To (Pname, Dname) Give expression in both SQL and relational algebra for each of the queries: Get the names of doctors who are treating patients with 'Polio'.
  8. Unit 3
    7 Marks
    aState the Armstrong inference rules. Provide suitable examples to describe each.
  9. Unit 2
    7 Marks
    bDescribe the concept of Referential Integrity.
  10. Unit 3
    7 Marks
    aWhat do you mean by Normalization? Explain BCNF, 3NF and 2NF with a suitable example.
  11. Unit 3
    7 Marks
    bGiven a set of FDs $A \rightarrow B$, $ABCD \rightarrow E$, $EF \rightarrow G$ Is $ACDF \rightarrow G$ implied by the set of given FDs? Justify your answer.
  12. Unit 4
    7 Marks
    aWhat is Transaction? Explain its four important Properties.
  13. Unit 4
    7 Marks
    bWhat are the problems encountered in DDBMS while considering concurrency control and recovery.
  14. Unit 4
    7 Marks
    aExplain in detail about timestamp based concurrency control techniques.
  15. Unit 4
    7 Marks
    bWrite and explain optimistic concurrency control algorithm.
  16. Unit 3
    5 Marks
    aWrite short note on any two: Multi Valued Dependency
  17. Unit 5
    5 Marks
    bWrite short note on any two: Expression Evaluation Plan
  18. Unit 5
    4 Marks
    cWrite short note on any two: Object Oriented Data Base System
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in