AD-402 Data Base Management System - Jun 2024 Question Paper

Under each question, How to answer lists the points an answer should cover, outlined by CampusPrep from the syllabus. Check the details against your textbook.

1. 7 Marks
   aDescribe the architecture of a typical database system.
   How to answer

   • Define database system and its users/components
   • Explain three-level architecture: internal, conceptual, external with mappings
   • Describe components: query processor, storage manager, transaction manager
   • Include neat labelled architecture diagram
2. 7 Marks
   bDifferentiate between conceptual, logical, and physical schemas.
   How to answer

   • Define conceptual, logical and physical schema
   • Compare abstraction level, audience and independence
   • Give example for each level
   • Summarize differences in table
3. 7 Marks
   aDiscuss the suitability of each, object-oriented, network and relational data models for different types of applications.
   How to answer

   • Define object-oriented, network and relational data models
   • Discuss structure, strengths and limitations of each
   • Suggest suitable application types for each model
   • Conclude with comparison summary
4. 7 Marks
   bDefine a relational database schema. Discuss the components of a schema, including tables, attributes, and relationships.
   How to answer

   • Define relational database schema and relation
   • Explain tables, attributes, domains, tuples and keys
   • Explain relationships and integrity constraints
   • Give example schema with tables
5. 7 Marks
   aExplain the difference between intension and extension using examples.
   How to answer

   • Define intension (schema) and extension (instance)
   • Highlight differences: definition vs data, stability vs volatility
   • Give example table schema vs its tuples
   • Summarize in comparison table
6. 7 Marks
   bCompare and contrast tuple-oriented and domain-oriented relational calculus.
   How to answer

   • Define tuple relational calculus and domain relational calculus
   • Compare variables, syntax and example queries
   • Discuss expressive power and equivalence
   • Conclude with usage differences
7. 7 Marks
   aExplain the objectives of normalization, such as minimizing redundancy and dependency preservation.
   How to answer

   • Define normalization and need for it
   • Explain minimizing redundancy and anomaly removal
   • Explain dependency preservation and lossless join
   • Give simple example of redundancy removal
8. 7 Marks
   bProvide examples illustrating functional dependencies in relational databases.
   How to answer

   • Define functional dependency with notation X -> Y
   • Give examples: EmpID -> Name, Dept etc.
   • Show trivial, full and partial dependencies
   • Explain role in keys and normalization
9. 7 Marks
   aDiscuss the role of fourth normal form (4NF) in handling multivalued dependencies.
   How to answer

   • Define multivalued dependency
   • Explain 4NF condition: non-trivial MVDs implied by key
   • Show example decomposition to 4NF
   • Discuss elimination of redundancy
10. 7 Marks
    bExplain locking techniques for concurrency control, including exclusive locks, shared locks, and deadlock detection/prevention mechanisms.
    How to answer

    • Define shared and exclusive locks and compatibility
    • Explain lock-based protocols and two-phase locking
    • Explain deadlock detection, prevention and avoidance
    • Give example of lock usage
11. 7 Marks
    aDiscuss the challenges associated with distributed database management, such as data fragmentation, replication, and distributed transaction management.
    How to answer

    • Define distributed DBMS and fragmentation types
    • Discuss replication, transparency and consistency issues
    • Discuss distributed transaction, commit and recovery
    • Summarize challenges with examples
12. 7 Marks
    bProvide a comparative study of OODBMS vs. DBMS, highlighting their strengths and weaknesses in different scenarios.
    How to answer

    • Define OODBMS and traditional DBMS/RDBMS
    • Compare data model, querying, performance and use cases
    • Highlight strengths and weaknesses in scenarios
    • Conclude suitability criteria
13. 7 Marks
    aDiscuss the usage of special operators such as LIKE, ANY, ALL, EXISTS, and IN in SQL queries.
    How to answer

    • Define purpose of LIKE, ANY, ALL, EXISTS, IN
    • Give SQL syntax and example query for each
    • Explain use in subqueries and pattern matching
    • Note performance considerations
14. 7 Marks
    bIntroduce the concept of NoSQL databases and discuss their characteristics and advantages compared to traditional RDBMS.
    How to answer

    • Define NoSQL and its types
    • Explain characteristics: schema-less, scalability, BASE
    • Compare with traditional RDBMS on structure and consistency
    • Discuss advantages and use cases
15. 14 Marks
    Write a short note on any two:

    1. i)Relational algebra and relational calculus
    2. ii)Select, Project, and Join Operations
    3. iii)Concurrency Control Techniques
    4. iv)Data Dictionary and Dynamic Performance Views
    How to answer

    • Select any two topics from the list
    • Define each with key concepts and syntax/components
    • Give examples and applications
    • Conclude with significance