AIN2601 EXAM PACK

SECTION A 1 The database architecture has different levels. The level with a complete view of the entire/whole database (of which there is only one such view) is known as the _______________ level. (A) user (B) internal (C) external (D) conceptual 2 The current year to date sales for each of the organisation’s customers will be contained in the _______________ database file. (A) customer transaction (B) customer master (C) customer reference (D) customer history 3 Where a spreadsheet is used for a period longer than a year the potential risk for errors _______________. (A) increases. (B) decreases. (C) stays the same. (D) does not exist. © 2015 Together We Pass. All rights reserved. 4 Which database management system (DBMS) database language is used to create a database? (A) Data definition language. (B) Data creation language. (C) Data manipulation language. (D) Data control language. 5 When processing a sales transaction the total value of the transaction will be calculated by using the VAT % per tax type which can be found in the ______________ database file. (A) VAT transaction (B) VAT master (C) VAT reference (D) VAT history 6 Which one of the following statements is not an aspect to consider when buying an accounting information system off the shelf? (A) The support and training available for the software. (B) The technical knowledge of the organisation’s IT staff. (C) The reliability of the software vendor. (D) The matching of the organisation’s requirements with the software features. 7 RSA Education Pty Ltd financial year starts on the 1 st of September each year and there are always 12 periods (months) in the financial year. Their accounting team are processing transactions in Pastel Partner for the August 2013 financial year. A journal dated 8 December 2012 must processed in which financial period? (A) Period 12 of the previous financial year. (B) Period 4 of the previous financial year. (C) Period 12 of the current financial year. (D) Period 4 of the current financial year