Question 1

Columns that are keys to different tables than the ones in which they reside are called ________.
A) attributes
B) foreign keys
C) primary keys
D) internal records
E) nonlocal keys

Accepted Answer

Columns that are keys to different tables than the ones in which they reside are referred to as foreign keys. They are used to establish relationships between tables and enable users to retrieve data from multiple tables at once.

Question 2

Each table in a database must have at least one foreign key.

Accepted Answer

A table may not have any foreign keys if it is not related to any other tables in the database. However, a table may have multiple foreign keys if it has relationships with multiple other tables.

Question 3

The rows in a database are also called ________.
A) records
B) tables
C) files
D) fields
E) laterals

Accepted Answer

Rows in a database are referred to as records, which contain information specific to one entity or object. Tables are a collection of records organized in a specific way, files are a collection of related data, and fields refer to the individual data points within a record. Laterals is not a term commonly used in database management.

Question 4

A group of similar rows or records in a table is called a file.

Accepted Answer

In database terminology, a file is a collection of similar records or rows in a table, where each record typically represents a single item, individual, or entry.

Question 5

What is the purpose of a database?

Accepted Answer

The answer of What is the purpose of a database?...

Question 6

Lists that involve data with multiple themes can be stored in a spreadsheet.

Accepted Answer

The answer of Lists that involve data with multiple themes...

Question 7

Which of the following data elements is placed higher than records in the database hierarchy?
A) file
B) field
C) character
D) byte
E) bit

Accepted Answer

The database hierarchy starts with bits, which form characters, which form fields, which form records, and then files. Therefore, file is placed higher than records in the hierarchy.

Question 8

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.
A) primary key
B) key attribute
C) foreign key
D) functionally dependent record
E) secondary key

Accepted Answer

A primary key uniquely identifies each record in a table and cannot contain any duplicate values. In this case, the "vehicle_ID" column storing the VIN number serves as a primary key in the "vehicle" table.

Question 9

A group of similar rows or records is known as ________.
A) a prototype
B) a table
C) a field
D) an attribute
E) a cluster

Accepted Answer

A table is a collection of similar rows or records in a database. Each row represents a single entity or record, and each column represents a particular attribute or field of that entity. Therefore, a table is the best choice to describe a group of similar rows or records.

Question 10

Metadata is/are ________.
A) codes used for server-side processing
B) error logs of databases
C) data that describes data
D) data that are encrypted
E) more important data

Accepted Answer

Metadata is data that describes other data, providing information about the content, context, quality, and structure of that data. It includes elements such as file names, creation dates, author names, keywords, and so on. It is used to ensure that data is well-organized, searchable, understandable, and usable by humans and machines alike.

Question 11

Metadata refers to special data that describes the structure of a database.

Accepted Answer

Metadata refers to data that provides information about other data, such as the structure, format, and relationships within a database. It is important for managing and organizing data within a system.

Question 12

A primary key in a database is a ________.
A) group of rows that identifies a unique table or file
B) column or group of columns that identifies a unique row in a table
C) group of fields or columns that represent metadata
D) group of tables or files formed to identify a unique field or row
E) group of records that identifies similar attribute

Accepted Answer

A primary key is a column or group of columns that uniquely identify each row in a table. It is used to enforce data integrity by ensuring that each row in a table is uniquely identified and can be accessed efficiently.

Question 13

A foreign key is a key of a different (foreign) table than the one in which it resides.

Accepted Answer

A foreign key is a column or a combination of columns in a table that links to the primary key of another table.

Question 14

Relational databases represent relationships using ________.
A) foreign keys
B) file systems
C) metadata
D) primary keys
E) trees

Accepted Answer

Relational databases use foreign keys to represent the relationships between tables. Foreign keys are columns that refer to the primary key of another table, creating a link between them. This enables data to be stored in separate tables but still maintained in a structured and organized manner. File systems, metadata, primary keys, and trees are also used in databases, but they do not specifically represent relationships between tables.

Question 15

The columns in a database are also called ________.
A) records
B) tables
C) files
D) fields
E) verticals

Accepted Answer

The columns in a database are called fields. Each field represents a specific piece of data within a record or row. Tables are made up of multiple rows and columns, where each row represents a record and each column represents a field. Records and files are broader terms that may refer to collections of related tables or data. Verticals is not a commonly used term in database management.

Question 16

A database is used instead of a spreadsheet when ________.
A) lists of data involve a single theme
B) structures of data lists are simple
C) lists involve data with multiple themes
D) users do not want to store all data in one place
E) users have a small amount of data to store

Accepted Answer

A database is used instead of a spreadsheet when lists involve data with multiple themes. Spreadsheets are suitable for managing data with a single theme, while databases are designed to handle more complex and interrelated data structures. Therefore, if the data has multiple themes, it is best to use a database instead of a spreadsheet.

Question 17

The purpose of a database is to keep track of lists of data that involve multiple themes.

Accepted Answer

A database is designed to store and manage large sets of data that relate to different themes or subjects. By organizing data into tables, records, and fields, a database system can provide efficient and effective tools for adding, editing, searching, and analyzing data. Databases are commonly used in various settings, such as businesses, schools, hospitals, government agencies, and research institutions.

Question 18

Which of the following is the smallest element in a database?
A) field
B) record
C) byte
D) metadata
E) zetta

Accepted Answer

The smallest unit of data in a database is a byte, which represents a single character or symbol. A field is a group of related bytes that represents a specific piece of information, while a record is a collection of fields that represents a single entity or item in the database. Metadata refers to the information about the data, such as its format or location, and a zetta is a unit of measurement for data storage that is much larger than any typical database element.

Question 19

Describe a database and its elements.

Accepted Answer

The answer of Describe a database and its elements....

Question 20

In a database, ________ are grouped into columns.
A) fields
B) records
C) bytes
D) files
E) nibbles

Accepted Answer

The answer of In a database, ________ are grouped into...

Quiz 5: Database Processing

Columns that are keys to different tables than the ones in which they reside are called ________.

Each table in a database must have at least one foreign key.

The rows in a database are also called ________.

A group of similar rows or records in a table is called a file.

What is the purpose of a database?

Lists that involve data with multiple themes can be stored in a spreadsheet.

Which of the following data elements is placed higher than records in the database hierarchy?

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.

A group of similar rows or records is known as ________.

Metadata is/are ________.

Metadata refers to special data that describes the structure of a database.

A primary key in a database is a ________.

A foreign key is a key of a different (foreign) table than the one in which it resides.

Relational databases represent relationships using ________.

The columns in a database are also called ________.

A database is used instead of a spreadsheet when ________.

The purpose of a database is to keep track of lists of data that involve multiple themes.

Which of the following is the smallest element in a database?

Describe a database and its elements.

In a database, ________ are grouped into columns.