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
Customer inquiries during the sales order process are best handled by
A. a sales order and customer service person.
B. accounting personnel.
C. the credit manager.
A and C above
A
A company fails to bill customers due to a lack of controls. The exposure the company faces is
- customer dissatisfaction.
- an overstated accounts receivable balance.
- a loss of inventory and revenue.
- uncollectible sales and losses due to bad debts
a loss of inventory and revenue.
Sad Clown Pajamas is an Internet-based wholesaler. Customers enter their orders online. The manager of Callow Youth Clothing was entering an order when the following error message popped up: Did you mean to enter a quantity of -1000 for your order? This message is the result of a
- validity check.
- sign check
- limit check.
- completeness test.
Sign check.
In Petaluma, California, electric power is provided to consumers by the Power To The People Electrical Company, a local co-op. Each month PTTP mails bills to 70,000 households and then processes payments as they are received. The customers are provided with a remittance advice, which is a
- warning that failure to pay by the due date will result in a late charge.
- confirmation of the firm’s privacy policy.
- turnaround document.
- bill.
turnaround document
One applicable control procedure is to restrict physical access to inventory. This control feature is designed to neutralize the threat of
- theft of inventory
- billing errors
- stockouts
- posting errors
theft of inventory
Laz Chance wears roller blades and headphones when he is at work at the Squishy Things Toy Company. He is a product packer. The headphones give him computer-generated instructions so he knows the location of each item and quantity that should be included in the order. He encloses a paper form in the box when the order is complete. The form is called a
- picking ticket.
- bill of lading.
- packing slip.
- remittance advice.
- credit memo
packing slip
