MIS 352 Chapter 6
Which of the following enables a DBMS to reduce data redundancy and inconsistency? Ability to couple program and data Ability to create two-dimensional tables Ability to minimize isolated files with repeated data Use of a data dictionary 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? Address State Airport code City Day
Airport code
Microsoft SQL Server is a(n): DBMS for mobile devices. desktop relational DBMS. DBMS for midrange computers. Internet DBMS. DBMS for both desktops and mobile devices.
DBMS for midrange computers.
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? Entity-relationship diagram Data definition diagram Data dictionary Data table Relationship dictionary
Data dictionary
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? Data accuracy Data normalization Data duplication Data redundancy Data inconsistency
Data inconsistency
Which of the following occurs when the same attribute in related data files has different values? Data discrepancy Data redundancy Data duplication Data inconsistency Data dependence
Data inconsistency
Which of the following is a specialized language that programmers use to add and change data in the database? DBMS Structured query language Data manipulation language Data definition language Data access language
Data manipulation language
________ creates confusion that hampers the creation of information systems that integrate data from different sources. Data quality Online processing Data independence Data redundancy Batch processing
Data redundancy
CGI is a DBMS programming language that end users and programmers use to manipulate data in the database. True False
False
NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations. True False
False
Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. True False
False
The logical and physical views of data are combined into a single view in a DBMS. True False
False
Which of the following is a grouping of characters into a word, a group of words, or a complete number? Tuple File Table Field Entity
Field
Which of the following is not one of the benefits of a blockchain database? It enables firms to create and verify translations on a network very rapidly. It allows administrators to manage data more effectively. It enables the ability to use relational databases. It prevents data from being altered retroactively. 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? Data redundancy Program-data dependence Poor security Lack of flexibility Lack of data sharing
Lack of flexibility
Which of the following is a DBMS for desktop computers? Oracle Database Microsoft SQL Server Microsoft Access DB2 Microsoft Exchange
Microsoft Access
Which of the following is the most prominent data manipulation language today? NoSQL SQL Crystal Reports DB2 Access
SQL
Which of the following best illustrates the relationship between entities and attributes? The entity PURCHASE with the attribute CUSTOMER The entity PRODUCT with the attribute PURCHASE The entity CUSTOMER with the attribute PURCHASE The entity PRODUCT with the attribute CUSTOMER 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 False
True
A record is a group of related fields. True False
True
Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships. True False
True
DBMS have a data definition capability to specify the structure of the content of the database. True False
True
Every record in a file should contain at least one key field. True 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 False
True
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with: three short marks. a crow's foot. a crow's foot topped by a short mark. two short marks. one short mark.
a crow's foot topped by a short mark.
A characteristic or quality that describes a particular database entity is called a(n): attribute. tuple. relationship. key field. field.
attribute
The join operation: combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of columns in a table. identifies the table from which the columns will be selected. creates a subset consisting of rows in a table. organizes elements into segments.
combines relational tables to provide the user with more information than is otherwise available.
The select operation: combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of all records in the file that meet stated criteria. identifies the table from which the columns will be selected. creates a subset consisting of rows in a table. creates a subset consisting of columns in a table.
creates a subset consisting of all records in the file that meet stated criteria.
The project operation: organizes elements into segments. identifies the table from which the columns will be selected. creates a subset consisting of rows in a table. creates a subset consisting of columns in a table. combines relational tables to provide the user with more information than is otherwise available.
creates a subset consisting of columns in a table.
The term big data refers to all of the following except: data from Web traffic. datasets with unstructured data. data created by social media (i.e. tweets, Facebook Likes). machine-generated data (i.e. from sensors). datasets with fewer than a billion records.
datasets with fewer than a billion records.
DBMSs typically include report generating tools in order to: perform predictive analysis. retrieve and display data. display data in a more structured and polished format than would be possible just by querying. display data in graphs. analyze the database's performance.
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): entity-relationship diagram. data analysis table. data definition diagram. intersection relationship diagram. data dictionary.
entity-relationship diagram.
All of the following are issues with the traditional file environment except: data inconsistency. poor security. inability to develop specialized applications for functional areas. lack of flexibility in creating ad-hoc reports. data sharing.
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: primary field. primary key. key field. key attribute. unique ID.
key field
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: optimization. data defining. data scrubbing. data cleansing. normalization.
normalization.
A DBMS makes the: physical database available for different analytic views. relational database available for different logical views. physical database available for different logical views. relational database available for different analytic views. logical database available for different analytic views.
physical database available for different logical views.
The logical view of a database: displays the organization and structure of data on the physical storage media. presents data as they would be perceived by end users. includes a digital dashboard. enables users to manipulate the logical structure of the database. allows the creation of supplementary reports.
presents data as they would be perceived by end users.
A database ________ describes a database entity. field file value record byte
record
Data ________ occurs when the same data is duplicated in multiple files of a database. repetition independence partitions redundancy discrepancy
redundancy
A(n) ________ represent data as two-dimensional tables. mobile DBMS non-relational DBMS hierarchical DBMS relational DBMS object-oriented DBMS
relational DBMS
In a table for customers, the information about a single customer resides in a single: field. entity. table. column. row.
row.
In a relational database, the three basic operations used to develop useful sets of data are: where, find, and select. where, from, and join. select, join, and where. select, project, and where. select, project, and join.
select, project, and join.
Microsoft Access's data dictionary displays all of the following information about a field except the: the organization within the organization that is responsible for maintaining the data. format of the field. type of the field. size of the field. description of the field.
the organization within the organization that is responsible for maintaining the data.
In a relational database, a record is referred to in technical terms as a(n): table. tuple. key. field. entity.
tuple
A field identified in a table as holding the unique identifier of the table's records is called the: key field. unique ID. primary entity. primary field. primary key.
primary key
