Exam
Name___________________________________
1. A grouping of characters into a word, a group of words, or a complete number is called a record.
2. Each characteristic or quality describing a particular entity is called an attribute.
3. Program–data dependence refers to the coupling of data stored in files and software programs that use this data
such that changes in programs require changes to the data.
4. A DBMS separates the logical and physical views of data.
5. Every record in a file should contain at least one key field.
6. NoSQL technologies are used to manage sets of data that don’t require the flexibility of tables and relations.
7. Data governance deals with the policies and processes for managing the integrity and security of data in a
firm.
8. Because HTML was designed as a cross–platform language, it is the preferred method of communicating
with back–end databases.
9. A data dictionary is a language associated with a database management system that end users and
programmers use to manipulate data in the database.
10. In a relational database, complex groupings of data must be streamlined to eliminate awkward many–to–
many relationships.
11. A data warehouse may be updated by a legacy system.
12. A data warehouse is typically comprised of several smaller data marts.
13. OLAP is used for multidimensional data analysis.
14. OLAP enables users to obtain online answers to ad–hoc questions in a fairly rapid amount of time, except
when the data are stored in very large databases.
15. With in–memory computing, a computer’s primary memory (RAM) is used for processing.
16. In a Web–based database, middleware is used to transfer information from the organization’s internal
database back to the Web server for delivery in the form of a Web page to the user.
17. The disadvantage of using a Web interface for a database is that it typically requires substantial changes to
the internal database.
18. Common Gateway Interface is a specification for processing data on a Web server.
19. Data administration is a special organizational function that manages the policies and procedures through
which data can be managed as an organizational resource.
20. Data cleansing is the same process as data scrubbing.
21. Which of the following best illustrates the relationship between entities and attributes?
A) the entity PRODUCT with the attribute PURCHASE
B) the entity CUSTOMER with the attribute PURCHASE
C) the entity PRODUCT with the attribute CUSTOMER
D) the entity CUSTOMER with the attribute PRODUCT
22. Which of the following is not one of the main problems with a traditional file environment?
A) program–data independence
B) lack of flexibility in creating ad–hoc reports
C) poor security
D) data inconsistency
23. A DBMS reduces data redundancy and inconsistency by
A) enforcing referential integrity.
B) minimizing isolated files with repeated data.
C) utilizing a data dictionary.
D) uncoupling program and data.
24. A characteristic or quality describing an entity is called a(n)
A) attribute.
B) tuple.
C) field.
D) key field.
25. Which of the following non–digital data storage items is most similar to a database?
A) list of sales totals on a spreadsheet
B) cash register receipt
C) doctor’s office invoice
D) library card catalog
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.
A) data independence
B) batch processing
C) online processing
D) data redundancy
27. Duplicate data in multiple data files is called data ________.
A) independence
B) repetition
C) partitions
D) redundancy
28. A DBMS makes the
A) physical database available for different logical views.
B) logical database available for different physical views.
C) logical database available for different analytical views.
D) physical database available for different analytical views.
29. The logical view
A) presents data as they would be perceived by end users.
B) shows how data are organized and structured on the storage media.
C) allows the creation of supplementary reports.
D) presents an entry screen to the user.
30. DBMS for midrange computers include all of the following except
A) Oracle.
B) Microsoft SQL Server.
C) DB2.
D) Microsoft Access.
31. The type of logical database model that treats data as if they were stored in two–dimensional tables is the
A) hierarchical DBMS.
B) mobile DBMS.
C) non–relational DBMS.
D) relational DBMS.
32. Oracle Database Lite is a(n)
A) mainframe relational DBMS.
B) DBMS for midrange computers.
C) DBMS for small handheld computing devices.
D) Internet DBMS.
33. Microsoft SQL Server is a(n)
A) DBMS for small handheld computing devices.
B) Internet DBMS.
C) DBMS for midrange computers.
D) desktop relational DBMS.
34. In a table for customers, the information about a single customer would reside in a single
A) table.
B) column.
C) field.
D) row.
35. In a relational database, a record is referred to in technical terms as a(n)
A) field.
B) entity.
C) row.
D) tuple.
36. 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) unique ID.
D) key field.
37. A field identified in a record as holding the unique identifier for that record is called the
A) primary key.
B) unique ID.
C) key field.
D) primary field.
38. In a relational database, the three basic operations used to develop useful sets of data are
A) select, project, and join.
B) select, project, and where.
C) select, join, and where.
D) select, from, and join.
39. The select operation
A) combines relational tables to provide the user with more information than is otherwise available.
B) creates a subset consisting of all records in the file that meet stated criteria.
C) identifies the table from which the columns will be selected.
D) creates a subset consisting of columns in a table.
40. The join operation
A) creates a subset consisting of columns in a table.
B) organizes elements into segments.
C) combines relational tables to provide the user with more information than is otherwise available.
D) identifies the table from which the columns will be selected.
41. The project operation
A) organizes elements into segments.
B) combines relational tables to provide the user with more information than is otherwise available.
C) identifies the table from which the columns will be selected.
D) creates a subset consisting of columns in a table.
42. Big data does not refer to
A) data created by social media (i.e. tweets, Facebook Likes).
B) datasets with unstructured data.
C) datasets with fewer than a billion records.
D) machine–generated data (i.e. from sensors).
43. Which of the following technologies would you use to analyze the social media data collected by a major
online retailer?
A) OLAP
B) Hadoop
C) data warehouse
D) data mart
44. The data dictionary serves as an important data management tool by
A) creating an inventory of the data elements contained in the database.
B) presenting data as end users or business specialists would perceive them.
C) maintaining data in updated form.
D) assigning attributes to the data.
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.
B) relationship dictionary.
C) entity–relationship diagram.
D) data definition diagram.
46. The specialized language programmers use to add and change data in the database is called
A) structured query language.
B) a data access language.
C) a data definition language.
D) a data manipulation language.
47. The most prominent data manipulation language today is
A) DB2.
B) Crystal Reports.
C) SQL.
D) Access.
48. DBMSs typically include report–generating tools in order to
A) retrieve and display data.
B) display data in graphs.
C) perform predictive analysis.
D) display data in an easier–to–read format.
49. The process of streamlining data to minimize redundancy and awkward many–to–many relationships is
called
A) data defining.
B) data cleansing.
C) normalization.
D) data scrubbing.
50. A schematic of the entire database that describes the relationships in a database is called a(n)
A) data dictionary.
B) entity–relationship diagram.
C) data definition diagram.
D) intersection relationship diagram.
51. A one–to–one relationship between two entities is symbolized in a diagram by a line that ends with
A) a crow’s foot topped by a short mark.
B) one short mark.
C) two short marks.
D) a crow’s foot.
52. Which of the following is not one of the techniques used in Web mining?
A) server mining
B) content mining
C) user mining
D) structure mining
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
A) classification.
B) identifying associations.
C) identifying clusters.
D) identifying sequences.
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
A) identifying associations.
B) classification.
C) identifying sequences.
D) identifying clusters.
55. A data warehouse is composed of
A) historical data from legacy systems.
B) internal and external data sources.
C) current data.
D) historic and current internal data.