DBMS Exam: MCQ Quiz! Trivia

31 Questions | Total Attempts: 4699

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

.


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