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

AD-402 Database Management System - Dec 2024 Question Paper

  1. 7 Marks
    aDescribe the architecture of DBMS. Explain each component briefly.
  2. 7 Marks
    bDefine E-R model with example. How to convert an E-R model into Tables? Explain.
  3. 7 Marks
    aDefine database system. Summarize the advantages of database system.
  4. 7 Marks
    bWhat is database schema? Describe Physical schema and Logical schema.
  5. 7 Marks
    aList out the various join operations and explain briefly with suitable examples.
  6. 7 Marks
    bDiscuss the following Relational algebra operations with examples. SELECT, PROJECT, DIVISION
  7. 7 Marks
    aState BCNF. How does it differ from 3 NF? Explain.
  8. 7 Marks
    bWhat is Functional Dependency? Describe the properties of FD's.
  9. 7 Marks
    aDefine optimization. Discuss the steps involved in query optimization.
  10. 7 Marks
    bExplain different types of Advanced Recovery Techniques.
  11. 7 Marks
    aList and explain various types of specialized locking techniques used in DBMS.
  12. 7 Marks
    bWhat do you understand by distributed databases? Give the various advantages and disadvantages of distributed database management system.
  13. 7 Marks
    aDescribe the usage of parameters in procedures.
  14. 7 Marks
    bDiscuss the limitations of user defined functions.
  15. 14 Marks
    Write a short note on any two of the following. a) Single level and multilevel indices. b) Referential integrity constraints. c) Problems with null valued and dangling tuples. d) Triggers
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