Question 1

Which of the following statements is true of big data?

Accepted Answer

A)  It eliminates unethical actions based on interpretations. 
B)  It can be efficiently processed and managed by conventional computing methods. 
C)  It has three dimensions, which are value, density, and uniformity. 
D)  It is the result of the exponential growth of data in both public and private organizations. 
A)  It eliminates unethical actions based on interpretations. 
B)  It can be efficiently processed and managed by conventional computing methods. 
C)  It has three dimensions, which are value, density, and uniformity. 
D)  It is the result of the exponential growth of data in both public and private organizations. D

Question 2

A _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Accepted Answer

A)  data dictionary 
B)  data pattern 
C)  data mine 
D)  data warehouse 
A)  data dictionary 
B)  data pattern 
C)  data mine 
D)  data warehouse D

Question 3

Which of the following statements is true of data marts and data warehouses?

Accepted Answer

A)  Consolidating information from different departments is easier in data marts than in data warehouses. 
B)  Data marts have more extended scope than data warehouses. 
C)  Access to data is often slower in data marts than in data warehouses. 
D)  Data marts usually perform the same types of analysis as data warehouses. 
A)  Consolidating information from different departments is easier in data marts than in data warehouses. 
B)  Data marts have more extended scope than data warehouses. 
C)  Access to data is often slower in data marts than in data warehouses. 
D)  Data marts usually perform the same types of analysis as data warehouses. D

Question 4

In comparison with a flat file system, _____ in a database.

Accepted Answer

A)  storage space is reduced 
B)  programs and data are interdependent 
C)  complex requests cannot be handled easily 
D)  data redundancy is introduced 
A)  storage space is reduced 
B)  programs and data are interdependent 
C)  complex requests cannot be handled easily 
D)  data redundancy is introduced

Question 5

Although a database can consist of only a single file, it is usually a group of files.

Accepted Answer

A) True 
 B)False

Question 6

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Accepted Answer

A)  data warehouse 
B)  data mart 
C)  data dictionary 
D)  data model 
A)  data warehouse 
B)  data mart 
C)  data dictionary 
D)  data model

Question 7

The advantage of the__________is that both sequential and random access can be used to access records, depending on the number being accessed.

Accepted Answer

A)  indexed sequential access method 
B)  progressive access method 
C)  direct random access method 
D)  random-serialized access method 
E)  Select 
A)  indexed sequential access method 
B)  progressive access method 
C)  direct random access method 
D)  random-serialized access method 
E)  Select

Question 8

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A)  Triangulation 
B)  Fragmentation 
C)  Normalization 
D)  Encapsulation 
A)  Triangulation 
B)  Fragmentation 
C)  Normalization 
D)  Encapsulation

Question 9

In the context of the types of data in a database, which of the following is a source of external data?

Accepted Answer

A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records 
A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records

Question 10

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Accepted Answer

A)  extraction 
B)  transformation 
C)  optimization 
D)  aggregation 
A)  extraction 
B)  transformation 
C)  optimization 
D)  aggregation

Question 11

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

Accepted Answer

A)  create, read, update, and delete 
B)  copy, revise, undo, and define 
C)  create, repeat, undo, and develop 
D)  copy, read, update, and define 
A)  create, read, update, and delete 
B)  copy, revise, undo, and define 
C)  create, repeat, undo, and develop 
D)  copy, read, update, and define

Question 12

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

Question 13

In a__________, the relationships among records form a treelike structure.

Accepted Answer

A)  hierarchical model 
B)  relational model 
C)  network model 
D)  spiral model 
E)  Select 
A)  hierarchical model 
B)  relational model 
C)  network model 
D)  spiral model 
E)  Select

Question 14

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Accepted Answer

A) True 
 B)False

Question 15

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.

Accepted Answer

A)  captures aggregated data 
B)  manages data transactions 
C)  focuses on a specific area 
D)  categorizes based on time 
A)  captures aggregated data 
B)  manages data transactions 
C)  focuses on a specific area 
D)  categorizes based on time

Question 16

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Accepted Answer

A)  velocity 
B)  volume 
C)  area 
D)  time 
A)  velocity 
B)  volume 
C)  area 
D)  time

Question 17

Which of the following is an advantage of a database over a flat file system?

Accepted Answer

A)  Hardware and software start-up costs are low when using a database. 
B)  A database is simple and easy to design. 
C)  Programs and data are interdependent in a database. 
D)  A database uses more sophisticated security measures. 
A)  Hardware and software start-up costs are low when using a database. 
B)  A database is simple and easy to design. 
C)  Programs and data are interdependent in a database. 
D)  A database uses more sophisticated security measures.

Question 18

Which of the following components of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

Accepted Answer

A)  The application generation component 
B)  The application definition component 
C)  The application administration component 
D)  The application manipulation component 
A)  The application generation component 
B)  The application definition component 
C)  The application administration component 
D)  The application manipulation component

Question 19

The _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

Accepted Answer

A)  data manipulation 
B)  data generation 
C)  data definition 
D)  data administration 
A)  data manipulation 
B)  data generation 
C)  data definition 
D)  data administration

Question 20

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Accepted Answer

A)  why the buyer buys a product or service 
B)  who the buyer is 
C)  how the buyer buys a product or service 
D)  where the buyer is 
A)  why the buyer buys a product or service 
B)  who the buyer is 
C)  how the buyer buys a product or service 
D)  where the buyer is

Which of the following statements is true of big data?

A _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Which of the following statements is true of data marts and data warehouses?

In comparison with a flat file system, _____ in a database.

Although a database can consist of only a single file, it is usually a group of files.

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

The advantage of the__________is that both sequential and random access can be used to access records, depending on the number being accessed.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

In the context of the types of data in a database, which of the following is a source of external data?

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

In a__________, the relationships among records form a treelike structure.

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Which of the following is an advantage of a database over a flat file system?

Which of the following components of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

The _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal, Legal, Ethical, and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet, Intranets, and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends, Technologies, and Applications

Filters

Exam 3: Database Systems, Data Warehouses, and Data Marts

Which of the following statements is true of big data?

A _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Which of the following statements is true of data marts and data warehouses?

In comparison with a flat file system, _____ in a database.

Although a database can consist of only a single file, it is usually a group of files.

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

The advantage of the__________is that both sequential and random access can be used to access records, depending on the number being accessed.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

In the context of the types of data in a database, which of the following is a source of external data?

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

In a__________, the relationships among records form a treelike structure.

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Which of the following is an advantage of a database over a flat file system?

Which of the following components of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

The _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal, Legal, Ethical, and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet, Intranets, and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends, Technologies, and Applications

Filters