Spreadsheet Charts/Database Concepts Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Brittany_NI_NI
B
Brittany_NI_NI
Community Contributor
Quizzes Created: 1 | Total Attempts: 226
| Attempts: 226
SettingsSettings
Please wait...
  • 1/5 Questions

    In the school's student database, which is an example of the MOST APPOIATE primary key?

    • Student Number
    • Last name
    • First name
    • Birthdate
Please wait...
About This Quiz

Read each multiple choice item and possible answers carfully. Mark the letter of the correct answer on your answer sheet.

Spreadsheet Quizzes & Trivia

Quiz Preview

  • 2. 

    In a large corperate database, which is an example of the MO)ST APPROPRIATE primary key?

    • Driver Number

    • Number of laps

    • Number of races

    • Total winnings

    Correct Answer
    A. Driver Number
    Explanation
    In a large corporate database, the most appropriate primary key would be the "Driver Number." A primary key is a unique identifier for each record in a database table, and the "Driver Number" would serve this purpose effectively. It is likely that each driver in the database would have a unique driver number assigned to them, making it a suitable choice for a primary key. The other options, such as "Number of laps," "Number of races," or "Total winnings," may not be unique to each driver and could lead to data duplication or inconsistencies.

    Rate this question:

  • 3. 

    Which is an example of a approiate field name?

    • Patent's fist name and bithdate

    • Name/Last

    • Patient's fist name and ID

    • First name

    Correct Answer
    A. First name
    Explanation
    The correct answer is "First name" because it is a clear and concise field name that accurately describes the information it is intended to capture. It follows a standard naming convention and does not include unnecessary or redundant information.

    Rate this question:

  • 4. 

    Which is an example of a field that can be formatted with an input mask?

    • Zipcode

    • Yes/No

    • Male/Female

    • Adult/Child

    Correct Answer
    A. Zipcode
    Explanation
    A field that can be formatted with an input mask is a Zipcode. An input mask is a way to enforce a specific format for data entry. In the case of a Zipcode, an input mask can be used to ensure that the user enters the correct number of digits and follows the specific format for Zipcodes in a particular country. This can help to prevent data entry errors and ensure consistency in the data collected.

    Rate this question:

  • 5. 

    Max wants to create a list of graduate degreesin a database that will allow the selection of early three choices:BSBA, MBA, and MBE. What field property should he use?

    • Yes/No

    • AutoNumber

    • Lookup

    • Number

    Correct Answer
    A. Lookup
    Explanation
    Max should use the Lookup field property to create a list of graduate degrees in the database. This field property allows for the selection of multiple choices from a predefined list, which is suitable for Max's requirement of selecting three choices from the options of BSBA, MBA, and MBE.

    Rate this question:

Quiz Review Timeline (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 03, 2010
    Quiz Created by
    Brittany_NI_NI
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.