Question 1

The loss of transaction processing efficiency:

Accepted Answer

A) Is substantial but a necessary trade-off with relational databases. 
B) Is minimized because of the increased computing power available. 
C) Is a primary reason why relational databases are not utilized. 
D) Both B and C are correct.

Question 2

Distributed data processing and databases:

Accepted Answer

A) May require management to enforce hardware and software configuration policies. 
B) Make hardware and software configuration easier as local assets can be utilized. 
C) Ease security concerns as remote systems are not required to maintain connectivity. 
D) All of the above are correct.

Question 3

Select the correct statement from the following.

Accepted Answer

A) DDP and DDB require dependable and extensive processing power for large organizations. 
B) Distributed databases can only be accessed by local queries. 
C) Centralized data processing and databases require dependable and extensive processing power for large organizations. 
D) The trend in data processing and databases is towards centralization due to reliable internet access and increased computer power.

Question 4

Which of the following is not true of data visualization?

Accepted Answer

A) It is a tool for analyzing data 
B) It is a way to provide data in charts, graphs, maps, and other graphics 
C) It is a replacement for Big Data 
D) It allows companies to more easily outline data trends

Question 5

A database is a (n):

Accepted Answer

A) Set of characters. 
B) Row within a file. 
C) Collection of related records. 
D) Entire set of files.

Question 6

The primary key of a relational database:

Accepted Answer

A) Must be a common identifier for all of the data within the table. 
B) Must never be the first field of the table. 
C) Represents a value that is used to 
D) Is the password which allows unlimited access to the database.

Question 7

Proper IT controls will NOT:

Accepted Answer

A) Prevent a hacker from penetrating the firewall. 
B) Prevent an unauthorized user from using the computer systems. 
C) Restrict employee access to any information. 
D) Prevent an employee from sharing his password.

Question 8

Automatic integrated backup

Accepted Answer

A) May create problems because a single site's data may be at multiple locations. 
B) May create problems because backups at multiple sites may have hardware differences. 
C) At remote sites may not all be the same configuration as the central configuration. 
D) All of the answers are correct.

Question 9

Briefly describe the problems regarding data redundancy and concurrency in older methods of data storage (such as in flat-file data bases).Also describe how a relational database eliminates redundancy and concurrency problems.

Accepted Answer

The answer of Briefly describe the problems regarding data redundancy...

Question 10

Select the true statement from the following.

Accepted Answer

A) High-impact processes (HIPs) are identified by single-functional teams. 
B) High-impact processes (HIPs) and user's needs determine the data in the data warehouse. 
C) High-impact processes (HIPs) address both short-term and long-term objectives. 
D) High-impact processes (HIPs) determine the long-term strategy of the organization.

Question 11

High-impact processes (HIPs) are:

Accepted Answer

A) Critical to the short-term objectives of the organization. 
B) Only associated with events such as sales and collections. 
C) Identified and established by single-functional teams. 
D) Critical to the long-term objectives of the organization.

Question 12

Random access means:

Accepted Answer

A) All data items in the group must be read but the groups do not need to read in order. 
B) Any data item can be directly accessed without reading in sequence. 
C) All data items must be read in the order placed into the system, not alphabetically. 
D) All data items must be read in alphabetical order, not in the order they were placed in the system.

Question 13

Which type of database is the most widely used database structure today?

Accepted Answer

A) Hierarchical databases 
B) Relational databases 
C) Normalized databases 
D) Network databases

Question 14

Data mining would be useful in all of the following situations except

Accepted Answer

A) Identifying hidden patterns in customers' buying habits. 
B) Assessing customer reactions to new products. 
C) Determining customers' behavior patterns. 
D) Accessing customers' payment histories.

Question 15

Relational databases are:

Accepted Answer

A) Two-dimensional tables which can be joined in only one way. 
B) Three-dimensional tables allowing increased data relationships. 
C) Two-dimensional tables which can be joined in many ways. 
D) Either two- or three-dimensional as defined by the user.

Question 16

Which of the following statements is true regarding an operational database?

Accepted Answer

A) An operational database is an integrated collection of enterprise-wide data that includes 5 to 10 years of nonvolatile data. 
B) An operational database includes data for the current fiscal year and supports day-to-day operations and record keeping for the transaction processing system. 
C) An operational database includes data from the past 5 to 10 years and supports day-to-day operations and record keeping for the transaction processing system. 
D) None of the statements are true.

Question 17

________ is the aggregation or collection of similar data.It is the opposite of drill down in that it takes detailed data and summarizes it into larger groups.

Accepted Answer

A) Pivoting 
B) Consolidation 
C) What-if simulations 
D) Drill up

Question 18

Network databases:

Accepted Answer

A) Allow shared branches within the inverted tree structure. 
B) Allow creation of records without complete information. 
C) Are popular today because of LAN and WAN usage. 
D) Are very flexible because of the network access.

Question 19

Database management systems are categorized by the data structures they support.In which type of database management system is the data arranged in a series of tables?

Accepted Answer

A) Network 
B) Hierarchical 
C) Relational 
D) Sequential

Question 20

Each of the following is an online privacy practice recommended by the AICPA Trust Services Criteria privacy framework except:

Accepted Answer

A) Redundant data should be eliminated from the database. 
B) Notification of privacy policies should be given to customers. 
C) Private information should not be given to third parties without the customer's consent. 
D) All of the above

Exam 13: Data and Databases