ICT - Database Questions

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Adamwane

Adamwane

Community Contributor

Quizzes Created: 1 | Total Attempts: 3,616

Questions: 8 | Attempts: 3,616 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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

Questions and Answers

1.

What is a collection of data or information called, that is stored in a logical and structured way?
- A.
  
  Field
- B.
  
  Story
- C.
  
  Database
- D.
  
  Column
- E.
  
  Spreadsheet
Correct Answer
C. Database

Explanation
A database is a collection of data or information that is stored in a logical and structured way. It allows for efficient storage, retrieval, and manipulation of data, making it easier to organize and manage large amounts of information. Databases are commonly used in various applications and industries, such as business, finance, healthcare, and education, to store and manage data effectively.

Rate this question:

7
2
2.

Which are examples of the advantages of a using a paper based database?
- A.
  
  They are portable
- B.
  
  They generally do not require special training
- C.
  
  They can be updated easily
- D.
  
  They will work in a powercut
- E.
  
  They are expensive to set up
Correct Answer(s)
A. They are portable
B. They generally do not require special training
D. 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:

2
0
3.

What are the disadvantages for paper-based databases
- A.
  
  They can be lost
- B.
  
  They are hard to update or copy
- C.
  
  It takes very little time to search using a paper database
- D.
  
  They are expensive to keep up to date
- E.
  
  They need lots of space to store them
Correct Answer(s)
A. They can be lost
B. They are hard to update or copy
D. They are expensive to keep up to date
E. 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:
4.

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

Correct Answer(s)
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:

2
4 2
5.

In a Database, what is Data or Information stored in?
- A.
  
  Garage
- B.
  
  Storeroom
- C.
  
  Online Server
- D.
  
  Table
- E.
  
  Filing cabinet
Correct Answer
D. 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:
6.

In a Database, a RECORD is...?
- A.
  
  ...is the diagonal line of data made up from a number of random fields.
- B.
  
  ...is the name of the vinyl disk to store music recordings.
- C.
  
  ...is the single identification label given to a person or item.
- D.
  
  ...is the single piece of information about a person or item
- E.
  
  ...is all of the data about one person or item.
Correct Answer
E. ...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:

1
0
7.

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

Correct Answer
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:

5
4 0
8.

A persons' First name, Last name, Date of Birth (DOB), Height, Eye colour and Address are all types of what?
- A.
  
  Records
- B.
  
  Fields
- C.
  
  Tables
- D.
  
  Files
- E.
  
  Tags
Correct Answer
B. 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:

1
1

Quiz Review Timeline +

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

ICT - Database Questions

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

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

What are the disadvantages for paper-based databases

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

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

In a Database, a RECORD is...?

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

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