Question 1

A DBMS makes the
A) physical database available for different logical views.
B) relational database available for different logical views.
C) physical database available for different analytic views.
D) relational database available for different analytic views.
E) logical database available for different analytic views.

Accepted Answer

A DBMS (Database Management System) allows for the physical database to be presented in different logical views, enabling users to access data in a manner that is abstracted from how the data is actually organized and stored on the physical level.

Question 2

The traditional file environment does not typically have a problem with
A) data inconsistency.
B) program-data independence.
C) lack of flexibility in creating ad-hoc reports.
D) poor security.
E) data sharing.

Accepted Answer

Program-data independence is not a problem in traditional file environment since each program is designed to work with a specific file format and structure.

Question 3

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

Accepted Answer

Each row in a table corresponds to a single record or instance of the entity being represented. In this case, each row represents information about a single customer. Each column contains a specific attribute or characteristic of the customer, such as their name, address, or phone number. A field is a single unit of data within a record, so it would not be appropriate to say that all information about a customer would reside in a single field. A table contains multiple records and is not specific to a single customer.

Question 4

Data ________ occurs when the same data is duplicated in multiple files of a database.
A) redundancy
B) repetition
C) independence
D) partitions
E) discrepancy

Accepted Answer

Redundancy refers to the unnecessary duplication of data in a database, which can lead to inefficiencies and inconsistencies. It can also increase the risk of data errors and make it difficult to maintain and update the database. Therefore, minimizing redundancy is an important goal in database design.

Question 5

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

The answer of List at least three conditions that contribute...

Question 6

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

Accepted Answer

Program-data dependence refers to the relationship between software programs and the data they manipulate, where changes to one may require changes to the other in order to maintain functionality.

Question 7

The relationship between entities and attributes is best illustrated by
A) the entity CUSTOMER with the attribute PRODUCT.
B) the entity CUSTOMER with the attribute PURCHASE.
C) the entity PRODUCT with the attribute PURCHASE.
D) the entity PRODUCT with the attribute CUSTOMER.
E) the entity PURCHASE with the attribute CUSTOMER.

Accepted Answer

In this scenario, the entity CUSTOMER is related to the attribute PURCHASE, as a customer can make multiple purchases. Therefore, attribute PURCHASE is dependent on entity CUSTOMER.

Question 8

A(n) ________ is a characteristic or quality that describes a database entity.
A) field
B) tuple
C) key field
D) attribute
E) relationship

Accepted Answer

An attribute is a characteristic or quality that describes a database entity. A field is a specific location within a database, a tuple represents a single record in a database, a key field is a unique identifier for a record, and a relationship is a connection between two or more entities in a database.

Question 9

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing?
 Which of these fields might be in use in other databases used by the company?

Accepted Answer

The answer of When you design the new contracts database...

Question 10

The logical view of a database
A) displays the organization and structure of data on the physical storage media.
B) includes a digital dashboard.
C) allows the creation of supplementary reports.
D) enables users to manipulate the logical structure of the database.
E) presents data as they would be perceived by end users.

Accepted Answer

The logical view of a database presents data as they would be perceived by end users. It abstracts the physical implementation details, and presents the information in a user-friendly way. The purpose of the logical view is to provide a consistent and easy-to-understand interface for users to interact with the data. Therefore, choice E is the best answer.

Question 11

A database record is a grouping of characters into a word, a group of words, or a complete number.

Accepted Answer

A database record is a collection of fields that contain data about a specific entity, such as a person, product, or transaction. It is not simply a grouping of characters or numbers.

Question 12

Microsoft SQL Server is a(n)
A) DBMS for both desktops and mobile devices.
B) Internet DBMS.
C) desktop relational DBMS.
D) DBMS for midrange computers.
E) DBMS for mobile devices.

Accepted Answer

The answer of Microsoft SQL Server is a(n)
A) DBMS for...

Question 13

A(n) ________ organizes data in two-dimensional tables.
A) non-relational DBMS
B) mobile DBMS
C) relational DBMS
D) hierarchical DBMS
E) object-oriented DBMS

