Question 1

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Accepted Answer

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

Question 2

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.

Accepted Answer

A) Report printer 
B) Report creator 
C) Report generator 
D) Report writer 
A) Report printer 
B) Report creator 
C) Report generator 
D) Report writer

Question 3

Using the database depicted below,how many primary keys are in the database?

Accepted Answer

A) 0 
B) 3 
C) 4 
D) 5 
A) 0 
B) 3 
C) 4 
D) 5

Question 4

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

Accepted Answer

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

Question 5

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Accepted Answer

A) The database contains only one primary key. 
B) The database contains two foreign keys. 
C) The database contains two primary keys. 
D) The database contains only one foreign key. 
A) The database contains only one primary key. 
B) The database contains two foreign keys. 
C) The database contains two primary keys. 
D) The database contains only one foreign key.

Question 6

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Accepted Answer

A) two primary keys 
B) two foreign keys 
C) at least one column 
D) one foreign key 
A) two primary keys 
B) two foreign keys 
C) at least one column 
D) one foreign key

Question 7

Identify the aspect of a well-structured database that is incorrect.

Accepted Answer

A) Data is consistent. 
B) Redundancy is minimized and controlled. 
C) All data is stored in one table or relation. 
D) The primary key of any row in a relation cannot be null. 
A) Data is consistent. 
B) Redundancy is minimized and controlled. 
C) All data is stored in one table or relation. 
D) The primary key of any row in a relation cannot be null.

Question 8

Reports produced using the data dictionary could include all of the following except a list of

Accepted Answer

A) programs where a data item is used. 
B) synonyms for the data items in a particular file. 
C) outputs where a data element is used. 
D) the schemas included in a database. 
A) programs where a data item is used. 
B) synonyms for the data items in a particular file. 
C) outputs where a data element is used. 
D) the schemas included in a database.

Question 9

________ in a well-structured relational database.

Accepted Answer

A) Every table must be related to all other tables 
B) One table must be related to at least one other table 
C) Every table must be related to at least one other table 
D) One table must be related to all other tables 
A) Every table must be related to all other tables 
B) One table must be related to at least one other table 
C) Every table must be related to at least one other table 
D) One table must be related to all other tables

Question 10

Merlin Frodo has been doing custom piercings and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He keeps meticulous records of every job he has ever completed.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Merlin is considering adding scarification to his service offerings and has asked his accountant to identify past customers who might be likely candidates for this service.Merlin wants his accountant to engage in

Accepted Answer

A) customer auditing. 
B) customer resource management. 
C) data mining. 
D) enterprise resource planning. 
A) customer auditing. 
B) customer resource management. 
C) data mining. 
D) enterprise resource planning.

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,"Item #" 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

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Accepted Answer

A DBMS will use data definition,data man

Question 14

Which of the statements below is incorrect?

Accepted Answer

A) Semantic data modeling facilitates the efficient design of databases. 
B) Semantic data modeling facilitates communicating with the intended users of the system. 
C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D) Semantic data modeling follows the rules of normalization in the design of a database. 
A) Semantic data modeling facilitates the efficient design of databases. 
B) Semantic data modeling facilitates communicating with the intended users of the system. 
C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D) Semantic data modeling follows the rules of normalization in the design of a database.

Question 15

The ________ occurs when more than one occurrence of a specific data item in a database exists.

Accepted Answer

A) inconsistency anomaly 
B) insert anomaly 
C) delete anomaly 
D) update anomaly 
A) inconsistency anomaly 
B) insert anomaly 
C) delete anomaly 
D) update anomaly

Question 16

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 17

What is the difference in logical view and physical view?

Accepted Answer

The logical view is how the user or prog

Question 18

What are the basic requirements when logically designing a relational database model?

Accepted Answer

Every row in every table must have a uni

Question 19

All of the following are benefits of the database approach except

Accepted Answer

A) data integration and sharing. 
B) decentralized management of data. 
C) minimal data redundancy. 
D) cross-functional analysis and reporting. 
A) data integration and sharing. 
B) decentralized management of data. 
C) minimal data redundancy. 
D) cross-functional analysis and reporting.

Question 20

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.

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.

Using the database depicted below,how many primary keys are in the database?

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

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Identify the aspect of a well-structured database that is incorrect.

Reports produced using the data dictionary could include all of the following except a list of

________ in a well-structured relational database.

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,"Item #" is best described as

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Which of the statements below is incorrect?

The ________ occurs when more than one occurrence of a specific data item in a database exists.

What is the difference in logical view and physical view?

What are the basic requirements when logically designing a relational database model?

All of the following are benefits of the database approach except

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

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

Exam 4: Relational Databases

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.

Using the database depicted below,how many primary keys are in the database?

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

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Identify the aspect of a well-structured database that is incorrect.

Reports produced using the data dictionary could include all of the following except a list of

________ in a well-structured relational database.

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,"Item #" is best described as

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Which of the statements below is incorrect?

The ________ occurs when more than one occurrence of a specific data item in a database exists.

What is the difference in logical view and physical view?

What are the basic requirements when logically designing a relational database model?

All of the following are benefits of the database approach except

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

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