ICT - Database Questions
(275).jpg "ICT - Database Questions - Quiz")
This Quiz follows on from the the presentation given on Databases.
- 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. DatabaseExplanation
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:
-
- 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 powercutExplanation
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:
-
- 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 themExplanation
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)
FieldExplanation
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, what is Data or Information stored in?
- A.
Garage
- B.
Storeroom
- C.
Online Server
- D.
Table
- E.
Filing cabinet
Correct Answer
D. TableExplanation
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:
-
- 7.
Tables can contain many records. Records run in: parallel/ time/ rows?
Correct Answer
rowsExplanation
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:
- 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. FieldsExplanation
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:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 03, 2010Quiz Created by
Adamwane
Back to top