Filters
Question type

The ________ is responsible for managing the enterprise's databases.

Correct Answer

verifed

verified

database a...

View Answer

Nearly all accounting information today is stored in ________.

Correct Answer

verifed

verified

Data stored in a data warehouse is used for routine business activities.

A) True
B) False

Correct Answer

verifed

verified

Data stored in a ________ may be current data, historical data, or future estimates.

Correct Answer

verifed

verified

What does the DBMS software do?

Correct Answer

verifed

verified

The DBMS software does the following.
1....

View Answer

What is the Pareto Principle? How does this principle apply to accounting database design?

Correct Answer

verifed

verified

The Pareto Principle is also called the 80/20 rule. When designing an accounting database, if you spend 80 percent of time and energy planning and design stages then just 20 percent of time will be spent on maintaining and updating the database. If just 20 percent of time and energy is spent on the planning and design stages, then 80 percent of time will be spent on maintaining and updating the database.

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to train the accountants. Your assignment is to describe to your colleagues how data flows through the accounting system architecture when a new customer is entered in the accounting software.

Correct Answer

verifed

verified

The answer should include the following ...

View Answer

One of the disadvantages of a relational database is that we can enter data once into the database, and then reuse that data in various locations where it is needed.

A) True
B) False

Correct Answer

verifed

verified

Dirty data occurs when errors are entered into a system.

A) True
B) False

Correct Answer

verifed

verified

Which of the following statements is NOT a benefit associated with entering data once into a database?


A) Reentering the same data again and again increases the chances of entering erroneous data, such as misspellings and transpositions.
B) It increase the opportunity to enter data incorrectly.
C) When you need to update the customer's address, you only need to update it once. This eliminates the possibility of updating some, but not all, of the other entries.
D) It is more efficient. You do not spend non-value-added time reentering the same information again and again.

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

B

According to the Pareto Principle, if you spend 80% of the time designing a database, you will spend 20% of your time maintaining the database.

A) True
B) False

Correct Answer

verifed

verified

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to train the accountants. Your assignment is to describe how data flows through the accounting system architecture when a report is run against the database. Start with requesting the report.

Correct Answer

verifed

verified

The answer should include the following ...

View Answer

Entering data ________ reduces the change of entering errors.

Correct Answer

verifed

verified

Nancy Smith comes in to EspressoCoffee to provide her new address and you make the appropriate updates. When preparing a sales receipt for her a week later you notice Nancy's old address appears on receipt. What does this indicate about the database?


A) The database is working correctly.
B) Nancy Smith's order was entered incorrectly.
C) The same customer was entered into the database multiple times.
D) The address information was updated for the wrong Nancy Smith.

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

Database management system (DBMS)software transfers data from the accounting software to the database.

A) True
B) False

Correct Answer

verifed

verified

True

The ________ inserts, updates, and deletes data in the database.

Correct Answer

verifed

verified

While auditing the Accounts Payable records, the auditor discovers an entry for Coffee Emporium with an address of 809 Main St., St. Louis MO and another entry for Coffee Emporium with an address of 809 Main Street, St. Louis MO. Each entry has a different vendor number. Which of the following statements is false?


A) Data was entered into the database incorrectly.
B) The onscreen form for entering vendor information correctly performed data validation.
C) The database views these as two separate accounts.
D) The data needs scrubbing.

E) B) and D)
F) A) and C)

Correct Answer

verifed

verified

Which tier in the accounting system architecture that consists of onscreen forms?


A) User tier
B) Application tier
C) Database tier
D) Accounting tier

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Which of the following is NOT a tier in the accounting system architecture?


A) Report tier
B) Database tier
C) User tier
D) Application tier

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

When using an accounting database system, such as QuickBooks, what happens when an existing customer name is entered on an onscreen invoice form?


A) The DBMS retrieves tax information and inserts it into the invoice.
B) The DBMS retrieves address and contact information and inserts it into the invoice.
C) The DBMS prompts you to enter the address and contact information.
D) The DBMS retrieves inventory information and inserts it into the form.

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

Showing 1 - 20 of 100

Related Exams

Show Answer