Deck 13: Data and Databases

Question 1

Which of the following statements is not true with regard to a relational database?

A)It is flexible and useful for unplanned, ad hoc queries.
B)It stores data in tables.
C)It stores data in a tree formation.
D)It is maintained on direct access devices.

Answer 1

C
It stores data in a tree formation.

Question 2

Data collected would be all but the:

A)Name of the customer.
B)Selling company's name.
C)Address of the customer.
D)Credit card number of the customer.

Answer 2

B
Selling company's name.

Question 3

The reasons to store customer names, addresses, and other similar information include all but:

A)To follow up with the customer.
B)To create financial reports.
C)To expedite future orders.
D)To ease the customer's follow-on ordering processes.

Answer 3

B
To create financial reports.

Question 4

Which of the following is not an advantage of using real-time data processing?

A)Quick response time to support timely record keeping and customer satisfaction
B)Efficiency for use with large volumes of data
C)Provides for random access of data
D)Improved accuracy due to the immediate recording of transactions

Question 5

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

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

Question 6

Data is

A)The interpretation of facts that have been processed.
B)The set of facts collected from transactions.
C)The set of facts pertaining to accounts payable.
D)The set of facts pertaining to accounts receivable.

Question 7

Information is the:

A)Interpretation of data that have been processed.
B)Set of facts collected from transactions.
C)Set of facts pertaining to accounts payable.
D)Set of facts pertaining to accounts receivable.

Question 8

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

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

Question 9

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?

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

Question 10

Magnetic tape is a form of

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

Question 11

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

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.

Question 12

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

A)Attributes.
B)Data redundancy.
C)Industrial espionage.
D)Concurrency.

Question 13

Batch Processing correlates mostly to which of the following data storage techniques?

A)Sequential Access
B)Random Access
C)Database processing
D)None of the Above

Question 14

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

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

Select the false statement from the following.

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 fields

Question 16

A company's database contains three types of records: vendors, parts, and purchasing.The vendor records include the vendor number, name, address, and terms.The parts records include part numbers, name, description, and warehouse location.Purchasing records include purchase numbers, vendor numbers which reference the vendor record), part numbers which reference the parts record), and quantity.What structure of database is being used?

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

Question 17

Storage media and methods of processing are:

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 18

Each of the following is an online privacy practice recommended by the AICPA Trust Services Principles Privacy Framework except:

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.
TEST BANK - CHAPTER 13 - MULTIPLE CHOICE

Question 19

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

A)Centralized database.
B)Distributed database.
C)Flat file database.
D)High-impact process.

Question 20

A character is to a field as

A)Water is to a pool.
B)A pool is to a swimmer.
C)A pool is to water.
D)A glass is to water.

Question 21

Which of the following correctly orders the hierarchy of data from smallest to largest?

A)Field, character, record, file, database
B)Character, record, field, file, database
C)File, character, database, field, record
D)Character, field, record, file, database

Question 22

Sequential access means:

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 in which they were placed into the system
D)All data items must be read in alphabetical/numerical order, but not necessarily the order in which they were placed into the system

Question 23

Real-time processing:

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.

Question 24

Direct access:

A)Means no passwords are required to access data items in a database.
B)Is the same as sequential access.
C)Is the same as random access.
D)Is the process used by magnetic tape storage medium.

Question 25

A database is a n):

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

Question 26

A field is a:

A)Row within a record.
B)Column within a record.
C)Series or collection of records.
D)Character is a single letter, number, or symbol.

Question 27

Select the false statement from those provided.

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.

Question 28

A field is a n):

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 29

Magnetic) Disk storage is:

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

Question 30

A record is:

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.

Question 31

A file is a:

A)Set of characters.
B)Column within a record.
C)Row within a record.
D)Collection of related records.

Question 32

Random access means:

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 33

Select the true statement from those provided.

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.

Question 34

Select the correct statement from those provided below.

