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
, 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 cube-
like 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
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
,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 cube-
like 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
