DBMS Test1

31 Questions

Settings
Please wait...
Database Quizzes & Trivia

This is a test for DBMS fundamentals


Related Topics
Questions and Answers
  • 1. 
    -------------------------------responsible for authorizing access to the database, for co-ordinating 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 data base
    • 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 data base 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. 
    • 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  ER model ---------------------------denote  derived attributes
    • A. 

      Double ellipse

    • B. 

      Diamond

    • C. 

      Reactangle

    • D. 

      None of the above

  • 15. 
    --------------------attributes can be divided into parts (Write the answer in lowercase) 
  • 16. 
    Foreign Key can be null
    • A. 

      TRUE

    • B. 

      FALSE

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

      TRUE

    • B. 

      FALSE

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

      True

    • B. 

      False

  • 19. 
    In   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 relational model we design conceptual   database design
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 22. 
    Logical database design describes 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

  • 26. 
    Duplication of data is the disadvantage of DBMS
    • A. 

      True

    • B. 

      False

  • 27. 
    Candidate key can have a null value
    • A. 

      True

    • B. 

      False

  • 28. 
    Each program maintains its own set of data. So users of one program may be unaware of potentially useful data held by other programs  this leads to Duplication of data
    • A. 

      True

    • B. 

      False

  • 29. 
    A traditional database stores just data – with no procedures
    • A. 

      True

    • B. 

      False

  • 30. 
    Simple Attribute  composed of multiple components, each with an independent existence.
    • A. 

      True

    • B. 

      False

  • 31. 
    Cardinality specifies how many instances of an entity relate to one instance of another entity.
    • A. 

      True

    • B. 

      False