Question 1

A relational database has been designed where the customer data is not maintained independently of sales invoice data.This design weakness will most likely result in

Accepted Answer

A) an update anomaly. 
B) an insert anomaly. 
C) a delete anomaly. 
D) no anomaly. 
A) an update anomaly. 
B) an insert anomaly. 
C) a delete anomaly. 
D) no anomaly. B

Question 2

A database model that represents all data as stored in two-dimensional tables is the __________ model.

Accepted Answer

A) tuple 
B) relational 
C) hierarchy 
D) object 
A) tuple 
B) relational 
C) hierarchy 
D) object B

Question 3

Which of the statements below is incorrect regarding semantic data modeling?

Accepted Answer

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

Question 4

What is a major advantage of database systems over file-oriented transaction processing systems?

Accepted Answer

Database systems separate logical and ph

Question 5

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information

Question 6

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.Originally,the database was stored on index cards,but recently Dana has been exploring the use of a computerized system.One file in the system will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second file will contain data that link each marmoset to its male and female parents by means of their serial numbers.The primary key in the first file is:

Accepted Answer

A) Name 
B) Registration number 
C) Date of birth 
D) Relationship number 
A) Name 
B) Registration number 
C) Date of birth 
D) Relationship number

Question 7

The part of the DBMS that is used to interrogate the database and present subsets of the database to users is called the

Accepted Answer

A) DDL. 
B) DML. 
C) DQL. 
D) DBA. 
A) DDL. 
B) DML. 
C) DQL. 
D) DBA.

Question 8

Which statement below is false regarding the basic requirements of the relational data model?

Accepted Answer

A) "Every column in a row must be single-valued." 
B) "All nonkey attributes in a table should describe a characteristic about the object identified by the primary key." 
C) "Foreign keys,if not null,must have values that correspond to the value of a primary key in another table." 
D) "Primary keys can be null." 
A) "Every column in a row must be single-valued." 
B) "All nonkey attributes in a table should describe a characteristic about the object identified by the primary key." 
C) "Foreign keys,if not null,must have values that correspond to the value of a primary key in another table." 
D) "Primary keys can be null."

Question 9

Normalization means tables are in the __________ normal form.

Accepted Answer

A) first 
B) second 
C) third 
D) fourth 
A) first 
B) second 
C) third 
D) fourth

Question 10

Each row in a relational database's table is known as a

Accepted Answer

A) data model 
B) relation 
C) schema 
D) tuple 
A) data model 
B) relation 
C) schema 
D) tuple

Question 11

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 12

What do you think will be the main impact of database technology in your career?

Accepted Answer

Answers to this question could cover a w

Question 13

Discuss redundancy as it applies to database design.

Accepted Answer

Redundancy has been called an enemy of r

Question 14

Record layouts,definitions,addresses,and indexes will be stored at the __________ level schema.

Accepted Answer

A) external 
B) conceptual 
C) internal 
D) inner 
A) external 
B) conceptual 
C) internal 
D) inner

Question 15

Accountants may be involved in several aspects of database development.In which area below would an accountant least likely have involvement when developing a database system?

Accepted Answer

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

Question 16

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.Originally,the database was stored on index cards,but recently Dana has been exploring the use of a computerized system.One file in the system will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second file will contain data that link each marmoset to its male and female parents by means of their serial numbers.The primary key in the first file is:

Accepted Answer

A) Name 
B) Birth date 
C) A foreign key in the second file. 
D) The primary key in the second file. 
A) Name 
B) Birth date 
C) A foreign key in the second file. 
D) The primary key in the second file.

Question 17

DBMS uses a language to retrieve,sort,order,and present subsets in a database.This language is known as

Accepted Answer

A) data definition language (DDL). 
B) data manipulation language (DML). 
C) data query language (DQL). 
D) report writer. 
A) data definition language (DDL). 
B) data manipulation language (DML). 
C) data query language (DQL). 
D) report writer.

Question 18

One of the key components of a DBMS is the data dictionary,which contains information about the structure of the database.Which would not generally be considered a data dictionary output report?

Accepted Answer

A) a list of cash balances in the organization's bank accounts 
B) a list of all programs in which a data element is used 
C) a list of all synonyms for the data elements in a particular file 
D) a list of all data elements used by a particular user 
A) a list of cash balances in the organization's bank accounts 
B) a list of all programs in which a data element is used 
C) a list of all synonyms for the data elements in a particular file 
D) a list of all data elements used by a particular user

Question 19

Heidi Holloway is a headhunter with Career Funnel in Boca Raton,Florida.Heidi is proud of the company's motto: We funnel workers into jobs.The foundation of CF's success is its accounting information system.When a client is placed with an employer,a record is created that identifies the employment relationship.CF follows up on placements by surveying both employers and clients about the employment experience and then entering the results into the AIS.Clients are uniquely identified by social security number.In records that contain client survey data,this number is likely to be

Accepted Answer

A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) absent. 
A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) absent.

Question 20

Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic

Accepted Answer

A) by identifying physical location and layouts of various data items. 
B) since they do not have to focus on the physical location and layouts of various data items. 
C) by consolidating all data in one database. 
D) by providing pointers to data items regardless of physical location. 
A) by identifying physical location and layouts of various data items. 
B) since they do not have to focus on the physical location and layouts of various data items. 
C) by consolidating all data in one database. 
D) by providing pointers to data items regardless of physical location.

A relational database has been designed where the customer data is not maintained independently of sales invoice data.This design weakness will most likely result in

A database model that represents all data as stored in two-dimensional tables is the __________ model.

Which of the statements below is incorrect regarding semantic data modeling?

What is a major advantage of database systems over file-oriented transaction processing systems?

Describe the information that is contained in the data dictionary.

The part of the DBMS that is used to interrogate the database and present subsets of the database to users is called the

Which statement below is false regarding the basic requirements of the relational data model?

Normalization means tables are in the __________ normal form.

Each row in a relational database's table is known as a

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

What do you think will be the main impact of database technology in your career?

Discuss redundancy as it applies to database design.

Record layouts,definitions,addresses,and indexes will be stored at the __________ level schema.

Accountants may be involved in several aspects of database development.In which area below would an accountant least likely have involvement when developing a database system?

DBMS uses a language to retrieve,sort,order,and present subsets in a database.This language is known as

One of the key components of a DBMS is the data dictionary,which contains information about the structure of the database.Which would not generally be considered a data dictionary output report?

Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll Cycle

General Ledger and Reporting System

Data Modeling and Database Design

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

A relational database has been designed where the customer data is not maintained independently of sales invoice data.This design weakness will most likely result in

A database model that represents all data as stored in two-dimensional tables is the __________ model.

Which of the statements below is incorrect regarding semantic data modeling?

What is a major advantage of database systems over file-oriented transaction processing systems?

Describe the information that is contained in the data dictionary.

The part of the DBMS that is used to interrogate the database and present subsets of the database to users is called the

Which statement below is false regarding the basic requirements of the relational data model?

Normalization means tables are in the __________ normal form.

Each row in a relational database's table is known as a

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

What do you think will be the main impact of database technology in your career?

Discuss redundancy as it applies to database design.

Record layouts,definitions,addresses,and indexes will be stored at the __________ level schema.

Accountants may be involved in several aspects of database development.In which area below would an accountant least likely have involvement when developing a database system?

DBMS uses a language to retrieve,sort,order,and present subsets in a database.This language is known as

One of the key components of a DBMS is the data dictionary,which contains information about the structure of the database.Which would not generally be considered a data dictionary output report?

Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll Cycle

General Ledger and Reporting System

Data Modeling and Database Design

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