Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Ad 3391 Database Design and Management

    Uploaded by

    sr8370759

    Copyright:

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

    Ad 3391 Database Design and Management

    Uploaded by

    sr8370759
    22 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Ad 3391 Database Design and Management

    Uploaded by

    sr8370759

    Copyright:

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

    Saranathan College of Engineering,Tiruchirapalli

    Department of Artificial Intelligence and Data Science


    Internal Assessment Test - II Date/ Session 05.12.2023 Marks 50
    Course code AD3391 Course Title Database Design and Management
    Academic
    Batch No. Duration 90 mins 2023 - 2024
    Year
    Semester/
    Year/ II 03 Department AI & DS
    Section

    Part – A (Answer all the questions 10 x 2 = 20marks)


    Q. No. Questions CO Skills
    1 Compare DDL and DML. C203.2 U
    2 Why do we need Views in SQL? C203.2 U
    3 What is Transaction? C203.4 R
    4 Define Deadlock? C203.4 R
    5 What are ACID Properties? C203.4 R
    6 What are the states of transaction? C203.4 R
    7 Define Serializability? C203.4 R
    8 State the difference between shared lock and exclusive lock. C203.4 U
    9 Why must lock and unlock must be atomic operations? C203.4 U
    10 Outline the need for Concurrency control. C203.4 U
    Part – B (Answer all the questions 2 x 10 = 20marks)
    Q. No. Questions CO Skills
    Represent the Transaction states and explain the various desirable
    11 C203.4 U
    properties (ACID) of transaction Processing.
    Or
    12 Discuss in brief about Serializability with examples. C203.4 R

    What is Lock based protocol? Explain in detail about how it is used in


    13 C203.4 R
    Transactions

    Or
    How Serializability is guaranteed by Two Phase Locking technique?
    14 C203.4 U

    Part – C (Answer all the questions 1 x 10 = 10marks)


    Q. No. Questions CO Skills
    15 Explain in detail about the set operations in SQL and analyse with an
    C203.2 AZ
    example how nested queries are implemented in SQL.
    Or
    16 Construct a Complete E-R diagram for online shopping. C203.2 AZ
    Bloom’s Skills: Remember (R), Understand (U), Apply (A), Analyze (AZ), Evaluate (E) and Create (C). Skill need to be
    mentioned against each question.

    Faculty Members: Dr. S. Ravimaran, HOD/AI & DS


    Ms. G.Nithyalakshmi, AP/AI & DS

    You might also like