Question 1

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Accepted Answer

A)  Data Manipulation Language 
B)  Data Query Language 
C)  Data Report Language 
D)  Data Definition Language 
A)  Data Manipulation Language 
B)  Data Query Language 
C)  Data Report Language 
D)  Data Definition Language B

Question 2

In a well-structured database,the constraint that ensures the consistency of the data is known as the

Accepted Answer

A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule. 
A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule. B

Question 3

The ________ is responsible for the database.

Accepted Answer

A)  database master 
B)  database manager 
C)  database administrator 
D)  data coordinator 
A)  database master 
B)  database manager 
C)  database administrator 
D)  data coordinator C

Question 4

Identify one potential outcome of the delete anomaly.

Accepted Answer

A)  inconsistent data 
B)  inability to add new data 
C)  unintentional loss of data 
D)  none of the above 
A)  inconsistent data 
B)  inability to add new data 
C)  unintentional loss of data 
D)  none of the above

Question 5

Kai Keoni has created custom statues made out of scrap metal for over ten years.He lives above his shop in Martha's Vineyard,Maryland.Kai is an accounting fanatic and has kept detailed records of every statue he has ever created.For every sale,he obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.His unique style has recently attracted the attention of several celebrities.Ready to take his business to the next level,Kai has hired you to construct an accounting information system,which he wants modeled after his paper records.As you look over his records,you realize that some customers bought multiple statues at the same time.For example,Yasmeen Ghuari bought a Tin Man Status,a flying horseman statue,and a terrier statue.You realize that in these cases,a single written record will have to be translated into multiple sales records.This is an example of what type of problem in the existing records?

Accepted Answer

A)  entity integrity 
B)  referential integrity 
C)  update anomaly 
D)  insert anomaly 
A)  entity integrity 
B)  referential integrity 
C)  update anomaly 
D)  insert anomaly

Question 6

Which one of the following results corresponds to the query below?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 7

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Accepted Answer

A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule. 
A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule.

Question 8

Describe what you think will be the main impact of database technology in your career.

Accepted Answer

Answers to this question could cover a w

Question 9

The data dictionary usually is maintained

Accepted Answer

A)  automatically by the DBMS. 
B)  by the database administrator. 
C)  by the database programmers. 
D)  by top management. 
A)  automatically by the DBMS. 
B)  by the database administrator. 
C)  by the database programmers. 
D)  by top management.

Question 10

File-oriented approaches create problems for organizations because of

Accepted Answer

A)  multiple transaction files. 
B)  a lack of sophisticated file maintenance software. 
C)  multiple users. 
D)  multiple master files. 
A)  multiple transaction files. 
B)  a lack of sophisticated file maintenance software. 
C)  multiple users. 
D)  multiple master files.

Question 11

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Accepted Answer

In file-oriented approaches,different us

Question 12

Using the database depicted below,in the Sales table,"Customer #" is best described as

Accepted Answer

A)  an attribute. 
B)  a primary key. 
C)  a foreign key. 
D)  A, B, and C 
A)  an attribute. 
B)  a primary key. 
C)  a foreign key. 
D)  A, B, and C

Question 13

The schema that provides an organization-wide view of the entire database is known as the

Accepted Answer

A)  external-level schema. 
B)  internal-level schema. 
C)  conceptual-level schema. 
D)  logical view of the database. 
A)  external-level schema. 
B)  internal-level schema. 
C)  conceptual-level schema. 
D)  logical view of the database.

Question 14

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Accepted Answer

A)  data warehouse. 
B)  database administrator. 
C)  database system. 
D)  database management system. 
A)  data warehouse. 
B)  database administrator. 
C)  database system. 
D)  database management system.

Question 15

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

Accepted Answer

A)  DDL; DML 
B)  DQL; SQL 
C)  DDL; DQL 
D)  DML; DDA 
A)  DDL; DML 
B)  DQL; SQL 
C)  DDL; DQL 
D)  DML; DDA

Question 16

Identify one potential drawback in the design and implementation of database systems for accounting.

Accepted Answer

A)  Double-entry accounting relies on redundancy as part of the accounting process, but well-designed database systems reduce and attempt to eliminate redundancy. 
B)  Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. 
C)  Relational DBMS provide the capability of integrating financial and operational data. 
D)  Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs. 
A)  Double-entry accounting relies on redundancy as part of the accounting process, but well-designed database systems reduce and attempt to eliminate redundancy. 
B)  Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. 
C)  Relational DBMS provide the capability of integrating financial and operational data. 
D)  Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs.

Question 17

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information

Question 18

Using the database depicted below,"Unit Price" is best described as

Accepted Answer

A)  an attribute. 
B)  a primary key. 
C)  a foreign key. 
D)  A, B, and C 
A)  an attribute. 
B)  a primary key. 
C)  a foreign key. 
D)  A, B, and C

Question 19

Explain the types of attributes that tables possess in a relational database.

Accepted Answer

Primary key - the attribute,or combinati

Question 20

Which of the following would not be found in a data dictionary entry for a data item?

Accepted Answer

A)  records containing a specific data item 
B)  physical location of the data 
C)  source of the data item 
D)  field type 
A)  records containing a specific data item 
B)  physical location of the data 
C)  source of the data item 
D)  field type

Exam 4: Relational Databases

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

In a well-structured database,the constraint that ensures the consistency of the data is known as the

The ________ is responsible for the database.

Identify one potential outcome of the delete anomaly.

Which one of the following results corresponds to the query below?

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Describe what you think will be the main impact of database technology in your career.

The data dictionary usually is maintained

File-oriented approaches create problems for organizations because of

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Using the database depicted below,in the Sales table,"Customer #" is best described as

The schema that provides an organization-wide view of the entire database is known as the

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

Identify one potential drawback in the design and implementation of database systems for accounting.

Describe the information that is contained in the data dictionary.

Using the database depicted below,"Unit Price" is best described as

Explain the types of attributes that tables possess in a relational database.

Which of the following would not be found in a data dictionary entry for a data item?

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .