DBMS Exam: MCQ Quiz! Trivia

31 Questions | Total Attempts: 5246

SettingsSettingsSettings
Please wait...
DBMS Exam: MCQ Quiz! Trivia

Ever wondered how much you know about DBMS, or the Database Management System? For this quiz, you should know what is responsible for authorizing access to the databases and obtaining software and hardware services, what is a property that defines different characteristics of an item, what level describes what is stored in the database and the relationships between data, and what is an association among entities. This quiz will provide you insight into the Database Management System. So. Let's get started.


Questions and Answers
  • 1. 
    -------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, and monitoring efficiency of operations.
    • A. 

      Authorization Manager

    • B. 

      Storage Manager

    • C. 

      File Manager

    • D. 

      Transcation Manager

    • E. 

      Buffer Manager

  • 2. 
    ------------------------------is a property that describes various characteristics of an entity.
    • A. 

      ER Diagram

    • B. 

      Column

    • C. 

      Relationship

    • D. 

      Attribute

  • 3. 
    ---------------------- level describes what data is stored in the database and the relationships among the data.
    • A. 

      Physical Level

    • B. 

      Logical Level

    • C. 

      Conceptual Level

    • D. 

      None of the above

  • 4. 
    ------------------------ denote derived attributes.
    • A. 

      Double ellipse

    • B. 

      Dashed ellipse

    • C. 

      Squared ellipse

    • D. 

      Ellipse with attribute name underlined

  • 5. 
     A_____________is an association between entities.
    • A. 

      Relation

    • B. 

      One to One

    • C. 

      Generalization

    • D. 

      Specialization

  • 6. 
    ---------------------------  stores metadata about the structure of the database.
    • A. 

      Physical data base

    • B. 

      Query Analyzer

    • C. 

      Data Dictionary

    • D. 

      Data Catalog

  • 7. 
    ___________is a collection of operations that perform s single logical function in a database application.
    • A. 

      Transaction

    • B. 

      Concurrent operation

    • C. 

      Atomocity

    • D. 

      Durability

  • 8. 
    The problem that is compounded when constraints involve several data items from different files are called _____________
    • A. 

      Transaction Control Management Problem

    • B. 

      Security Problem

    • C. 

      Integrity Problem

    • D. 

      Durability Problem

  • 9. 
    Ensuring atomicity is the responsibility of the --------------------------component.
    • A. 

      File Manager

    • B. 

      Buffer Manager

    • C. 

      DBA

    • D. 

      Transation Manager

  • 10. 
    -------------------manages the allocation of the space on the disk storage and the database structure used to represent information stored on disk.
    • A. 

      Disk Manager

    • B. 

      File Manager

    • C. 

      Buffer Manager

    • D. 

      Memory Manager

    • E. 

      None of the above

  • 11. 
    ----------------------------is the minimal super key.
    • A. 

      Primary Key

    • B. 

      Candidate Key

    • C. 

      Surrogate Key

    • D. 

      Unique Key

    • E. 

      Alternate Key

  • 12. 
     The -----------------------------engine executes low-level instructions generated by the DML compiler.
    • A. 

      DDL Analyzer

    • B. 

      Query Interpreter

    • C. 

      Database Engine

    • D. 

      None of the above

  • 13. 
     --------------------------responsible to define the content, the structure, the constraints, and functions or transactions against the database.  
    • A. 

      Transcation Manager

    • B. 

      Query Analyzer

    • C. 

      DBA

    • D. 

      All the above

    • E. 

      None of the above

  • 14. 
    In the ER model ---------------------------denote  derived attributes.
    • A. 

      Double ellipse

    • B. 

      Diamond

    • C. 

      Reactangle

    • D. 

      None of the above

  • 15. 
    --------------------attributes can be divided into parts.
  • 16. 
    Foreign Key can be null.
    • A. 

      TRUE

    • B. 

      FALSE

  • 17. 
    All primary keys should be super keys.
    • A. 

      TRUE

    • B. 

      FALSE

  • 18. 
    In a Relational database, Data is stored as record types and the relationship is represented by set types.
    • A. 

      True

    • B. 

      False

  • 19. 
    In a Hierarchical database to get to a low-level table, you start at the root and work your way down the tree until you reach your target data.
    • A. 

      True

    • B. 

      False

  • 20. 
    Using the relational model we design conceptual database design.
    • A. 

      True

    • B. 

      False

  • 21. 
    The conceptual data model is the source of information for the logical design phase.
    • A. 

      True

    • B. 

      False

  • 22. 
    Logical database design describes base relations, file organizations, and indexes that are used to achieve efficient access to data.
    • A. 

      True

    • B. 

      False

  • 23. 
    Conceptual data modeling uses a high-level data modeling concept of E-R Models.
    • A. 

      True

    • B. 

      False

  • 24. 
    Tables are required to have at least one column.
    • A. 

      True

    • B. 

      False

  • 25. 
    Logical data independence: Refers to the separation of the external views from the conceptual view.
    • A. 

      True

    • B. 

      False

Related Topics