ADA Test 1

Which of the statements below is false when comparing the REA model to the traditional AIS model?

Accounts in the traditional AIS are analogous to resources in the REA-based relational database.

When the human resources manager wants to gather data about salary and start date by employees and by departments, the manager would use which language?

Data Query Language

Common source documents for the revenue cycle include all of the following except

receiving report.

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

referential integrity rule.

Which of the following is not one of the three steps to implementing an REA diagram in a relational database?

Link every event to at least one resource.

Rebus Fashions provides haircuts to men and women. Rebus uses an REA database to record information that is important to the firm. Rebus has a table named "Customer" where it keeps information about its customers. Identify the attribute below that most likely does not belong in the Customer table.

Customer address and Customer hair style and Customer hair color

Attributes other than the primary key are

included to satisfy transaction processing requirements and included to meet management's information needs

What is the first step in the data processing cycle?

input

File-oriented approaches create problems for organizations because of

multiple master files.

How many tables are needed to implement an REA data model that has three distinct entities, two M:N relationships and two 1:N relationships in a relational database

5

Which SQL function is used to count the number of rows in a SQL query?

COUNT(*)

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

Events can only be merged if they share the same resources and events.

Which of the following statements is true about the development of an REA model?

The objective is to model basic value-chain activities.

Wrong statement about ORDER BY keyword is

To sort the records in descending order, use the DECENDING keyword

The general ledger

contains summary-level data for every account of the organization.

In a well-designed and normalized database, which of the following attributes would be a foreign key in a cash receipts table?

customer number

In which of the following cases is the relationship between entities not implemented by foreign keys? a) A || B b) A |< B c) A >| B d) A >< B

d) A >< B

The ________ contains information about the structure of the database.

data dictionary

Identify the four parts of the transaction processing cycle.

data input, data storage, data processing, information output

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

data modeling.

The ________ is responsible for the database.

database administrator

In a well-structured relational database,

every column in a row must be single valued.

Which of the following is not usually a consideration when designing a coding system?

government coding regulations

When printed on paper, data output is referred to as

hard copy.

Pre-numbered invoices and pre-numbered purchase orders are examples of

sequence codes.

Data must be collected about three facets of each business activity. What are they?

the business activity, the resources it affects, the people who participate

Issuing a purchase order is part of which transaction cycle?

the expenditure cycle

The ________ occurs when more than one occurrence of a specific data item in a database exists

update anomaly

Data processing includes all of the following except

verifying subsidiary ledger balances.