Deck 13: Data and Databases

Question 1

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 1

B

Question 2

Examples of data collection events are

A)Transactions that fill customer orders.
B)Transactions to replenish inventory.
C)Neither are examples of data collection.
D)Both answers are examples of data collection.

Answer 2

D

Question 3

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.

Answer 3

B

Question 4

Magnetic tape is a form of

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

Question 5

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 6

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 7

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.

Question 8

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 9

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 10

Each of the following is an online privacy practice recommended by the AICPA Trust Services Criteria 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

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

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 13

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.

Question 14

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 15

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 16

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 17

Structured data:

A)Includes data collected from transactions
B)Easily fit into rows and columns
C)Include accounting data
D)All of the answers are true of structured data

Question 18

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 19

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 20

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 21

(Magnetic) Disk storage is:

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

Question 22

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 23

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 24

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 25

A file is a:

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

Question 26

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 27

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
D)Would not be used for payment to vendor type transactions since they are time sensitive.

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

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 30

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 31

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 32

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 33

(Magnetic) Disk storage is:

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

Question 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

Tables in a flat file database must:

A)Must contain at least two data items at the intersection of each row and column.
B)Contain similar data throughout the row.
C)Label all columns the same to maintain the relationships of the rows.
D)Contain similar data in the column.

Question 42

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 43

Processing of a flat file table is:

A)Random.
B)Sequential.
C)Random or sequential, selectable by the user.
D)Direct.

Question 44

An example of many-to-many relationship would be:

A)One customer for one billing date.
B)Multiple customers for one inventory item.
C)Multiple vendors for multiple items.
D)One employee, three timecards for the pay period.

Question 45

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 46

In database terminology, columns are also called:

A)Primary keys
B)Record pointers
C)Attributes
D)Flat files

Question 47

An example of a one-to-one relationship would be:

A)One employee, three timecards for the pay period.
B)One customer, one billing address.
C)One customer, four shipping addresses.
D)Two employees, one skill set.

Question 48

An example of a one-to-many relationship would be:

A)One employee, three timecards for the pay period.
B)One customer, one billing address.
C)One customer, one shipping invoice.
D)Two employees, one skill set.

Question 49

A record pointer is a:

A)Column value that relates to all other values in the row.
B)Column value that points to the next address with the linked attribute.
C)Row value that points to the next address with the linked attribute.
D)Link that is only required in one-to-many relationships.

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 are examples of relationships.

Question 51

Hierarchical databases are NOT:

A)Inverted tree structures.
B)One-to-one relationships.
C)One-to-many relationships.
D)Many-to-one relationships.

Question 52

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 53

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 54

Each table in a database must meet all of the following conditions EXCEPT:

A)Each row must be uniquely named
B)Items in a column must all be of the same type of data
C)Each cell at the intersection of a row and column must contain only one data item
D)Each row must be unique in at least one attribute

Question 55

Database management systems, DBMS, is (are):

A)
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 56

Hierarchal databases:

A)Are effective in retrieving records without explicit linkages.
B)Are efficient in processing large volumes of transactions with explicit linkages.
C)Do not require built-in linkages, they can be created with queries.
D)Do not require record pointers.

Question 57

A flat file database has:

A)The ability to call necessary information from linked databases.
B)Two dimensions, rows and depth.
C)Only columns.
D)Two dimensions, rows and columns.

Question 58

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 59

Flat file records are:

A)Kept in random order.
B)Kept is sequential order.
C)Linked to other records by a common attribute.
D)Interactive and real-time processed.

Question 60

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

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

Question 61

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 62

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 63

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 64

Which of the following statement is not correct when considering the following statement: 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.

Question 65

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 66

Network databases:

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 67

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

Question 68

Structured query language (SQL):

A)I
B)Takes advantage of the primary record key to link tables.
C)Is a complex language used to extract data from a limited number of tables.
D)Does not allow conditions to be put on the query.

Question 69

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 i
D)Managers require access to historical data this is generally not available to other individuals.

Question 70

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 rea
D)Both B and C are correct.

Question 71

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 72

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 73

Relational databases are:

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 74

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 75

The primary key of a relational database:

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 76

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 are correct.

Question 77

High-impact processes (HIPs) are:

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

Question 78

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 79

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 80

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.