Chapter 6

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

DBMS for midrange computers

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name? A. Data redundancy B. Data accuracy C. Data duplication D. Data normalization E. Data inconsistency

Data inconsistency

Which of the following occurs when the same attribute in related data files has different values? A. Data discrepancy B. Data redundancy C. Data inconsistency D. Data dependence E. Data duplication

Data inconsistency

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

a crow's foot topped by a short mark

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

tuple

Which of the following enables a DBMS to reduce data redundancy and inconsistency? A. Ability to minimize isolated files with repeated data B. Ability to create two-dimensional tables C. Use of a data dictionary D. Ability to couple program and data E. Ability to enforce referential integrity

Ability to minimize isolated files with repeated data

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. Airport code B. Day C. Address D. City E. State

Airport code

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 table B. Data dictionary C. Data definition diagram D. Entity-relationship diagram E. Relationship dictionary

Data dictionary

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

Data manipulation language

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

Data redundancy

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database. True or False

False

Every record in a file should contain at least one key field True or False

False

NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations. True or False

False

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. True or False

False

The logical and physical views of data are combined into a single view in a DBMS True or False

False

Which of the following is a grouping of characters into a word, a group of words, or a complete number? A. File B. Field C. Entity D. Tuple E. Table

Field

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

It enables firms to create and verify translations on a network very rapidly

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems? A. Data redundancy B. Lack of flexibility C. Lack of data sharing D. Poor security E. Program-data dependence

Lack of flexibility

Which of the following is a DBMS for desktop computers? A. Microsoft SQL Server B. Microsoft Access C. DB2 D. Microsoft Exchange E. Oracle Database

Microsoft Access

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

SQL

Which of the following best illustrates the relationship between entities and attributes? A. The entity CUSTOMER with the attribute PURCHASE B. The entity PRODUCT with the attribute CUSTOMER C. The entity PRODUCT with the attribute PURCHASE D. The entity PURCHASE with the attribute CUSTOMER E. The entity CUSTOMER with the attribute PRODUCT

The entity CUSTOMER with the attribute PURCHASE

A physical view shows data as it is actually organized and structured on the data storage media. True or False

True

A record is a group of related fields True or False

True

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships. True or False

True

DBMS have a data definition capability to specify the structure of the content of the database. True or False

True

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data True or False

True

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

attribute

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

combines relational tables to provide the user with more information than is otherwise available

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

creates a subset consisting of all records in the file that meet stated criteria.

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. identifies the table from which the columns will be selected D. creates a subset consisting of rows in a table E. organizes elements into segments

creates a subset consisting of columns in a table

The term big data refers to all of the following except: A. data created by social media (i.e. tweets, Facebook Likes) B. data from Web traffic C. machine-generated data (i.e. from sensors) D. datasets with unstructured data E. datasets with fewer than a billion records

datasets with fewer than a billion records

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

display data in a more structured and polished format than would be possible just by querying

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

entity-relationship diagram

All of the following are issues with the traditional file environment except: A. data inconsistency B. lack of flexibility in creating ad-hoc reports C. data sharing D. poor security E. inability to develop specialized applications for functional areas

inability to develop specialized applications for functional areas

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

key field

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

normalization

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

physical database available for different logical views

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

presents data as they would be perceived by end users

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

primary key

A database ________ describes a database entity A. record B. field C. byte D. value E. file

record

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

redundancy

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

relational DBMS

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

row

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

select, project, and join

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

the organization within the organization that is responsible for maintaining the data