Question 1

Data can be described as:

Accepted Answer

A) the same as information. 
B) the raw facts relating to or describing an event 
C) the primary output of an AIS. 
D) more useful than information. 
A) the same as information. 
B) the raw facts relating to or describing an event 
C) the primary output of an AIS. 
D) more useful than information.

Question 2

In terms of data redundancy,an important aspect of a relational database is that the tables must be carefully defined to provide __________ with minimum issues.

Accepted Answer

A) expandability 
B) functionality 
C) flexibility 
D) scalability 
A) expandability 
B) functionality 
C) flexibility 
D) scalability

Question 3

How are 1:N,1:1,and N:M relationships implemented in a database system?

Accepted Answer

To implement the 1:N (one-to-many)relati

Question 4

Data redundancy occurs when the same information is stored in multiple locations in an organisation.Which of the following is NOT true?

Accepted Answer

A) Data redundancy can lead to data inconsistency. 
B) Data redundancy can lead to data anomalies. 
C) Data redundancy can lead to repeated data. 
D) Data redundancy can provide benefits through having two sources of information. 
A) Data redundancy can lead to data inconsistency. 
B) Data redundancy can lead to data anomalies. 
C) Data redundancy can lead to repeated data. 
D) Data redundancy can provide benefits through having two sources of information.

Question 5

Which of the following is NOT a database model?

Accepted Answer

A) Network 
B) Relational 
C) SQL 
D) Hierarchical 
A) Network 
B) Relational 
C) SQL 
D) Hierarchical

Question 6

A record is:

Accepted Answer

A) a connected set of fields that describe a person,place or thing 
B) a connected set of tables that describe a person,place or thing 
C) smaller than a field 
D) none of the options are correct 
A) a connected set of fields that describe a person,place or thing 
B) a connected set of tables that describe a person,place or thing 
C) smaller than a field 
D) none of the options are correct

Question 7

Refer to the ER diagram in the previous question.The "charges time to" entity is a result of:

Accepted Answer

A) The resolution of a many-to-many relationship 
B) The resolution of a one-to-many relationship 
C) The resolution of a one-to-one relationship 
D) The resolution of an unnormalised relationship 
A) The resolution of a many-to-many relationship 
B) The resolution of a one-to-many relationship 
C) The resolution of a one-to-one relationship 
D) The resolution of an unnormalised relationship

Question 8

What are the four steps in developing ER diagrams?

Accepted Answer

The development of an E-R diagram is an

Question 9

The database model of choice for the development of most new information systems today is:

Accepted Answer

A) relational 
B) hierarchical. 
C) network. 
D) object oriented. 
A) relational 
B) hierarchical. 
C) network. 
D) object oriented.

Question 10

In any organisation,what three characteristics of information are crucial for good decision making and reporting?

Accepted Answer

A) abundant,qualitative,and quantitative 
B) accurate,relevant,and timely 
C) frequently collected,broadly covered,and up-to-date 
D) rich,complete,and precise 
A) abundant,qualitative,and quantitative 
B) accurate,relevant,and timely 
C) frequently collected,broadly covered,and up-to-date 
D) rich,complete,and precise

Question 11

Accurate,relevant and timely information comes from:

Accepted Answer

A) a properly designed database management system 
B) sound data transformation and manipulation processes 
C) quality data capture,storage and management 
D) correctly normalised data 
A) a properly designed database management system 
B) sound data transformation and manipulation processes 
C) quality data capture,storage and management 
D) correctly normalised data

Question 12

"Data that provide a consistent and correct representation regardless of where they are sourced from within a file system" is referred to as:

Accepted Answer

A) Data consistency 
B) Data integrity 
C) Data reliability 
D) Data uniformity 
A) Data consistency 
B) Data integrity 
C) Data reliability 
D) Data uniformity

Question 13

Student Table
   
Course Table
   
The Course_ID in the student table is best described as:
-Examine the database tables in Q44.Which of the following statement is true?

Accepted Answer

A) The relationship between student and course is best interpreted as 1:1. 
B) The relationship between student and course is best interpreted as 1:M. 
C) The relationship between student and course is best interpreted as M:N. 
D) The relationship between student and course cannot be determined. 
A) The relationship between student and course is best interpreted as 1:1. 
B) The relationship between student and course is best interpreted as 1:M. 
C) The relationship between student and course is best interpreted as M:N. 
D) The relationship between student and course cannot be determined.

Question 14

Which of the following statement regarding ER diagrams is correct?

Accepted Answer

A) ER diagrams look at entities and their relationships from a very detailed perspective. 
B) ER diagram is a bottom-up way of viewing the organisation. 
C) ER diagram is a bottom-up approach of developing a database model. 
D) Understanding how to read and interpret E-R diagrams is critical for accountants. 
A) ER diagrams look at entities and their relationships from a very detailed perspective. 
B) ER diagram is a bottom-up way of viewing the organisation. 
C) ER diagram is a bottom-up approach of developing a database model. 
D) Understanding how to read and interpret E-R diagrams is critical for accountants.

