Question 1

Every record in a file should contain at least one key field.

Accepted Answer

A key field is a field that uniquely identifies each record in a file. It is important to have at least one key field to ensure proper organization and retrieval of data.

Question 2

Microsoft Access's data dictionary displays all of the following information about a field except the:
A)size of the field.
B)format of the field.
C)description of the field.
D)type of the field.
E)the organization within the organization that is responsible for maintaining the data.

Accepted Answer

Microsoft Access's data dictionary displays the size, format, description, and type of each field, but it does not include information about the organization responsible for maintaining the data.

Question 3

A schematic of the entire database that describes the relationships in a database is called a(n):
A)data dictionary.
B)intersection relationship diagram.
C)entity-relationship diagram.
D)data definition diagram.
E)data analysis table.

Accepted Answer

A schematic of the entire database that describes the relationships in a database is called an entity-relationship diagram. Data dictionary is a collection of descriptions of data objects, data elements, files, database tables, and other database structures. Intersection relationship diagram, data definition diagram, and data analysis table are not commonly used terms in database design.

Question 4

The logical and physical views of data are combined into a single view in a DBMS.

Accepted Answer

In a DBMS, the logical view represents how data is perceived by users, while the physical view deals with how data is actually stored on storage media. These views are kept separate to allow for data abstraction and independence.

Question 5

The project operation:
A)combines relational tables to provide the user with more information than is otherwise available.
B)creates a subset consisting of columns in a table.
C)organizes elements into segments.
D)identifies the table from which the columns will be selected.
E)creates a subset consisting of rows in a table.

Accepted Answer

The project operation in relational databases creates a subset consisting of specific columns from a table, effectively filtering out the unwanted columns.

Question 6

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security?
A)Data dictionary
B)Data definition diagram
C)Entity-relationship diagram
D)Relationship dictionary
E)Data table

Accepted Answer

A data dictionary is a file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security. The other options are not files that store this type of information. A data definition diagram (B) is a visual representation of the relationships between data components, an entity-relationship diagram (C) is a conceptual representation of data objects and their relationships, a relationship dictionary (D) is not a common term or practice, and a data table (E) is a structure that stores data.

Question 7

The join operation:
A)combines relational tables to provide the user with more information than is otherwise available.
B)identifies the table from which the columns will be selected.
C)creates a subset consisting of columns in a table.
D)organizes elements into segments.
E)creates a subset consisting of rows in a table.

Accepted Answer

The join operation combines relational tables to provide the user with more information than is otherwise available. It allows for the combination of rows from two or more tables based on a related column between them. This results in a larger table with all the columns and rows that match the criteria of the join.

Question 8

Which of the following is not one of the benefits of a blockchain database?
A)It enables the ability to use relational databases.
B)It prevents data from being altered retroactively.
C)It allows administrators to manage data more effectively.
D)It enables firms to create and verify translations on a network very rapidly.
E)It provides users with an integrated view of the data.

Accepted Answer

The answer of Which of the following is not one...

Question 9

In a table for customers,the information about a single customer resides in a single:
A)field.
B)row.
C)column.
D)table.
E)entity.

Accepted Answer

A row in a table represents a single record or entity, in this case a single customer. Each column in the row represents a specific piece of information about the customer, such as their name, address, etc. Therefore, the information about a single customer resides in a single row, not a field, column, or table.

Question 10

Which of the following is the most prominent data manipulation language today?
A)Access
B)DB2
C)SQL
D)Crystal Reports
E)NoSQL

Accepted Answer

SQL (Structured Query Language) is the most widely used language for managing and manipulating data in relational databases. It is used by various database management systems including MySQL, Oracle, and Microsoft SQL Server. Access and DB2 are specific database management systems, Crystal Reports is a reporting tool, and NoSQL is a different type of database solution that does not rely on SQL.

Question 11

Which of the following is a specialized language that programmers use to add and change data in the database?
A)Data access language
B)Data manipulation language
C)Structured query language
D)Data definition language
E)DBMS

Accepted Answer

