ICT - Database Questions

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 Adamwane
A
Adamwane
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,852
| Attempts: 3,856
SettingsSettings
Please wait...
  • 1/8 Questions

    What is a collection of data or information called, that is stored in a logical and structured way?

    • Field
    • Story
    • Database
    • Column
    • Spreadsheet
Please wait...
About This Quiz

This Quiz follows on from the the presentation given on Databases.

ICT - Database Questions - Quiz

Quiz Preview

  • 2. 

     Tables can contain many records. Records run in: parallel/ time/ rows?

    Explanation
    Tables can contain many records, and records run in rows. In a table, each row represents a single record, and multiple rows make up the entire set of records in the table. Therefore, the correct answer is "rows."

    Rate this question:

  • 3. 

    In a Database, what is Data or Information stored in?

    • Garage

    • Storeroom

    • Online Server

    • Table

    • Filing cabinet

    Correct Answer
    A. Table
    Explanation
    In a database, data or information is stored in tables. Tables are structured collections of related data organized into rows and columns. Each row represents a record or instance of data, while each column represents a specific attribute or characteristic of the data. Tables provide a systematic way to store, organize, and retrieve data, allowing for efficient data management and analysis.

    Rate this question:

  • 4. 

    One piece of information stored about a thing or person is called a _____.

    Correct Answer
    Field
    Explanation
    A field is a single piece of information that is stored about a thing or person. It can be a specific attribute or characteristic that describes the thing or person in question. Fields are commonly used in databases to organize and store data in a structured manner. Each field corresponds to a specific data type and holds a particular value related to the thing or person being stored.

    Rate this question:

  • 5. 

    In a Database, a RECORD is...?

    • ...is the diagonal line of data made up from a number of random fields.

    • ...is the name of the vinyl disk to store music recordings.

    • ...is the single identification label given to a person or item.

    • ...is the single piece of information about a person or item

    • ...is all of the data about one person or item.

    Correct Answer
    A. ...is all of the data about one person or item.
    Explanation
    A record in a database refers to all of the data about one person or item. It represents a complete set of information related to a specific entity in the database. This can include various fields and attributes that describe the characteristics and properties of the entity. Each record is unique and serves as a single unit of data within the database system.

    Rate this question:

  • 6. 

    A persons' First name, Last name, Date of Birth (DOB), Height, Eye colour and Address are all types of what? 

    • Records

    • Fields

    • Tables

    • Files

    • Tags

    Correct Answer
    A. Fields
    Explanation
    The given answer, "Fields," is correct because all the listed items (First name, Last name, Date of Birth, Height, Eye color, and Address) are types of data that can be stored in separate fields within a database or spreadsheet. Fields are used to categorize and organize data, making it easier to search, sort, and analyze.

    Rate this question:

  • 7. 

    Which are examples of the advantages of a using a paper based database?

    • They are portable

    • They generally do not require special training

    • They can be updated easily

    • They will work in a powercut

    • They are expensive to set up

    Correct Answer(s)
    A. They are portable
    A. They generally do not require special training
    A. They will work in a powercut
    Explanation
    Paper-based databases have several advantages. Firstly, they are portable, meaning they can be easily carried and accessed anywhere. Secondly, they generally do not require special training, as most people are familiar with using paper and writing. Additionally, paper-based databases can still function during a powercut, unlike electronic databases that rely on electricity. However, the statement "They can be updated easily" is not mentioned in the given options.

    Rate this question:

  • 8. 

    What are the disadvantages for paper-based databases

    • They can be lost

    • They are hard to update or copy

    • It takes very little time to search using a paper database

    • They are expensive to keep up to date

    • They need lots of space to store them

    Correct Answer(s)
    A. They can be lost
    A. They are hard to update or copy
    A. They are expensive to keep up to date
    A. They need lots of space to store them
    Explanation
    Paper-based databases have several disadvantages. Firstly, they can be easily lost or damaged, leading to the loss of valuable data. Secondly, updating or copying information in a paper database is a time-consuming and cumbersome process. Additionally, keeping paper databases up to date can be expensive as it requires constant printing and manual entry of data. Lastly, paper databases require a significant amount of physical space for storage, which can be costly and inefficient.

    Rate this question:

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

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

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

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.