AceStudyClub
STUVIA REVIEW
AIN2601 – EXAM PREPARATION
EXAM PACK 2016
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
, 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
STUVIA REVIEW
AIN2601 – EXAM PREPARATION
EXAM PACK 2016
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
, 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
