The Database Terminology Quiz: Test

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 Tamme Bowen

Tamme Bowen

Community Contributor

Quizzes Created: 1 | Total Attempts: 655

Questions: 8 | Attempts: 659 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

The Database Terminology Quiz: Test - Quiz

Welcome to The Database Terminology quiz. A database is a collection of information that is accessible in different ways. For one, this quiz is designed to help see just how well you know about database creation, files, and some of the common words used. Think you have what it takes to answer them all correctly—only one way to find out, press start, and answer the questions best as you can.

Questions and Answers

1.

A single item of data in a database, a ________ corresponds to one cell in a table.

Explanation
A single item of data in a database, a field corresponds to one cell in a table. In a database table, each row represents a record, and each column represents a field. A field is used to store a specific type of data, such as a name, date, or number. It is the smallest unit of data in a database and helps organize and categorize information within a table.

Rate this question:

4
2.

The main purpose of a ________ is to attractively present data extracted from a table or query.

Explanation
A report is a tool used to present data extracted from a table or query in an attractive manner. It allows users to organize and summarize information, making it easier to understand and analyze. Reports often include visual elements such as charts, graphs, and tables, which enhance the presentation of data. By presenting data in a visually appealing format, reports help users make informed decisions and communicate information effectively.

Rate this question:

4
3.

A ________ comprises a collection of fields with different names relating to one object. A ________ occupies one row of a table.

Explanation
A record comprises a collection of fields with different names relating to one object. Each record occupies one row of a table. Therefore, in this scenario, the correct answer is "Record" for both blanks.

Rate this question:

4
4.

The intersection of one row and one column in a table, a ________ contains a single item of data.

Explanation
A cell is the intersection point of a row and a column in a table, and it contains a single item of data.

Rate this question:

4
5.

A ________ is a column used to identify the record in a table. The fields in the ________ must contain unique values in order to serve as record identifiers.

Explanation
A primary key is a column used to identify the record in a table. The fields in the primary key must contain unique values in order to serve as record identifiers. In this case, the given answer "Primary Key, Primary Key" correctly identifies the primary key as the column used to identify the record and emphasizes the uniqueness requirement of its values.

Rate this question:

1
4 0
6.

A ________ is made up of a collection of records, or rows, organized by columns. A database can consist of multiple ________.

Explanation
A table is a collection of records, or rows, organized by columns in a database. It is used to store and organize data in a structured manner. A database can consist of multiple tables, each representing a different set of related data. Tables allow for efficient storage, retrieval, and manipulation of data, making them an essential component of a database system.

Rate this question:

4
7.

A ________ is a method of retrieving data from one or more tables in a database. A ________ can extract a specific set of records and fields from one or more tables based on criteria.

Explanation
The given correct answer is "Query, Query". A query is a method used to retrieve data from one or more tables in a database. It allows for extracting a specific set of records and fields from the tables based on certain criteria. In this case, the answer repeats the word "Query" twice, suggesting that the method of retrieving data from tables in a database is through the use of queries.

Rate this question:

4
8.

A ________ comprises a collection of fields with the same name relating to different objects.

Explanation
A column comprises a collection of fields with the same name relating to different objects. In a database table, a column represents a specific type of data that is stored for each record or row. Each column has a unique name and contains values that are related to the objects represented by the table. Therefore, a column can be seen as a container for multiple fields with the same name but different values, allowing for efficient organization and retrieval of data.

Rate this question:

4

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 21, 2023

Quiz Edited by
ProProfs Editorial Team
Feb 26, 2017

Quiz Created by
Tamme Bowen

The Database Terminology Quiz: Test

A single item of data in a database, a ________ corresponds to one cell in a table.

The main purpose of a ________ is to attractively present data extracted from a table or query.

A comprises a collection of fields with different names relating to one object. A occupies one row of a table.

The intersection of one row and one column in a table, a ________ contains a single item of data.

A is a column used to identify the record in a table. The fields in the ** must contain unique values in order to serve as record identifiers.

A is made up of a collection of records, or rows, organized by columns. A database can consist of multiple .

A is a method of retrieving data from one or more tables in a database. A can extract a specific set of records and fields from one or more tables based on criteria.

A ________ comprises a collection of fields with the same name relating to different objects.

The Database Terminology Quiz: Test

A single item of data in a database, a ________ corresponds to one cell in a table.

The main purpose of a ________ is to attractively present data extracted from a table or query.

A ________ comprises a collection of fields with different names relating to one object. A ________ occupies one row of a table.

The intersection of one row and one column in a table, a ________ contains a single item of data.

A ________ is a column used to identify the record in a table. The fields in the ________ must contain unique values in order to serve as record identifiers.

A ________ is made up of a collection of records, or rows, organized by columns. A database can consist of multiple ________.

A ________ is a method of retrieving data from one or more tables in a database. A ________ can extract a specific set of records and fields from one or more tables based on criteria.

A ________ comprises a collection of fields with the same name relating to different objects.

A comprises a collection of fields with different names relating to one object. A occupies one row of a table.

A is a column used to identify the record in a table. The fields in the ** must contain unique values in order to serve as record identifiers.

A is made up of a collection of records, or rows, organized by columns. A database can consist of multiple .

A is a method of retrieving data from one or more tables in a database. A can extract a specific set of records and fields from one or more tables based on criteria.