Question 1

A character is a single letter, number, or symbol.

Accepted Answer

A) True 
 B)False

Question 2

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.E) All of the above
F) A) and D)

Question 3

Data within the data warehouse is:

Accepted Answer

A)  Volatile - its release is restricted and potentially hazardous to the organization.
B)  Volatile - it may be deleted by specific users.
C)  Nonvolatile - it does not change rapidly.
D)  Nonvolatile - is protected against deletion.E) C) and D)
F) All of the above

Question 4

Within are relational database a record may have more than one primary key.

Accepted Answer

A) True 
 B)False

Question 5

Select the false statement from those provided.

Accepted Answer

A)  Batch processing attains a greater efficiency than real-time processing for large amounts of data items.
B)  Batch processing has a faster response time than real-time processing due to the grouping of like data items.
C)  Batch processing should be utilized for payroll type processes as it groups these similar data items.
D)  Real-time data processing has more complex audit trails for data items than batch processing.E) All of the above
F) A) and B)

Question 6

A cloud provider generally provides only the data storage space.

Accepted Answer

A) True 
 B)False

Question 7

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)  SequentialE) A) and D)
F) None of the above

Question 8

Scalability is one of the advantages of cloud-based databases.What this means is that as the company grows, they can easily purchase new capacity from the cloud provider.

Accepted Answer

A) True 
 B)False

Question 9

Real-time processing:

Accepted Answer

A)  Would not be used for payment to vendor type transactions since they are not time sensitive.
B)  Occurs when similar transactions are grouped into a batch and processed as a group.
C)  Would be utilized for processes such as payroll due to their time-sensitive nature.
D)  Occurs when the transaction is processed immediately.E) C) and D)
F) A) and B)

Question 10

A record is:

Accepted Answer

A)  An entire set of fields for a specific entity.
B)  A series of characters.
C)  A collection of files.
D)  Another name for a database.E) A) and B)
F) All of the above

Question 11

Standardizing data:

Accepted Answer

A)  Configures all of the data from one department into a single database for analysis.
B)  Configures all of the data from numerous departments into a single data configuration.
C)  Is not required within relational databases.
D)  Requires sales to keep its own files and references apart from marketing example) .E) None of the above
F) B) and D)

Question 12

SQL stands for Sequential Query Language.

Accepted Answer

A) True 
 B)False

Question 13

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 above are correct.E) C) and D)
F) A) and B)

Question 14

A file is a:

Accepted Answer

A)  Set of characters.
B)  Column within a record.
C)  Row within a record.
D)  Collection of related records.E) All of the above
F) B) and D)

Question 15

Which of the following best describes the relationship between data and information?

Accepted Answer

A)  Data are interpreted information.
B)  Information is interpreted data.
C)  Data are more useful than information in decision making.
D)  Data and information are not related.E) C) and D)
F) None of the above

Question 16

Data processing and storage:

Accepted Answer

A)  Must be kept centralized for control and security.
B)  Must be distributed for control and security.
C)  Can be distributed to meet organizational requirements.
D)  Must be kept centralized for efficient operations.E) A) and B)
F) C) and D)

Question 17

Ethical issues related to data utilization are not a consideration for data collection.

Accepted Answer

A) True 
 B)False

Question 18

Select the false statement from the following.

Accepted Answer

A)  A character is a single letter, number, or symbol.
B)  A field is a set of characters.
C)  A field can be thought of as a column of data.
D)  A file is the entire set of fieldsE) All of the above
F) A) and B)

Question 19

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.E) A) and B)
F) All of the above

Question 20

Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

Accepted Answer

A) True 
 B)False

Exam 13: Data and Databases

Select the false statement from those provided.

Correct AnswerverifiedShow Answer

SQL stands for Sequential Query Language.

Correct AnswerverifiedShow Answer

A character is a single letter, number, or symbol.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

A file is a:

Correct AnswerverifiedShow Answer

A cloud provider generally provides only the data storage space.

Correct AnswerverifiedShow Answer

Automatic integrated backup

Correct AnswerverifiedShow Answer

Scalability is one of the advantages of cloud-based databases.What this means is that as the company grows, they can easily purchase new capacity from the cloud provider.

Correct AnswerverifiedShow Answer

A record is:

Correct AnswerverifiedShow Answer

Standardizing data:

Correct AnswerverifiedShow Answer

Data within the data warehouse is:

Correct AnswerverifiedShow Answer

Select the false statement from the following.

Correct AnswerverifiedShow Answer

Ethical issues related to data utilization are not a consideration for data collection.

Correct AnswerverifiedShow Answer

High-impact processes HIPs) are:

Correct AnswerverifiedShow Answer

Data processing and storage:

Correct AnswerverifiedShow Answer

Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

Correct AnswerverifiedShow Answer

Proper IT controls will NOT:

Correct AnswerverifiedShow Answer

Real-time processing:

Correct AnswerverifiedShow Answer

Within are relational database a record may have more than one primary key.

Correct AnswerverifiedShow Answer

Which of the following best describes the relationship between data and information?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified