Question 1

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

Accepted Answer

A) AIS databases store valuable information 
B) Many AISs are large and therefore potentially unwieldy 
C) The databases of some organizations are very complex 
D) The hard disk space used to store AIS databases is comparatively expensive 
E) all of these are reasons why databases are important to AISs 
A) AIS databases store valuable information 
B) Many AISs are large and therefore potentially unwieldy 
C) The databases of some organizations are very complex 
D) The hard disk space used to store AIS databases is comparatively expensive 
E) all of these are reasons why databases are important to AISs

Question 2

A Social Security number is a good example of a useful primary record key.

Accepted Answer

A) True 
 B)False

Question 3

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Accepted Answer

A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address 
A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address

Question 4

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

Accepted Answer

A) True 
 B)False

Question 5

An example of a database cardinality is "one-to-many."

Accepted Answer

A) True 
 B)False

Question 6

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

Accepted Answer

A) True 
 B)False

Question 7

The largest unit of information in an accounting information database is a data field.

Accepted Answer

A) True 
 B)False

Question 8

Database security is no longer important because DBMSs are already so safe.

Accepted Answer

A) True 
 B)False

Question 9

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system,transactions are entered into the system only once.In order to accomplish this Ander's files:

Accepted Answer

A) Must utilize magnetic tape 
B) Must be separated by function (e.g.,marketing has a set of files,production has a set,etc.) 
C) Must be located in an integrated file located in online storage 
D) Must be updated in a real?time environment 
E) Must be handled in some other manner than described above 
A) Must utilize magnetic tape 
B) Must be separated by function (e.g.,marketing has a set of files,production has a set,etc.) 
C) Must be located in an integrated file located in online storage 
D) Must be updated in a real?time environment 
E) Must be handled in some other manner than described above

Question 10

The letter "M" in the acronym DBMS stands for "maintenance."

Accepted Answer

A) True 
 B)False

Question 11

An example of a database cardinality is "one-to-few."

Accepted Answer

A) True 
 B)False

Question 12

In the REA framework,a database designer should create a ____ for each entity.

Accepted Answer

A) Record 
B) Table 
C) Secondary key 
D) all of these 
A) Record 
B) Table 
C) Secondary key 
D) all of these

Question 13

From the following choices,the best example of a primary key for an employee table would be his or her:

Accepted Answer

A) Social Security number 
B) Phone number 
C) Last name 
D) Office number 
A) Social Security number 
B) Phone number 
C) Last name 
D) Office number

Question 14

In the REA accounting framework,the letter "R" stands for:

Accepted Answer

A) Resources 
B) Recording 
C) Remembering 
D) Reporting 
A) Resources 
B) Recording 
C) Remembering 
D) Reporting

Question 15

Which of these would be an example of an "agent" in the REA framework?

Accepted Answer

A) Salesperson 
B) Customer 
C) Manager 
D) all of these are possibilities 
A) Salesperson 
B) Customer 
C) Manager 
D) all of these are possibilities

Question 16

The foreign key in one database table will always be a _______ key in a linked table.

Accepted Answer

A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true 
A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true

Question 17

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

Accepted Answer

A) Database systems can be used in microcomputers as well as on large computers 
B) Database systems are simple to install and maintain 
C) Database systems are generally less expensive than separate file systems 
D) More duplication of data occurs with a database system 
E) Fewer skilled people are required to run a database system than another system 
A) Database systems can be used in microcomputers as well as on large computers 
B) Database systems are simple to install and maintain 
C) Database systems are generally less expensive than separate file systems 
D) More duplication of data occurs with a database system 
E) Fewer skilled people are required to run a database system than another system

Question 18

A database is in third normal form if all of its records are in second normal form,and there are no transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 19

Controls that do not allow users to update the same database record at the same time are examples of:

Accepted Answer

A) Data integrity controls 
B) Data processing controls 
C) Concurrency controls 
D) Privacy controls 
A) Data integrity controls 
B) Data processing controls 
C) Concurrency controls 
D) Privacy controls

Question 20

In the E-R model,the primary record key of a file is indicated by:

Accepted Answer

A) An asterisk 
B) Underlining 
C) Using a square 
D) Printing the term (e.g.,part number)in italics 
A) An asterisk 
B) Underlining 
C) Using a square 
D) Printing the term (e.g.,part number)in italics

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

A Social Security number is a good example of a useful primary record key.

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

An example of a database cardinality is "one-to-many."

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

The largest unit of information in an accounting information database is a data field.

Database security is no longer important because DBMSs are already so safe.

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system,transactions are entered into the system only once.In order to accomplish this Ander's files:

The letter "M" in the acronym DBMS stands for "maintenance."

An example of a database cardinality is "one-to-few."

In the REA framework,a database designer should create a ____ for each entity.

From the following choices,the best example of a primary key for an employee table would be his or her:

In the REA accounting framework,the letter "R" stands for:

Which of these would be an example of an "agent" in the REA framework?

The foreign key in one database table will always be a _______ key in a linked table.

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

A database is in third normal form if all of its records are in second normal form,and there are no transitive dependencies.

Controls that do not allow users to update the same database record at the same time are examples of:

In the E-R model,the primary record key of a file is indicated by:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime,fraud,ethics,and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting on the Internet

Filters

Exam 3: Data Modeling

An example of a transitive relationship in a medical application is the one between "doctor number" and "patient name."

A Social Security number is a good example of a useful primary record key.

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

The "concurrency" control in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

An example of a database cardinality is "one-to-many."

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

The largest unit of information in an accounting information database is a data field.

Database security is no longer important because DBMSs are already so safe.

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system,transactions are entered into the system only once.In order to accomplish this Ander's files:

The letter "M" in the acronym DBMS stands for "maintenance."

An example of a database cardinality is "one-to-few."

In the REA framework,a database designer should create a ____ for each entity.

From the following choices,the best example of a primary key for an employee table would be his or her:

In the REA accounting framework,the letter "R" stands for:

Which of these would be an example of an "agent" in the REA framework?

The foreign key in one database table will always be a _______ key in a linked table.

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

A database is in third normal form if all of its records are in second normal form,and there are no transitive dependencies.

Controls that do not allow users to update the same database record at the same time are examples of:

In the E-R model,the primary record key of a file is indicated by:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime,fraud,ethics,and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting on the Internet

Filters