Discuss the three common methods of handling errors in transaction files.

Q: Which internal control objective is concerned with ensuring that accumulated totals in the…

A: Internal controls are the procedures that are implemented to ensure operational efficiency and…

Q: What is a flat-file system?

A: A flat file system is a system that stores all the data in a single directory.

Q: What is the objective of a transaction log?

A: Auditing is a gathering of information and evaluation of evidence as to report on the degree of…

Q: Which of the following can be used to link two tables together? Select one: a. Primary Key b.…

A: Foreign key is a column or group of columns in a relational database table that provides a link…

Q: Give three examples of access control in a POS system.

A:

Q: How would you find errors in recording transactions and what is the process to correct errors?

A: Often, adding a journal entry will fix an accounting error. The journal entry adjusts the retained…

Q: Is a flowchart an effective documentation technique for identifying who or what performs a par-…

A: Flowchart:   A flowchart is a representation of the procedures related to transactions in the…

Q: A control designed to validate a transaction at the point of data entry is a. recalculation of a…

A:

Q: Explain how a data warehouse database is fundamentally different from a transaction processing…

A: Transaction Process System:   Transaction process system can be defined as a system designed to…

Q: Which of the following files is a temporary file? a. transaction file b. master file c. reference…

A:

Q: Categorize each of the following as either an equipment failure control or an unauthorized access…

A: Access Control: Access control is one of the main security components present in an operating…

Q: Distinguish between a database lockout and a deadlock.

A: Definition: Database: The database is a collection of the data that is stored and accessed in…

Q: What are the strengths and weaknesses of a batch process with sequential files?

A: In a sequential file processing in batch mode, the master file is updated by incorporating the…

Q: Explain why certain duties that are deemed incompatible in a manual system may be combined in a…

A: Computer-Based Information System: Computer-based information system refers to that arrangement…

Q: What are the three general problems associated with data redundancy?

A:

Q: Explain why the data warehouse needs to be separate from the operational database.

A: Data Warehousing:   Data warehousing is a method through which an organization collects and manages…

Q: Which statement is true about a hashing structure? a. The same address could be calculated for two…

A: Answer:   Option a.

Q: For each of the following file processing operations, indicate whether a sequential file, indexed…

A: Access Method: Access method is the method by which data stored in the database can be located or…

Q: What are the three elements that distinguish structured and unstructured problems? Give an example…

A: Transaction Process System: Transaction process system can be defined as a system designed to…

Q: Computer applications use routines for checking the validity and accuracy of transaction data called…

A: Accounting Information System: The system which helps to gather, store, and process the accounting…

Q: Define check tampering.

A:

Q: What is the effect of not returning all client-provided documents upon request?

A: If an auditor is not returning all client provided documents upon request, then this act is an…

Q: Discuss the correction of errors in more detail.

A: Errors in Accounting: Error is a mistake committed in book keeping.

Q: Which statement is NOT correct? The indexed sequential access methoda. is used for very large files…

A: Defintion: Documents: In transaction processing, documentation can be defined as a record of…

Q: In the flat-file data management environment, users are said to own their data files. What is meant…

A: Definition: Database management: Database management refers to the management of databases held…

Q: For each of the following file processing operations, indicate whether a sequential file, indexed…

A: Definition: Access Method: Access method is the method by which data stored in the database can be…

Q: How are the summary views in a data warehouse different from views in an operational database?

A: Data Warehousing:   Data warehousing is a method through which an organization collect and manage…

Q: Mention two audit procedures relating to electronic data interchange controls

A: Audit: Audit is the process of verification of the compliance of the financial statements. It…

Q: Discuss the key segregation of duties related to computer programs that process accounting…

A: The segregation of duties is an important concept in maintaining the  internal control system of the…

Q: Reviewing database authority tables is a(n) a. access control. b. organizational structure control.…

A: An operating device must have strict security features to guard and hold device integrity. The…

Q: Distinguish between an edit run, a sort run, and an update run.

A:

Q: What are four ways in which database management systems provide a controlled environment to manage…

A:

Q: How would you find errors in recording transactions and what is the process to correct errors?…

A: Accounting error: Accounting errors can be defined as omission of the fundamental accounting…

Q: Explain the GPC backup technique. Is it used for sequential files or direct access techniques?…

A:

Q: Outline the traditional problems associated with the flatfile model that are resolved by the…

A: Flat File:   Flat file is a model in which data is structured and formatted in such a way that…

Q: Give an example of a record that might comprise each of the four file types found in a computer…

A: Computer-based system files:   The emergence of computer transformed almost all major working…

Q: In one sentence, what does updating a master file record involve?

A: Definition: Database: A database can be defined as a collection of structured data that is stored in…

Q: Computer-based systems employ four types of files. Name them.

A: In a computer based systems, there are four types of files: Master Files Transaction Files…

Q: Give an example for each of the following control activities in the conversion cycle: transaction…

A:

Q: Discuss some of the problems associated with general ledger systems that do not have data coding…

A: Ledgers:   The transactions after being posted in journal and journal vouchers are shown in the…

Q: What type of internal control is verifying source documents before recording transactions?

A: Step 1:   The verification of source documents means to check if all the documents relating to a…

Q: Reconciliations of the General Ledger Control Accounts to the Subsidiary Ledgers are an example of…

A: In this we quote an example of Reconciliations of the General Ledger Control Accounts to the…

Q: Which of the following is NOT a database management task?a. retrievalb. storagec. summarizationd.…

A: Database management is an important tool used for the management of data files. This management…