A)If batch processing is selected due to payroll and production type processing mandates, the entire system must be batch processing.
B)If real-time processing is selected due to sales and inventory type processing mandates, the entire system must be real-time processing.
C)If sales and inventory are real-time, payroll and production may be batch processing in a well-designed system.
D)Because sales are frequently shipped out of warehouses, sales, inventory, and payroll are all good candidates for batch processing concepts.

Question 35

Select the true statement from the following.

A)A character is a single letter only.
B)A character is a single number only.
C)A character is a single symbol only.
D)A character is a single letter, number, or symbol.

Question 36

Magnetic tape storage medium allows:

A)Sequential access storage with random data processing.
B)Random access storage with random data processing.
C)Batch access storage with random data processing.
D)Sequential access storage with sequential data processing.

Question 37

Real-time data item processing is more complex because:

A)It must utilize sequential storage medium.
B)It must group data items together before processing.
C)The slower response times indicate more systems activity.
D)There is duplication of effort in processing transactions.

Question 38

Batch processing:

A)Occurs when dissimilar transactions are grouped and processed as a group.
B)Occurs when similar transactions are grouped together and processed as a group.
C)Occurs when the transaction is processed as soon as it is entered.
D)Would not be used for payment to vendor type transactions since they are time sensitive.

Question 39

Select the false statement from those provided.

A)Real-time processing is more complex because of the interactive nature of data processing.
B)Real-time processing must use sequential storage concepts.
C)The audit trail is as complex within both real-time and batch processing systems.
D)Control totals are difficult within real-time processing due to the lack of data item groupings.

Question 40

Magnetic) Disk storage is:

A)Preferred over magnetic tape storage.
B)Sequential access.
C)Not random access.
D)Not direct access.

Question 41

Data within the data warehouse is:

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.

Question 42

The additive characteristic means:

A)The linked tables are synergetic within themselves - linked they are more powerful than alone.
B)The values in the preceding fields must total into a following field.
C)That if the preceding rules are met, the rule can be met.
D)That if the preceding rules are not met, the rule must be met.

Question 43

With structured query language SQL):

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 44

In today's IT environment:

A)Processing speed is compromised for query capability with relational databases.
B)Query capability is compromised for processing speed with relational databases.
C)Neither querying nor processing speed need be compromised with relational databases.
D)Both querying and processing speed are compromised with relational databases.

Question 45

Data normalization:

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 46

Select the correct statement from those provided.

A)The hierarchal and relational database models are both extremely flexible in their queries.
B)The hierarchal model is better suited to queries than the relational database model.
C)The relational database model is more flexible in its queries than the hierarchal mode.
D)The relational database model has better processing of large volumes of transactions.

Question 47

Which of the following terms is most closely related to data redundancy?

A)Relational database
B)Concurrency
C)Batch processing
D)One-to-many relationships

Question 48

High-impact processes HIPs):

A)Determine the structure of the data in the data warehouse.
B)Address the short-term goals of the organization.
C)Must compromise user requirements for organizational needs.
D)Determine the structure of the data in the operational database.

Question 49

Select the correct statement from the following.

A)Data redundancy and concurrency are features of well-designed database management systems.
B)Data redundancy, not concurrency, is a feature of a well-designed database management system.
C)Concurrency not, data redundancy, is a feature of a well-designed database management system.
D)Data redundancy and concurrency are not features of well-designed database management systems.

Question 50

Data reveal relationships between records.These can be thought of as:

A)One-to-one relationships.
B)Many-to-many relationships.
C)One-to-many relationships.
D)All of the above are examples of relationships.

Question 51

A "Where" condition within a structured query of a relational database:

A)Must be limited to a location such as "Warehouse #1."
B)May establish a requirement where the results are equal to a specific value.
C)May establish a requirement where the results are not equal to a specific value.
D)Both B and C are correct.

Question 52

Data redundancy occurs:

A)When shared databases are utilized.
B)When inventory has the same data in its files as sales has in its files.
C)When customer addresses are needed by both shipping and billing.
D)In all properly designed database management systems.

Question 53

Select the true statement from those provided below.

