Question 1

Information is the interpretation of data that have been processed.

Accepted Answer

A) True 
 B)False

Question 2

Storage media and methods of processing are:

Accepted Answer

A)  Sequential and random access storage with random and batch data processing.
B)  Sequential and real time access storage with batch and real time data processing.
C)  Batch and random access storage with random and batch data processing.
D)  Sequential and random access storage with batch and real time data processing.

Question 3

In centralized data processing the processing and the databases are stored and maintained in a central location.

Accepted Answer

A) True 
 B)False

Question 4

A collection of several years' nonvolatile data used to support strategic decision-making is a n)

Accepted Answer

A)  Operational database.
B)  Data warehouse.
C)  Data mine.
D)  What-if simulation.

Question 5

Data in the data warehouse:

Accepted Answer

A)  Is analyzed by data mining.
B)  Is analyzed by SQL.
C)  Is analyzed by analytical processing.
D)  Both A and C are correct.

Question 6

Advantages of distributed databases include all EXCEPT:

Accepted Answer

A)  Reduced hardware costs.
B)  Improved responsiveness.
C)  Eased managerial obligations.
D)  Easier incremental growth.

Question 7

Magnetic tape is a form of

Accepted Answer

A)  Direct access media.
B)  Random access media.
C)  Sequential access media.
D)  Alphabetical access media.

Question 8

When the data contained in a database are stored in large, two-dimensional tables, the database is referred to as a

Accepted Answer

A)  Flat file database.
B)  Hierarchical database.
C)  Network database.
D)  Relational database.

Question 9

Magnetic)  Disk storage is:

Accepted Answer

A)  The same as magnetic tape storage.
B)  Sequential access.
C)  Random access.
D)  Not direct access.

Question 10

With structured query language SQL) :

Accepted Answer

A)  One-to-one relationships can be determined.
B)  One-to-many relationships can be determined.
C)  Many-to-one relationships can be determined.
D)  All of the possibilities, A, B, and C, are correct.

Question 11

An entire set of files is a database.

Accepted Answer

A) True 
 B)False

Question 12

Data normalization:

Accepted Answer

A)  Requires repeated groups to be deleted from the same row.
B)  Requires repeated groups to be deleted from the same column.
C)  Allows repeated groups if contained within the column.
D)  Allows repeated rows of information within two or more tables.

Question 13

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 14

A field is a n) :

Accepted Answer

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

Question 15

OLAP tools include all of the following EXCEPT:

Accepted Answer

A)  Drill down.
B)  Drill up.
C)  Pivoting.
D)  Time series analysis.

Question 16

While an employee may have access to privileged information, an example of unethical activities would be a

Accepted Answer

A)  Nurse viewing the medications of the next patient.
B)  Car salesman viewing the credit rating of a customer with a car in for warranty repairs.
C)  Manager reviewing the hours worked of an assigned employee.
D)  Warehouseman viewing the availability of materials needed for production.

Question 17

To "drill down" is the process of successive expansion of data into more detail, going from high-level data to successively lower levels of data.

Accepted Answer

A) True 
 B)False

Question 18

When using a SQL query language you are restricted to searching two tables for common values such as Vendor Name.

Accepted Answer

A) True 
 B)False

Question 19

Some of the AICPA trust services principles may include:

Accepted Answer

A)  Management, notice, choice & consent, collection, use & retention, detention, and disclosure to third parties.
B)  Management, choice & consent, collection, use & retention, backup, access, disclosure to third parties, and security for privacy.
C)  Choice & consent, collection, use & retention, access, disclosure to third parties, redundancy for privacy, and quality.
D)  Management, choice & consent, use & retention, access, disclosure to third parties, and monitoring & enforcement.

Question 20

Select the true statement from those provided.

Accepted Answer

A)  Batch processing fails to attain the efficiency of real-time processing.
B)  Real-time processing fails to attain the efficiency of batch processing.
C)  Real-time processing is efficient for large groups of similar data.
D)  Real-time processing has less complex audit trails.

Exam 13: Data and Databases

Data normalization:

Correct AnswerverifiedShow Answer

OLAP tools include all of the following EXCEPT:

Correct AnswerverifiedShow Answer

Select the true statement from those provided.

Correct AnswerverifiedShow Answer

Some of the AICPA trust services principles may include:

Correct AnswerverifiedShow Answer

Select the correct statement from the following.

Correct AnswerverifiedShow Answer

Magnetic tape is a form of

Correct AnswerverifiedShow Answer

With structured query language SQL) :

Correct AnswerverifiedShow Answer

Data in the data warehouse:

Correct AnswerverifiedShow Answer

Storage media and methods of processing are:

Correct AnswerverifiedShow Answer

In centralized data processing the processing and the databases are stored and maintained in a central location.

Correct AnswerverifiedShow Answer

When the data contained in a database are stored in large, two-dimensional tables, the database is referred to as a

Correct AnswerverifiedShow Answer

A collection of several years' nonvolatile data used to support strategic decision-making is a n)

Correct AnswerverifiedShow Answer

While an employee may have access to privileged information, an example of unethical activities would be a

Correct AnswerverifiedShow Answer

Information is the interpretation of data that have been processed.

Correct AnswerverifiedShow Answer

An entire set of files is a database.

Correct AnswerverifiedShow Answer

Advantages of distributed databases include all EXCEPT:

Correct AnswerverifiedShow Answer

When using a SQL query language you are restricted to searching two tables for common values such as Vendor Name.

Correct AnswerverifiedShow Answer

A field is a n) :

Correct AnswerverifiedShow Answer

To "drill down" is the process of successive expansion of data into more detail, going from high-level data to successively lower levels of data.

Correct AnswerverifiedShow Answer

Magnetic) Disk storage is:

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