Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    DBMS Unitwise Imp Questions

    Uploaded by

    Shanmukha Rao

    Copyright:

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

    DBMS Unitwise Imp Questions

    Uploaded by

    Shanmukha Rao
    25 views4 pages

    Original Title

    DBMS Unitwise imp questions

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    25 views4 pages

    DBMS Unitwise Imp Questions

    Uploaded by

    Shanmukha Rao

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    For complete BTECH CSE, AIML, DS subjects tutorials visit : ns lectures youtube channel

    DATABASE MANAGEMENT SYSTEMS (DBMS)


    Unit wise Important Questions
    Unit-1
    1. What is database and DBMS?
    2. Explain Characteristics/ features, Database tasks, Advantages, Disadvantages,
    Applications, history of DBMS?
    3. Explain Difference between file system and DBMS?
    4. Explain Various Data Models in DBMS? (Hint :- Hierarchical Model, Network Model,
    Entity-Relationship Model, Relational Model, Object-Oriented Data Model, Object-
    Relational Data Model, Flat Data Model , Semi-Structured Data Model)
    5. What is Schema and Data Abstraction in DBMS?
    6. What are various Levels of abstraction for DBMS (or) three levels of the schema
    (or) Three tier schema Architecture ?
    7. What is Data Independence ? Explain Difference between Physical and Logical
    data independence ?
    8. What is an instance ?
    9. Explain DBMS Architecture and types of DBMS Architectures ?( hint: 1- tier, 2- tier,
    3- tier )
    10. Explain Database System architecture and various components we use in this
    database system architecture in detail.
    11. What are Six steps of Database design process and which steps are relevant to ER
    model?
    12. Why Use ER Diagrams In DBMS? Various Symbols Used in ER Model and The
    components /features of an ER diagram?
    13. Explain entities and types of entities, entity set , attributes and types of attributes,
    relationship, relationship set, Degree of a Relationship Set (or) Types of
    Relationship Sets?
    14. What are Cardinality Constraints? types of constraints on the Entity Relationship
    (ER) model?(hint :- Mapping cardinality or cardinality ratio, Participation
    constraints)
    15. Explain various types of constraints In an Entity-Relationship (ER) model?
    16. Generalization, Specialization and Aggregation in ER Model with an examples?
    17. What is Class hierarchy? Define SQL? Explain how to convert ER Model to a
    Relational Model with an example?
    18. Explain Difference between entity and Attribute, Entity set vs Relationship set,
    Binary vs ternary relationship
    19. Draw ER Diagram for
    a) Company
    b) Library Management System
    c) online Shopping
    d) hospital management system
    e) University management system

    Prepared by Chennuri Nagendra Sai (Asst.prof)


    For complete BTECH CSE, AIML, DS subjects tutorials visit : ns lectures youtube channel

    f) hotel management system


    g) Bank management system
    h) Railway reservation system
    i) Car Rental system
    j) Car insurance company
    UNIT-2
    1. Explain Relational Model.
    2. What are Database Languages (or) query languages (or) data query languages (or)
    sql languages? ( hint: DDL, DML, DCL, TCL )
    3. Integrity Constraints ( Entity integrity constraints, Referential Integrity Constraints, Key
    constraints, Domain Constraints ).
    4. Various Types of Keys ( primary key , foreign key, super key, candidate key, alternate key,
    composite key ).
    5. Inclusion dependence.
    6. Querying in relational data ( hint : using select command)
    7. Logical database design ( converting ER diagrams to tables with and without key
    constraints).
    8. Views? Creating views from single and multiple tables, updating and deleting views?
    9. How to Drop tables and views using sql?
    10. What is relational algebra and what are its properties?
    11. Fundamental operations in relational algebra and explain with examples? (selection,
    projection, Cartesian product, set operations, join operations)
    12. What is relational calculus ? explain tuple relational calculus and domain relational calculus
    with an examples?

    UNIT-3
    1. Basic form of a sql query? (or) structure of sql statement with an example?
    2. Data types in sql ? explain date and time function? String function? Mathematical
    functions in sql?
    3. Pattern matching in sql and its use?
    ( hint: select * from students where name like “s%” )
    4. Compound condition in sql?
    5. Explain set operations in sql?
    6. Types of joins in sql?
    7. Explain nested queries in sql?
    8. Aggregate operations in sql with an example?
    9. Use of distinct in sql?
    10. What are null values? How to disallow null values?
    11. What are complex integrity constraints in sql?
    12. What are prime and non prime attributes ?
    13. What are triggers ?what are its three parts? How to create it? Types of triggers?

    Prepared by Chennuri Nagendra Sai (Asst.prof)


    For complete BTECH CSE, AIML, DS subjects tutorials visit : ns lectures youtube channel

    14. What is redundancy? Problems caused by redundancy? What is decomposition


    and its properties ? how does decomposition addresses redundancy? Discuss
    problems that may be caused by the use of decomposition?
    15. What is surrogate key? How can it be used for schema refinement?
    16. What is functional dependency explain with an example? Explain trival and non
    trival functional dependency?
    17. Explain Armstrong axioms?
    18. What is normalization? Explain 1nf, 2nf, 3nf, bcnf, 4nf, 5nf normal forms with
    examples?
    19. Explain lossless join decomposition ?
    20. Explain functional dependency with multi valued dependency?
    UNIT-4
    1. What is transaction ?Explain ACID properties of transaction?
    2. Draw transaction state diagram and describe each state that a transaction goes through
    during its execution?
    3. Explain the difference between three storage types, volatile, non volatile, stable in terms
    of I/O cost.
    4. What is meant by atomicity and durability for transaction? Discuss the shadow copy
    technique for it.
    5. What is transaction isolation and what is concurremcy control?
    6. Discuss the violations caused by each of the following:
    Lost update problem, dirtt read, non repeatable read and phantok read problems in
    concurrency.
    7. What is schedule and serializability ? Explain types of schedule and explain conflict
    serializability and view serializability with examples?
    7. What is recoverable schedule and cascadeless schedule?
    8. What are transaction isolation levels?
    9. Why do we need locks? Explain simple lock based protocol with suitable example.
    10. What is 2 phase locking protocol explain its advantages and disadvantages ?how does
    it guarantee serializability?
    11. What is difference between shared lock and exclusive lock?
    12. What is time stamp ordering and explain its advantages and disadvantages ? Explain
    how it is used for concurrency control?
    13. Explain
    A) multi version timestamp ordering protocol
    B) optimistic concurrency control algorithm
    C) log based recovery approach
    14. What is failure and recovery system? When failure occurs? Discuss different types of
    failures?
    15. How to perform rollback, commit, check pointing operations in transactions? Explain.
    16. Explain a) recovery with concurrent transactions
    b) shadow copy technique.

    Prepared by Chennuri Nagendra Sai (Asst.prof)


    For complete BTECH CSE, AIML, DS subjects tutorials visit : ns lectures youtube channel

    UNIT-5
    1. Explain
    A) Why does a dbms store data in external storage?
    B) why are I/O Costs important in a DBMS?
    C) what is record ID? How many I/Os are needed to fetch it into main memory.
    D) what is buffer manager.
    2. Discuss cylinder and its benefits in disk organization.
    3. Explain a) optical disks b) magnetic tapes
    4. What is file organization? Operations supported by file of records abstraction.
    5. What is an index on a file of records? What is a search key for an index? Why do we
    need indexes?
    6. Discuss about primary indexes? Define single level and multi level indexing.
    7. What is cluster index and unclustered index?
    8. Explain primary and secondary indexes with an example?
    9. What are the indexed data structures?( hint: hashed based and tree based indexing?
    10. Explain hashed based and tree based indexing with examples?
    11.explain terms a) hash function b) bucket c) synonym d) collision and overflow e) file
    operation on hash file
    12. What is static hashing? Open hashing? Linear probing? Dynamic hashing? Extendible
    hashing? Explain with examples.
    13. Explain concept of heap file organization?
    14. Write about indexed sequential files with advantages and disadvantages.
    15. Explain the concept of B+ teee?its characteristics?
    Give algorithms and examples of insertion and deletion operations for B+ tree.? Difference
    between B+ and B- trees?

    Prepared by Chennuri Nagendra Sai (Asst.prof)

    You might also like