Relational Database Trivia Quiz!

9 Questions

Settings
Please wait...
Relational Database Trivia Quiz!

Below is a Relational Database Trivia Quiz! It is designed to help you understand how databases holding the same information are structured and maintained. Do you think that you have what it takes to tackle it based on what you have learned? Then press the start button and see just how well you will do in this quiz. All the best!


Related Topics
Questions and Answers
  • 1. 
    Which of the following makes it possible for entities to share a relationship?
    • A. 

      Multi-valued attributes

    • B. 

      A foreign key

    • C. 

      A common attribute

    • D. 

      The same number of attributes

  • 2. 
    A database contains the fields Pupil_no and Pupil_name. If we are given the Pupil_no then we will know Pupil_name.  This means that:
    • A. 

      Pupil_name has a functionality with Pupil_ID

    • B. 

      Pupil_ID is functionally dependent on Pupil_name

    • C. 

      Pupil_name is functionally dependent on Pupil_ID

    • D. 

      These two attributes have a relationship

  • 3. 
    What is the purpose of an indexed field in a database?
    • A. 

      To speed up queries

    • B. 

      To verify values

    • C. 

      To create links between entities

    • D. 

      To specify a lookup

  • 4. 
    The requirement that each entity much have a unique primary key where the value of that primary key is not null, is known as the
    • A. 

      Entity Integrity Rule

    • B. 

      Referential Integrity Rule

    • C. 

      Entity-Relationship Rule

    • D. 

      Validation Index

  • 5. 
    If there are multiple occurrences of attributes for a single value of a primary key, this is known as a ______________ group.
  • 6. 
    Which of the following is TRUE about referential integrity rule?
    • A. 

      Each primary key much be unique and not null

    • B. 

      For each foreign key, there must be a corresponding primary key

    • C. 

      Repeating groups are not permitted.

    • D. 

      All attributes must have meaningful names.

  • 7. 
    The frequency of a relationship between entities may be described by
    • A. 

      Indexed fields

    • B. 

      Transitive dependencies

    • C. 

      Cardinality

    • D. 

      Referential integrity

  • 8. 
    Consider the following entity:CAR_RENTAL(Car_Reg, Make, Model, Driver_Name, Date_Hired, Date_Returned)Which of the following would be included in a repeating group?
    • A. 

      Car_Reg

    • B. 

      Make

    • C. 

      Driver_name

    • D. 

      Model

  • 9. 
    Which of the following is TRUE about relational database design?
    • A. 

      The order of attributes is critical.

    • B. 

      Each column must be unique.

    • C. 

      No row should be duplicated.

    • D. 

      All tables must contain a foreign key.