Quiz: Basic DBMS Trivia Questions

20 Questions

Settings
Please wait...
Quiz: Basic DBMS Trivia Questions

.


Questions and Answers
  • 1. 
     A ____ is a two-dimensional data structure containing rows and columns. 
    • A. 

      Table

    • B. 

      Row

    • C. 

      Field

    • D. 

      d. field value

  • 2. 
     ____ typically draw their content from operational databases within an organization and multiple external databases. 
    • A. 

      a. Data types

    • B. 

      b. Data warehouses

    • C. 

      c. Multivalued attributes

    • D. 

      d. Foreign keys

  • 3. 
    Each table in a relational database must have a unique ____. 
    • A. 

      Cell

    • B. 

      Key

    • C. 

      Field

    • D. 

      d. field value

  • 4. 
    A table is in ____ if it contains no repeating fields or groups of fields. 
    • A. 

      a. first normal form

    • B. 

      b. second normal form

    • C. 

      c. third normal form

    • D. 

      d. fourth normal form

  • 5. 
    An object of a ____ is not destroyed when the program or process that creates it ceases execution. 
    • A. 

      a. transient class

    • B. 

      b. persistent class

    • C. 

      c. multivalued attribute

    • D. 

      Schema

  • 6. 
    The ____ is a relational database management system used to store object attributes and relationships. 
    • A. 

      a. hybrid object-relational DBMS

    • B. 

      b. multivalued attribute

    • C. 

      c. persistent class

    • D. 

      d. physical data store

  • 7. 
    A(n) ____ is one that is not directly supported by computer hardware or a programming language. 
    • A. 

      a. primitive data type

    • B. 

      b. data warehouse

    • C. 

      c. complex data type

    • D. 

      d. object identifier

  • 8. 
    A(n) ____ stores descriptive information about data, such as field names, restrictions on allowed values, and access controls to sensitive data items. 
    • A. 

      Database

    • B. 

      Attribute

    • C. 

      c. data type

    • D. 

      Class

  • 9. 
    ____ are data types that are supported directly by computer hardware and programming languages. 
    • A. 

      a. Primitive data types

    • B. 

      b. Data warehouses

    • C. 

      c. Complex data types

    • D. 

      d. Object identifiers

  • 10. 
    The term ____ describes a consistent state among foreign key and primary key values. 
    • A. 

      Normalization

    • B. 

      b. referential integrity

    • C. 

      c. second normal form

    • D. 

      d. first normal form

  • 11. 
    A ____ is a collection of data used to support structured and unstructured managerial decisions. 
    • A. 

      a. data type

    • B. 

      b. data warehouse

    • C. 

      Schema

    • D. 

      d. foreign key

  • 12. 
    A table is in ____ if it is in second normal form and if no non-key element is functionally dependent on any other non-key element. 
    • A. 

      a. first normal form

    • B. 

      b. second normal form

    • C. 

      c. third normal form

    • D. 

      d. fifth normal form

  • 13. 
    A ____ is a field that contains a value that is unique within each row of a relational database table. 
    • A. 

      Cell

    • B. 

      Key

    • C. 

      Field

    • D. 

      d. field value

  • 14. 
    ____ is a critical element of relational database design because they are the basis for representing relationships among tables. 
    • A. 

      a. Data types

    • B. 

      b. RDMSs

    • C. 

      c. Multivalued attributes

    • D. 

      Keys

  • 15. 
     ____ are not required in an object database because referential integrity is implemented with object identifiers. 
    • A. 

      a. Object identifiers

    • B. 

      b. Hybrid attributes

    • C. 

      c. Foreign keys

    • D. 

      d. Key attributes

  • 16. 
    The process of extracting an object identifier from one object and using it to access another object is sometimes called ____. 
    • A. 

      a. functional dependency

    • B. 

      b. database synchronization

    • C. 

      Navigation

    • D. 

      Normalization

  • 17. 
    Objects of a ____ exist only during the lifetime of a program or process. 
    • A. 

      a. transient class

    • B. 

      b. persistent class

    • C. 

      c. multivalued attribute

    • D. 

      Schema

  • 18. 
    A ____ is a DBMS that organizes stored data into structures called tables. 
    • A. 

      a. persistent class

    • B. 

      b. transient class

    • C. 

      c. relational database management system

    • D. 

      d. data warehouse

  • 19. 
     ____ are commonly supported in ODBMSs but are not supported in RDBMSs because they violate first normal form. 
    • A. 

      a. Object identifiers

    • B. 

      b. Hybrid attributes

    • C. 

      c. Multivalued attributes

    • D. 

      d. Foreign keys

  • 20. 
    A(n) ____, also called a repeating group, is an attribute that contains zero or more instances of the same data type. 
    • A. 

      a. object identifier

    • B. 

      b. hybrid attribute

    • C. 

      c. multivalued attribute

    • D. 

      d. foreign key