Accepted Answer

Only relational DBMS organizes data in two-dimensional tables. Non-relational DBMS stores data in non-tabular or unstructured formats like JSON, while mobile DBMS and hierarchical DBMS are specialized types of DBMS that are not designed to organize data in tables. Object-oriented DBMS organizes data in object structures rather than tables.

Question 14

When the same attribute in related data files has different values, this is called data
A) redundancy.
B) duplication.
C) dependence.
D) discrepancy.
E) inconsistency.

Accepted Answer

When the same attribute in related data files has different values, it is considered inconsistent data. This inconsistency can lead to errors when attempting to analyze or use the data.

Question 15

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?
A) enforces referential integrity
B) couples program and data
C) data dictionary
D) two-dimensional tables
E) minimizes isolated files with repeated data

Accepted Answer

Minimizing isolated files with repeated data enables a DBMS to reduce data redundancy and inconsistency. This is because data redundancy means having the same data stored in multiple places, which can lead to inconsistencies if the same data is changed in one place but not in all others. By minimizing isolated files with repeated data, a DBMS can ensure that each piece of data is only stored once, reducing redundancy and the likelihood of inconsistencies. In contrast, referential integrity ensures that relationships between data are preserved, but does not directly address redundancy and inconsistency. Coupling program and data, data dictionary, and two-dimensional tables are all basic features of a DBMS, but do not specifically address redundancy and inconsistency.

Question 16

Which of the following is not a DBMS for midrange computers?
A) DB2
B) Oracle
C) Microsoft SQL Server
D) Microsoft Access
E) Microsoft Exchange

Accepted Answer

Microsoft Access is a DBMS for personal computers and not midrange computers. The other options are all DBMS for midrange computers.

Question 17

An attribute is a characteristic or quality used to describe a particular entity.

Accepted Answer

This statement is true. An attribute is a characteristic or quality used to describe a particular entity, such as a person, place, or thing. Examples of attributes include size, color, shape, and age. Attributes are often used in databases to organize and categorize data.

Question 18

Databases record information about general categories of information referred to as entities.

Accepted Answer

Databases are designed to record information about entities, which are generally categories of information such as customers, products, or orders. These entities are represented as tables in a database, with each row representing a specific instance of that entity.

Question 19

________ creates confusion that hampers the creation of information systems that integrate data from different sources.
A) Batch processing
B) Data redundancy
C) Data independence
D) Online processing
E) Data quality

Accepted Answer

Data redundancy creates confusion by having the same piece of data stored in multiple places, which can lead to inconsistencies and challenges in integrating data from different sources.

Question 20

A(n) ________ is an example of non-digital data storage that is comparable to a database.
A) library card catalog
B) cash register receipt
C) doctor's office invoice
D) list of sales totals on a spreadsheet
E) schedule of due dates on a project outline

Accepted Answer

A library card catalog is a non-digital storage system used to organize information. It is similar to a database in that it contains information about various books and their locations, and can be searched to find specific information.

Quiz 6: Foundations of Business Intelligence: Databases and Information Management

A DBMS makes the

The traditional file environment does not typically have a problem with

In a table for customers, the information about a single customer would reside in a single

Data ________ occurs when the same data is duplicated in multiple files of a database.

List at least three conditions that contribute to data redundancy and inconsistency.

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

The relationship between entities and attributes is best illustrated by

A(n) ________ is a characteristic or quality that describes a database entity.

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

The logical view of a database

A database record is a grouping of characters into a word, a group of words, or a complete number.

Microsoft SQL Server is a(n)

A(n) ________ organizes data in two-dimensional tables.

When the same attribute in related data files has different values, this is called data

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

Which of the following is not a DBMS for midrange computers?

An attribute is a characteristic or quality used to describe a particular entity.

Databases record information about general categories of information referred to as entities.

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

A(n) ________ is an example of non-digital data storage that is comparable to a database.