MIS Chapter 6

63) An alternative to using application server software for interfacing between a Web server and back-end databases is

A) CGI.

32) Oracle Database Lite is a(n)

A) DBMS for small handheld computing devices.

56) All of the following are technologies used to analyze and manage big data except

A) cloud computing.

40) The join operation

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

45) An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

A) data dictionary.

42) Big data does not refer to

A) datasets with fewer than a billion records.

64) The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

A) information policy.

25) Which of the following non-digital data storage items is most similar to a database?

A) library card catalog

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

A) normalization.

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

A) primary key.

27) Duplicate data in multiple data files is called data ________.

A) redundancy

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

A) tuple.

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

A) two short marks.

59) OLAP is a tool for enabling

A) users to obtain online answers to ad-hoc questions in a rapid amount of time.

62) ________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

B) Text mining

46) The specialized language programmers use to add and change data in the database is called

B) a data manipulation language.

41) The project operation

B) creates a subset consisting of columns in a table.

44) The data dictionary serves as an important data management tool by

B) creating an inventory of the data elements contained in the database.

26) The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

B) data redundancy

65) The special organizational function whose responsibilities include physical database design and maintenance, is called

B) database administration.

48) DBMSs typically include report-generating tools in order to

B) display data in an easier-to-read format.

60) Data mining is a tool for allowing users to

B) find hidden relationships in data.

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

B) key field.

28) A DBMS makes the

B) logical database available for different analytical views.

22) Which of the following is not one of the main problems with a traditional file environment?

B) program-data independence

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

B) row.

57) A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data?

B) sentiment analysis software

21) Which of the following best illustrates the relationship between entities and attributes?

B) the entity CUSTOMER with the attribute PURCHASE

58) The tool that enables users to view the same data in different ways using multiple dimensions is

C) OLAP.

47) The most prominent data manipulation language today is

C) SQL.

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

C) airport code

67) Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

C) data scrubbing.

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

C) entity-relationship diagram.

53) You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of

C) identifying sequences.

61) In terms of data relationships, associations refers to

C) occurrences linked to a single event.

31) The type of logical database model that treats data as if they were stored in two-dimensional tables is the

C) relational DBMS.

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

C) select, project, and join.

70) Which of the following is not a method for performing a data quality audit?

C) surveying data definition and query files

33) Microsoft SQL Server is a(n)

D) DBMS for midrange computers.

43) Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

D) Hadoop

30) DBMS for midrange computers include all of the following except

D) Microsoft Access.

24) A characteristic or quality describing an entity is called a(n)

D) attribute.

54) You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

D) classification.

39) The select operation

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

66) 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?

D) data inconsistency

69) Data cleansing not only corrects errors but also

D) enforces consistency among different sets of data.

55) A data warehouse is composed of

D) historic and current internal data.

23) A DBMS reduces data redundancy and inconsistency by

D) minimizing isolated files with repeated data.

29) The logical view

D) presents data as they would be perceived by end users.

52) Which of the following is not one of the techniques used in Web mining?

D) user mining