Question 15

What are the two approaches to database design? Discuss their differences and relationship.

Accepted Answer

The two approaches to database design ar

Question 16

Describe the three types of data anomalies.

Accepted Answer

Data anomalies can be classified into di

Question 17

Which one of the following is not a crucial factor for maximising the benefits offered by relational databases?

Accepted Answer

A) careful data collection 
B) careful data relationship design 
C) careful database modelling 
D) careful systems implementation 
A) careful data collection 
B) careful data relationship design 
C) careful database modelling 
D) careful systems implementation

Question 18

"Inconsistencies or errors that exist in a database because of entry or changes" are referred to as:

Accepted Answer

A) Data inaccuracies 
B) Data anomalies 
C) Data abnormalities 
D) Data irregularities 
A) Data inaccuracies 
B) Data anomalies 
C) Data abnormalities 
D) Data irregularities

Question 19

A ________ key allows the user to search on an attribute other than the attribute(s)that form the primary key:

Accepted Answer

A) Secondary 
B) Composite 
C) Foreign 
D) Subordinate 
A) Secondary 
B) Composite 
C) Foreign 
D) Subordinate

Question 20

In database terms,the instructions and rules that govern the design and use of the software outside programming are referred to as:

Accepted Answer

A) Procedures 
B) Policies 
C) Processes 
D) Routines 
A) Procedures 
B) Policies 
C) Processes 
D) Routines

Data can be described as:

In terms of data redundancy,an important aspect of a relational database is that the tables must be carefully defined to provide __________ with minimum issues.

How are 1:N,1:1,and N:M relationships implemented in a database system?

Data redundancy occurs when the same information is stored in multiple locations in an organisation.Which of the following is NOT true?

Which of the following is NOT a database model?

A record is:

Refer to the ER diagram in the previous question.The "charges time to" entity is a result of:

What are the four steps in developing ER diagrams?

The database model of choice for the development of most new information systems today is:

In any organisation,what three characteristics of information are crucial for good decision making and reporting?

Accurate,relevant and timely information comes from:

"Data that provide a consistent and correct representation regardless of where they are sourced from within a file system" is referred to as:

Student Table Course Table The Course_ID in the student table is best described as: -Examine the database tables in Q44.Which of the following statement is true?

Which of the following statement regarding ER diagrams is correct?

What are the two approaches to database design? Discuss their differences and relationship.

Describe the three types of data anomalies.

Which one of the following is not a crucial factor for maximising the benefits offered by relational databases?

"Inconsistencies or errors that exist in a database because of entry or changes" are referred to as:

A ________ key allows the user to search on an attribute other than the attribute(s)that form the primary key:

In database terms,the instructions and rules that govern the design and use of the software outside programming are referred to as:

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts II

XBRL Reporting

System Mapping and Documentation

Internal Controls I

Internal Controls II

Transaction Cycle The Revenue Cycle

Transaction Cycle The Expenditure Cycle

Transaction Cycle The Production Cycle

Transaction Cycle The HR Management and Payroll Cycle

Transaction Cycle The General Ledger and Financial Reporting Cycle

Systems Development

Auditing of Accounting Information Systems

Ethics, fraud and Computer Crime

Filters

Exam 3: Database Concepts I

Data can be described as:

In terms of data redundancy,an important aspect of a relational database is that the tables must be carefully defined to provide __________ with minimum issues.

How are 1:N,1:1,and N:M relationships implemented in a database system?

Data redundancy occurs when the same information is stored in multiple locations in an organisation.Which of the following is NOT true?

Which of the following is NOT a database model?

A record is:

Refer to the ER diagram in the previous question.The "charges time to" entity is a result of:

What are the four steps in developing ER diagrams?

The database model of choice for the development of most new information systems today is:

In any organisation,what three characteristics of information are crucial for good decision making and reporting?

Accurate,relevant and timely information comes from:

"Data that provide a consistent and correct representation regardless of where they are sourced from within a file system" is referred to as:

Student Table Course Table The Course_ID in the student table is best described as: -Examine the database tables in Q44.Which of the following statement is true?

Which of the following statement regarding ER diagrams is correct?

What are the two approaches to database design? Discuss their differences and relationship.

Describe the three types of data anomalies.

Which one of the following is not a crucial factor for maximising the benefits offered by relational databases?

"Inconsistencies or errors that exist in a database because of entry or changes" are referred to as:

A ________ key allows the user to search on an attribute other than the attribute(s)that form the primary key:

In database terms,the instructions and rules that govern the design and use of the software outside programming are referred to as:

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts II

XBRL Reporting

System Mapping and Documentation

Internal Controls I

Internal Controls II

Transaction Cycle The Revenue Cycle

Transaction Cycle The Expenditure Cycle

Transaction Cycle The Production Cycle

Transaction Cycle The HR Management and Payroll Cycle

Transaction Cycle The General Ledger and Financial Reporting Cycle

Systems Development

Auditing of Accounting Information Systems

Ethics, fraud and Computer Crime

Filters