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 of errors ________. A) increases B) decreases C) stays the same D) does not exist 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 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 staf 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 1st of September of 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 be 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. 8. _______ language is used to create a database and describe all the items in the database. A) Data definition B) Data manipulation C) Data query D) None of the above 9. _______ is system support software used in diagnosing system problems and planning for the growth in demand for system resources. A) Data compression software B) Intrusion prevention software AIN2601 EXAM PACK. C) File defragmentation software D) None of the above 10. Linux is an example of ______ A) an operating system B) utility software C) database management software D) a visual programming language 11. Electronic calendars, project management systems and workflow systems are part of _________ groupware tools. A) conferencing B) communication C) realtime cooperation D) collaborative management 12. An expert system is developed with a technique called ___________ A) artificial engineering B) inference engineering C) knowledge engineering D) none of the above 13. Which of the following is not an example of system support software? A) data compression software B) performance monitoring software C) office suites software D) anti-spam software 14. An example of an open source software is _________ A) Windows XP B) Linux C) Winzip D) Pastel Partner 15. Which of the following is not important when choosing an appropriate processing system? A) The typing speed of the user B) The reaction time required C) The accuracy of the information required D) The volume of transactions to be processed 16. _____ contains information that uniquely identifies a data record in a file. A) An index B) A primary field C) An internal architecture D) A quantity field 17. Another name for a multidimensional array variable is a ________ A) string variable B) table variable C) tree variable D) single variable 18. A(n) translates lower-level language programs into machine readable format. A) assembler B) compiler C) linker D) interpreter 19. In the expert system a(n) __________ is the program containing the logic and reasoning that will stimulate the logic process of the expert. A) knowledge base B) knowledge base management system C) inference engine D) user interface 20. _________ allows data to be stored or communicated in a format that requires less space than usual. A) Data compression software B) Anti-spam software C) Office suite software D) File defragmentation 21. A _________ is used when information needs to be stored in different levels. A) single variable B) string variable C) table variable D) tree variable 22. Which one of the following is not a core aspect of the company set-up structure? A) general ledger accounts B) financial categories C) inventory item files D) control accounts 23. Which one of the following is not a key element of the material resource planning (MRP II) tool? A) supplier delivery schedule B) master production schedule C) manufacturing control D) capacity requirements planning 24. In a(n) _______ database structure the physical data and query language to manipulate the data is organised as an integrated object. A) multidimensional B) object-orientated C) relational D) integrated 25. Which level, in a database system, represents the whole database, all the data files, data records and all the data fields? A) External level B) Conceptual level C) Internal level D) None of the above 26. The immediate update of the transaction files to the master files as the transaction occurs is called ________ processing. A) in-time B) real-time C) just-in-time D) batch 27. Which one of the following is NOT a method to process raw data into information? A) performing calculations B) summarising data C) defragmenting data D) classifying data 28. Which software is used to analyse data sets with the aim to uncover previously unknown trends, patterns and relationships between data? A) Data mining B) Data analysis C) Data trending D) Data relational 29. Which one of the following is NOT a factor to be considered by an organisation when deciding on an appropriate DBMS and database? A) The hardware needed to run the DBMS and database B) The database model type used should support the requirements of the organisation C) The DBMS and database vendor should be a reputable organisation and financially stable D) The database and DBMS should meet the organisation’s needs for a short amount of time 30. Which database file contains data records of a relative permanent nature (does not change regularly) about the organisation’s resources and subjects i.e. customers, suppliers, inventory, employees, etc? A) Transaction B) Record C) Master D) Reference 31. A data _________ contains a single data value and is the smallest unit of data which can be assessed in a database. A) attribute B) cell C) record D) field 32. What is commonly known as a column and represents one unique characteristic of a single database table? A) attribute B) data record C) data field D) data cell 33. Which database model is similar to a relational model, but where a relational model stores data in a two-dimensional table, this model stores data in a three or more dimensional table, creating a cubelike data structure? A) Network B) Multidimensional C) Object-oriented D) Hierarchical 34. Which one of the following does NOT for part of the three-level database architecture as suggested by ANSI-SPARC (American National Standards Institute ‘ANSI’ – Standards Planning and Requirements Committee ‘SPARC’) A) External level B) Intermediate level C) Internal level D) Conceptual level 35. Who is/are responsible to create, maintain, update and manage the application and database management system (DBMS) software which is used by the end-users to interact with the physical database? A) Database analyst B) Database administrator C) Database programmers D) Application programmers 36. Who is/are responsible to manage and control the organisation’s databases? A) Database analyst B) Database administrator C) Database programmers D) Application programmers 37. Which database language is used in the routine operation of the database to insert, delete, modify and maintain the data stored in the database? A) Data manipulation language (DML) B) Data definition language (DDL) C) Data control language (DCL) D) Data query language