Isam - Chapter 6

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system. A) data quality audit B) systems analysis C) systems audit D) data analysis E) data overview

A

In a business relational database, tables contain: A) one table for each entity. B) relations among entities. C) bytes. D) three-dimensional relations. E) links to other tables.

A

In a relational database, a record is also called a(n): A) tuple. B) key field. C) entity. D) field. E) table.

A

In clustering, a data mining tool will find: A) new groupings within data. B) related predictions from existing values. C) several events grouped by time. D) new associations. E) forecasts for future events.

A

In terms of the data relationships found by data mining, sequences refers to: A) events linked over time. B) patterns that describe a group to which an item belongs. C) occurrences linked to a single event. D) undiscovered groupings. E) classifications when no groups have yet been defined.

A

Links coming out of an online document are a sign of: A) richness or variety of topics covered. B) popularity. C) data quality. D) data usage. E) marketing.

A

OLAP is a tool that enables users to: A) obtain online answers to ad hoc questions in a rapid amount of time. B) view both logical and physical views of data. C) quickly diagram data relationships. D) normalize data. E) find hidden patterns in large databases.

A

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 administration. E) data management.

A

Which of the following would you use to find patterns in user interaction data recorded by web servers? A) Web usage mining B) Web server mining C) Web structure mining D) Web content mining E) Web protocol mining

A

MongoDB and SimpleDB are both examples of: A) open source databases. B) SQL databases. C) NoSQL databases. D) cloud databases. E) big data databases.

C

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is referred to as: A) data cleansing. B) data mining. C) an information policy. D) logical database design. E) a data quality audit.

C

Which of the following database types would be best suited for storing multimedia? A) SQL DBMS B) Open source DBMS C) Non-relational DBMS D) Cloud-based database E) NoSQL DBMS.

C

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

C

Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites? A) Web usage mining B) Web server mining C) Web structure mining D) Web content mining E) Web protocol mining

C

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed. A) data mart B) data warehouse C) dashboard D) data lake E) relational DBMS

D

Data mining is more ________ than OLAP. A) data-focused B) multidimensional C) query oriented D) discovery driven E) streamlined

D

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? A) Two-tiered DBMS B) Pre-digital DBMS C) Open source DBMS D) Hierarchical DBMS E) Relational DBMS

E

A data ________ stores current and historical data of potential interest to decision makers throughout the company. A) warehouse B) mart C) archive D) mine E) center

A

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: A) it typically focuses on a single subject area or line of business. B) all the information is historical. C) it uses a web interface. D) all of the information belongs to a single company. E) it is open-source.

A

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) foreign key. E) identifying field.

A

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

A

.Which of the following best describes the importance of creating an accurate data model for your business's database? A) It is not essential, as the data model itself is modified by the database continuously. B) It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. C) It is essential, as table relationships cannot be created without an accurate data model. D) It is somewhat important, as the type of data model will define what kinds of data will be stored. E) It is unnecessary, as a well-designed database should not require one.

B

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) foreign key. E) identifying field.

B

A table that links two tables that have a many-to-many relationship is often called a(n): A) derived table. B) intersection relation. C) foreign table. D) entity-relationship table. E) derived relation.

B

All of the following are tools or technologies for extracting information from unstructured data sets except: A) sentiment analysis software. B) SQL queries. C) Hadoop. D) a non-relational DBMS. E) text mining.

B

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as: A) DSS. B) business intelligence infrastructure. C) OLAP. D) data mining. E) in-memory computing.

B

Links pointing to an online document are a sign of: A) richness or variety of topics covered. B) popularity. C) data quality. D) data usage. E) marketing

B

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) stores definitions of data elements.

B

What are the relationships that the relational database is named for? A) Relationships between rows and columns B) Relationships between entities C) Relationships between fields and records D) Relationships between databases E) Relationships between attributes

B

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

B

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table? A) One-to-many B) One-to-one C) Many-to-many D) Many-to-one E) One-to-all

B

A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS. A) web server B) online server C) database server D) client server E) application server

C

As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources. A) database management system B) relational database C) data warehouse D) data model E) fan management system