A)The data warehouse has five to ten years of data while the operational database has current year data.
B)The data warehouse has current year data while the operational database has five to ten years of data.
C)The data warehouse archives both current and long-term, five to ten years of data, within its storage.
D)The data warehouse contains only general ledger type information while the operational database has detail.

Question 54

Which of the following is NOT one of the three rules of data normalization?

A)Eliminate repeating groups
B)Eliminate redundant data
C)Eliminate blank fields
D)Eliminate columns not dependent on the primary keys

Question 55

Select the true statement from those provided below.

A)Managers use much the same data as operational departments to manage the organization.
B)All users, managers, sales, production, utilize the features of a data warehouse equally.
C)Data warehouses are isolated to protect operational information from unauthorized access.
D)Managers require access to historical data this is generally not available to other individuals.

Question 56

Database management systems, DBMS, is are):

A)Software that manages a database and controls access and use of data
B)Printed policies about the use and access to data.
C)Systems which require each user to create his own master data file.
D)Systems that allow unlimited access to the data files by all users.

Question 57

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

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 above statements are true.

Question 58

The loss of transaction processing efficiency:

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 59

The data warehouse:

A)Contains five to ten years of historical data in detail for planning and analysis.
B)Contains the current fiscal year in detail for planning, analysis, and reporting.
C)Contains the historical information needed for planning and analysis.
D)Is not utilized for planning and analysis, this information is extracted from the operational database.

Question 60

High-impact processes HIPs) are:

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 61

Potential variations in conditions that are used to understand interactions between different parts of the business is referred to as:

A)Exception reports.
B)Pivoting.
C)What-if simulations.
D)Time series analysis.

Question 62

The purpose of the data warehouse does NOT include:

A)Giving managers rich sources of current trends and data.
B)Storing current fiscal data and activity records.
C)Providing sales with current customer information.
D)Giving managers rich sources of historical trends and data.

Question 63

Advantages of distributed databases include all EXCEPT:

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

Question 64

Data in the data warehouse:

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 65

Cleansed or scrubbed data:

A)Has had all viruses removed.
B)Has had all fields standardized.
C)Has had errors and problems fixed.
D)Is data that has been stored in the data warehouse.

Question 66

Select the true statement from the following.

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 67

Distributed data processing and databases:

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 68

OLAP tools include all of the following EXCEPT:

A)Consolidation.
B)Inclusion reports.
C)Exception reports.
D)What if simulations.

Question 69

Advantages of distributed databases include all EXCEPT:

A)Easier incremental growth.
B)Multiple site access for processing.
C)Decreased user involvement.
D)Increased user control.

Question 70

________ 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.

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

Question 71

OLAP tools include all of the following EXCEPT:

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

Question 72

Standardizing data:

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).

Question 73

The various types of online analytical processing OLAP) does NOT include:

A)MOLAP - Multidimensional online analytical processing.
B)NOLAP - Notational online analytical processing.
C)ROLAP - Relational online analytical processing.
D)All of the above, A, B, and C are types of OLAP systems.

Question 74

Uploading data is putting:

A)Scrubbed files into the operational database.
B)Files from each HIP system into the operational database.
C)Standardized files onto local desktop systems for access.
D)Files from each HIP system into the data warehouse.

Question 75

Automatic integrated backup means:

A)That each site must accomplish its own backup.
B)One site may backup sites it does not normally support.
C)If data is lost at one site it may be available from another site.
D)All of the above are correct.

Question 76

Data processing and storage:

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.

Question 77

Select the correct statement from the following.

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 78

Data mining:

A)Searches for random patterns.
B)Searches for patterns in the operational database.
C)Results will not generally predict customer preferences.
D)Analyzes past patterns to predict future events.

Question 79

Automatic integrated backup

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.

Question 80

Drill down within OLAP is:

A)Identifying trends in the comparison of data in several databases.
B)The aggregation or collection of similar data from several databases.
C)The presentation of variances from the expected in dollar value.
D)Is the successive expansion of data as lower levels of data are exposed.