Question 1

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

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 D

Question 2

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

Accepted Answer

A)  NOT operator 
B)  AND operator 
C)  OR operator 
D)  NOR operator 
A)  NOT operator 
B)  AND operator 
C)  OR operator 
D)  NOR operator B

Question 3

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Accepted Answer

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

Question 4

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

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 5

Briefly discuss the advantages and disadvantages of database marketing.

Accepted Answer

Answers will vary.Database marketing off

Question 6

Briefly explain the types of business analytics (BA) methods.

Accepted Answer

Answers will vary.There are several type

Question 7

In a(n) _____, each record can have multiple parent and child records.

Accepted Answer

A)  network model 
B)  hierarchical model 
C)  object-oriented model 
D)  relational model 
A)  network model 
B)  hierarchical model 
C)  object-oriented model 
D)  relational model

Question 8

Which of the following statements is true of a database?

Accepted Answer

A)  It allows more than one program to use the same data. 
B)  It comprises data that cannot be linked. 
C)  It consists of a segregated set of files. 
D)  It is a crucial tool for managing overseas subsidiaries. 
A)  It allows more than one program to use the same data. 
B)  It comprises data that cannot be linked. 
C)  It consists of a segregated set of files. 
D)  It is a crucial tool for managing overseas subsidiaries.

Question 9

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 10

Describe how data stored in a relational model is retrieved from tables.

Accepted Answer

Answers will vary.Data stored in a relat

Question 11

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

Accepted Answer

Answers will vary.ETL refers to the proc

Question 12

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary.A distributed database

Question 13

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

Accepted Answer

A)  insert operation 
B)  join operation 
C)  find operation 
D)  select operation 
A)  insert operation 
B)  join operation 
C)  find operation 
D)  select operation

Question 14

Discuss the advantages of a database over a flat file system.

Accepted Answer

Answers will vary.A database has the fol

Question 15

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Accepted Answer

A)  Implosion in data growth 
B)  Brick and mortar businesses 
C)  Mobile and wireless technology 
D)  Exponential decay of organizational data 
A)  Implosion in data growth 
B)  Brick and mortar businesses 
C)  Mobile and wireless technology 
D)  Exponential decay of organizational data

Question 16

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following statements is true of a flat file system?

Accepted Answer

A)  Same data can be stored in more than one file. 
B)  Programs and data are independent. 
C)  Complex requests can be handled easily. 
D)  It requires very less storage space. 
A)  Same data can be stored in more than one file. 
B)  Programs and data are independent. 
C)  Complex requests can be handled easily. 
D)  It requires very less storage space.

Question 18

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

Accepted Answer

Answers will vary.The data manipulation

Question 19

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 20

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

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

Briefly discuss the advantages and disadvantages of database marketing.

Briefly explain the types of business analytics (BA) methods.

In a(n) _____, each record can have multiple parent and child records.

Which of the following statements is true of a database?

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.

Describe how data stored in a relational model is retrieved from tables.

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

Discuss why an organization might choose a distributed database.

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

Discuss the advantages of a database over a flat file system.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Which of the following statements is true of a flat file system?

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

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

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

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

Briefly discuss the advantages and disadvantages of database marketing.

Briefly explain the types of business analytics (BA) methods.

In a(n) _____, each record can have multiple parent and child records.

Which of the following statements is true of a database?

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.

Describe how data stored in a relational model is retrieved from tables.

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

Discuss why an organization might choose a distributed database.

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

Discuss the advantages of a database over a flat file system.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Which of the following statements is true of a flat file system?

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

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

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

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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