Data manipulation language (DML) is a specialized language that programmers use to add, modify, and delete data in a database. Common examples of DML include SQL (Structured Query Language), which is used in relational databases, and MongoDB Query Language (MQL), which is used in NoSQL databases. Data access language (DAL) is a more general term that refers to any language or method used to retrieve data from a database, whereas data definition language (DDL) is used to create and modify database schema and structures. DBMS (Database Management System) refers to the software system used to manage and maintain a database.

Question 12

You are creating a database to store temperature and wind data from various airports.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?
A)Address
B)City
C)Airport code
D)State
E)Day

Accepted Answer

The airport code is a unique identifier for each airport, and therefore is the best choice for a primary key in the Airport table. Using other fields such as address, city, state, or day may result in duplicate entries or inconsistencies in the data.

Question 13

In a relational database,a record is referred to in technical terms as a(n):
A)tuple.
B)table.
C)entity.
D)field.
E)key.

Accepted Answer

A tuple refers to a single row in a relational database table, also known as a record. It contains fields that describe attributes or characteristics of the entity being represented.

Question 14

A field identified in a record as holding the unique identifier for that record is called the:
A)primary key.
B)key field.
C)primary field.
D)unique ID.
E)key attribute.

Accepted Answer

The answer of A field identified in a record as...

Question 15

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
A)normalization.
B)data scrubbing.
C)data cleansing.
D)data defining.
E)optimization.

Accepted Answer

The process described in the question (minimizing redundancy and many-to-many relationships) is the process of normalization in database management.

Question 16

The select operation:
A)combines relational tables to provide the user with more information than is otherwise available.
B)creates a subset consisting of columns in a table.
C)identifies the table from which the columns will be selected.
D)creates a subset consisting of all records in the file that meet stated criteria.
E)creates a subset consisting of rows in a table.

Accepted Answer

The select operation in relational databases is used to create a subset of records (rows) that meet specific criteria, effectively filtering the data based on the conditions provided.

Question 17

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:
A)one short mark.
B)two short marks.
C)three short marks.
D)a crow's foot.
E)a crow's foot topped by a short mark.

Accepted Answer

The answer of A one-to-many relationship between two entities is...

Question 18

In a relational database,the three basic operations used to develop useful sets of data are:
A)select,project,and where.
B)select,join,and where.
C)select,project,and join.
D)where,from,and join.
E)where,find,and select.

Accepted Answer

Select is used to retrieve specific rows from a table based on certain conditions, project is used to retrieve specific columns from a table, and join is used to combine data from two or more tables based on a common attribute. Therefore, select, project, and join are the three basic operations used to develop useful sets of data in a relational database.

Question 19

DBMSs typically include report generating tools in order to:
A)retrieve and display data.
B)display data in a more structured and polished format than would be possible just by querying.
C)display data in graphs.
D)perform predictive analysis.
E)analyze the database's performance.

Accepted Answer

Report generating tools in DBMSs are mainly used to display data in a more structured and polished format than would be possible just by querying. This makes it easier to understand and analyze the data. While some DBMSs may have additional features such as graphing and performance analysis, these are not typically the main focus of report generating tools.

Question 20

A field identified in a table as holding the unique identifier of the table's records is called the:
A)primary key.
B)key field.
C)primary field.
D)unique ID.
E)primary entity.

Accepted Answer

The primary key is the field that serves as the unique identifier of the table's records. This field helps to ensure that each record can be uniquely identified and accessed in the table.

Quiz 6: Foundations of Business Intelligence:

Every record in a file should contain at least one key field.

Microsoft Access's data dictionary displays all of the following information about a field except the:

A schematic of the entire database that describes the relationships in a database is called a(n) :

The logical and physical views of data are combined into a single view in a DBMS.

The project operation:

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security?

The join operation:

Which of the following is not one of the benefits of a blockchain database?

In a table for customers,the information about a single customer resides in a single:

Which of the following is the most prominent data manipulation language today?

Which of the following is a specialized language that programmers use to add and change data in the database?

You are creating a database to store temperature and wind data from various airports.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

In a relational database,a record is referred to in technical terms as a(n) :

A field identified in a record as holding the unique identifier for that record is called the:

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

The select operation:

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:

In a relational database,the three basic operations used to develop useful sets of data are:

DBMSs typically include report generating tools in order to:

A field identified in a table as holding the unique identifier of the table's records is called the: