Test 2 Quizzes Flashcards
How would the data for a customer inquiry be represented in a Data Flow Diagram (DFD)?
Arrow
—————->
Which symbol would be used in a flowchart to represent a general ledger?
_
/_/
Which symbol would be used to show matching the following paper-based documents: invoice, purchase order, and receiving report?
____
\ /
_/
Manual Operation
Identify the three types of data anomalies that can occur in databases. create anomaly update anomaly Correct insert anomaly Correct retrieve anomaly select anomaly delete anomaly Correct closed-loop anomaly
update
insert
delete
T/F:
A Primary key can be null
False
T/F:
A Foreign key can be null
True
T/F:
Minimal data redundancy and data inconsistencies is an advantage of a database systems.
True
T/F:
A Data Dictionary defines all elements that are available to build a database for a business, much like an Oxford dictionary defines all the words that could be used in this question.
False, the database developer defines the elements needed in each database
T/F:
To get to first normal form, repeating groups of fields have to be removed.
True
Which schema represents an individual user’s view of the portions of a database to which s/he has access.
external level schema
internal level schema
conceptual level schema
external level schema
An employee authorizes a credit memo for a sales return when the goods were never actually returned. Which internal control would provide the best protection?
- monthly statement to customers
- reconciliation of subsidiary accounts to general ledger
- configuration of ERP system to require a receiving report for a sales return credit memo
- segretation of duties of credit authorization and shipping
configuration of ERP system to require a receiving report for a sales return credit memo
A business experiences unauthorized disclosure of the buying habits of several well-known customers. Which internal control would provide the best protection?
- data entry controls
- access controls
- data entry edit controls
- rfid technology
access controls
A business loses all information about amounts owed by customers in New York City because the master database for that office was destroyed in a fire. Describe internal controls that would provide protection from this problem.
- Regular backups stored offsite
- Hot site
- Disaster recovery plan
- All of the above
All
The company’s website is unavailable for seven hours because of a power outage. Describe internal controls that would provide protection from this problem.
- Real-time mirroring
- UPS
- FEDI
- CRM
Realtime Mirroring
**UPS gets partial credit because typically they only have enough time to back up data and safely shut down
A sales clerk sells a $7,000 item to a friend and alters the price to $700. Describe internal controls that would provide protection from this problem.
- Supervisor approval for sales
- Supervisor approval for price changes
- Supervisor approval for change logs
- Supervisor approval for new customers
Supervisor approval for price changes
Which of the following techniques is the most efficient way to process customer payments and update accounts receivable? EFT UPIC FEDI ACH
FEDI
Why should inventory quantities on hand be checked before a sale is actually made?
A. to inform the customer about availability and delivery times
B. to know which items must be back ordered
C. to inform inventory control of mistakes in the inventory records
A and B above
A and B above
When a customer pays off the balance on an invoice, the transaction is credited to the \_\_\_\_\_\_\_\_\_\_ file. customer master sales transaction cash receipts All of the above are correct.
customer master file