Scribd Logo
Upload

Welcome to Scribd!

  • 93 views

    Anna University Exams Nov / Dec 2019 - Regulation 2017: CS8492-Database Management Systems 1. 2. 3. 4. 5. 6

    Uploaded by

    sirask
    This document provides a list of 24 questions that could be asked on the exam for the 4th semester Database Management Systems course at Anna University. The questions cover a range of topics related to database concepts including data models, database architecture, relational algebra operations, SQL, entity relationship modeling, normalization, functional dependencies, concurrency control, locking protocols, B+ trees, RAID systems, indexing, hashing, distributed databases, information retrieval, transaction processing, and XML databases. Students are advised not to copy or republish the questions as they are intended for exam preparation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Anna University Exams Nov / Dec 2019 - Regulation 2017: CS8492-Database Management Systems 1. 2. 3. 4. 5. 6

    Uploaded by

    sirask
    93 views1 page
    This document provides a list of 24 questions that could be asked on the exam for the 4th semester Database Management Systems course at Anna University. The questions cover a range of topics related to database concepts including data models, database architecture, relational algebra operations, SQL, entity relationship modeling, normalization, functional dependencies, concurrency control, locking protocols, B+ trees, RAID systems, indexing, hashing, distributed databases, information retrieval, transaction processing, and XML databases. Students are advised not to copy or republish the questions as they are intended for exam preparation.

    Original Description:

    database management system

    Original Title

    DBMS unit 1

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a list of 24 questions that could be asked on the exam for the 4th semester Database Management Systems course at Anna University. The questions cover a range of topics related to database concepts including data models, database architecture, relational algebra operations, SQL, entity relationship modeling, normalization, functional dependencies, concurrency control, locking protocols, B+ trees, RAID systems, indexing, hashing, distributed databases, information retrieval, transaction processing, and XML databases. Students are advised not to copy or republish the questions as they are intended for exam preparation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    93 views1 page

    Anna University Exams Nov / Dec 2019 - Regulation 2017: CS8492-Database Management Systems 1. 2. 3. 4. 5. 6

    Uploaded by

    sirask
    This document provides a list of 24 questions that could be asked on the exam for the 4th semester Database Management Systems course at Anna University. The questions cover a range of topics related to database concepts including data models, database architecture, relational algebra operations, SQL, entity relationship modeling, normalization, functional dependencies, concurrency control, locking protocols, B+ trees, RAID systems, indexing, hashing, distributed databases, information retrieval, transaction processing, and XML databases. Students are advised not to copy or republish the questions as they are intended for exam preparation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    Anna University Exams Nov / Dec 2019 – Regulation 2017

    Rejinpaul.com Unique Important Questions – 4th Semester BE/BTECH


    CS8492-Database Management Systems

    1. Write short notes on Data models and its types


    2. Explain the basic architecture of a database management system with neat block diagram
    3. Explain select, projection, Cartesian product and join operations in relational algebra with
    an example
    4. Explain embedded and Dynamic SQL with an example.
    5. Explain the different clauses of SQL Query.
    6. Explain about Entity Relationship Model with ER diagrams and example Draw an E-R
    diagram for (a) Banking system (b) Airline Reservation system (c) Payroll system (d) car-
    insurance company (e) Hospital management system
    7. What is normalization? Explain various normalization (study all types with example
    problem) using functional dependencies with relevant examples.
    8. What is Functional Dependency? Explain types and properties of FD‟s
    9. Describe briefly about Serializability and its types with relevant example
    10. Explain Two Phase- Locking protocol. What benefit does strict two-phase locking protocol
    provides? Discuss its disadvantages.
    11. Discuss in detail about Lock based Protocol and Time Stamp based protocol
    12. Explain the concepts of Concurrency control mechanism
    13. Describe briefly about deadlock handling
    14. Describe the structure of B+ tree and list the characteristics of B+ tree
    15. Construct B+ tree to insert the following (order of tree is 3) 26, 27, 28, 3, 4, 7, 9, 46, 48, 51,
    2, 6.
    16. Explain how the RAID system improves performance and reliability
    17. Discuss in detail about cluster and multilevel indexes.
    18. Describe briefly about indexing and hashing.
    19. Illustrate with an example for insertion and deletion operations on a B- Tree
    20. Compare and contrast XQuery, XSLT and XPath.
    21. Discuss in detail about the various types of distributed database with suitable examples.
    22. Describe briefly on Information Retrieval (IR) with suitable example.
    23. Describe briefly on Transaction processing in distributed database.
    24. Discuss in detail about XML Database with relevant examples.
    Questions Are Expected for University Exams This May or may Not Be Asked for Exams
    Please do not Copy (or) Republish This Questions, Students if You Find the Same Questions in Other
    Sources, Kindly report us to [email protected]

    You might also like