Database Concepts Exam Quiz: Trivia!

10 Questions | Total Attempts: 6874

SettingsSettingsSettings
Please wait...
Database Concepts Exam Quiz: Trivia!

How aware are you of the various database concepts? A database is frequently conceived of as a repository of information necessary for running certain functions in an organization. This quiz involves your ability to comprehend what a single set of related data values is referred to as, as well as other pertinent information. Take this quiz and see how much you know about database concepts.


Questions and Answers
  • 1. 
    A single set of related data values is referred to as:
    • A. 

      Data value

    • B. 

      Record

    • C. 

      Field

    • D. 

      Table

  • 2. 
    What is used to uniquely identify each record in a table?
    • A. 

      Foreign key

    • B. 

      Field

    • C. 

      Datatype

    • D. 

      Primary key

  • 3. 
    ___________ data type stores date and time values between the years 100 through 9999.
    • A. 

      Date

    • B. 

      Time

    • C. 

      Date/Time

    • D. 

      Memo

  • 4. 
    The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.
    • A. 

      Datasheet View

    • B. 

      Design View

    • C. 

      Table View

    • D. 

      Wizard View

  • 5. 
    You can select multiple fields of a table in the design view by using the ________ key.
    • A. 

      Alt

    • B. 

      Spacebar

    • C. 

      Shift

    • D. 

      Tab

    • E. 

      Ctrl

  • 6. 
    What does x represent in the figure?
    • A. 

      Row Selector

    • B. 

      Row Holder

    • C. 

      Row Field

    • D. 

      Row Data

  • 7. 
    What validation rule should be entered for a StudentID which should start with the letter "S"?
    • A. 

      Like 'S*'

    • B. 

      Like S*

    • C. 

      Like "S"

    • D. 

      Like "S*"

  • 8. 
    In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?
    • A. 

      Caption

    • B. 

      Validation Text

    • C. 

      Required

    • D. 

      Validation Rule

    • E. 

      Default

  • 9. 
    Indicate whether the following statement is true or false. Statement: A table can have only one Primary Key.
    • A. 

      True

    • B. 

      False

  • 10. 
    What is the purpose of forms?
    • A. 

      It is used to store data

    • B. 

      It provides a user-friendly interface for entering data into tables

    • C. 

      It is used to retrieve data from tables

    • D. 

      It is used to print or preview data in different formats

Related Topics
Back to Top Back to top