C

Big data refers to any database that: A) contains more than one petabyte of data. B) discovers patterns in data. C) has a large volume and variety of data. D) includes data from thousands of websites. E) stores data in rows and columns.

C

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos. A) Hadoop B) web mining C) text mining D) OLAP E) DBMS

C

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: A) data auditing. B) defragmentation. C) data scrubbing. D) data optimization. E) data repair.

C

Hadoop is a(n): A) NoSQL database technology that stores both data and procedures acting on the data as objects. B) data mining platform designed for storing and analyzing big data produced by web communications and transactions. C) open source software framework designed for distributing data-processing over inexpensive computers. D) pre-configured hardware-software system designed for analyzing big data. E) high-speed platform used to analyze large data sets.

C

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) select, from, and join. E) who, what, and where.

C

In terms of the data relationships found by data mining, associations refers to: A) events linked over time. B) patterns that describe a group to which an item belongs. C) occurrences linked to a single event. D) undiscovered groupings. E) classification when no groups have yet been defined.

C

Non-relational databases: A) store information in an unstructured format. B) use rows and columns to organize data. C) are used to store structured and unstructured data. D) are used to store low volumes of transactional data. E) use database-mapping to normalize relations.

C

1) From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems? A) Online ticket sales were falling. B) There were too many sources of data. C) The entities and attributes of customer records were poorly organized. D) There was too much unorganized customer data for decision makers to digest. E) The team's computer hardware was outdated.

D

A characteristic or quality describing an entity is called a(n): A) field. B) tuple. C) key field. D) attribute. E) table.

D

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

D

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as: A) hybrid DBMS. B) Hadoop. C) BI. D) analytic platforms. E) data marts

D

The logical view of a database: A) shows how data are organized and structured on the storage media. B) presents an entry screen to the user. C) allows the creation of supplementary reports. D) presents data as they would be perceived by end users. E) shows the relationships between entities and attributes.

D

The most basic business database is comprised of: A) three tables: for suppliers, parts, and sales. B) four tables: for customers, suppliers, parts, and sales. C) four tables: for customers, suppliers, sales, and employees. D) five tables: for customers, employees, suppliers, parts, and sales. E) attributes instead of tables.

D

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) specifies the content of the database.

D

Which of the following statements about data warehouses is not true? A) They store supply data to be used across the enterprise for management analysis and decision making. B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. C) They may include data from website transactions. D) Data warehouse systems provide easy-to-use tools for managers to easily update data. E) Data warehouses make data available for anyone to access as needed.

D

) Data mining is a tool for allowing users to: A) quickly compare transaction data gathered over many years. B) perform multidimensional data analysis. C) obtain online answers to ad hoc questions in a rapid amount of time. D) summarize massive amounts of data into much smaller, traditional reports. E) find hidden relationships in data.

E

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

E

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) field key diagram. D) data definition diagram. E) entity-relationship diagram.

E

Common data quality problems include all of the following except: A) misspelled names. B) transposed numbers. C) incorrect codes. D) missing codes. E) Internet connectivity problems.

E

DBMS typically include report-generating tools in order to: A) retrieve and display data. B) display data in tables. C) display data in graphs. D) perform predictive analysis. E) display data in an easier-to-read-format.

E

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

E

The smallest unit of data a computer can handle is called a: A) file. B) record. C) field. D) byte. E) bit.

E

Which of the following allows users to add, change, delete, or retrieve data in a database? A) Attribute generation B) Report generation tools C) Data dictionary D) Query wizard tool E) Data manipulation language

E

Which of the following enables users to view the same data in different ways using multiple dimensions? A) Hadoop B) SQL C) Big data D) Data mining E) OLAP

E

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) Referential integrity module B) Data definition diagram C) Entity-relationship diagram D) Relationship dictionary E) Data dictionary

E

Which of the following is an example of a company whose business model is based on access to large databases through the web? A) Gartner B) Fortune C) IBM D) Microsoft E) Facebook

E

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function. A) data management B) data administration C) server administration D) data modeling E) database administration

E