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.
