Question 1

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

Accepted Answer

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

Question 2

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 3

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 4

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information

Question 5

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 6

Seacrest Bedding is changing from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for a sales transaction.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

Accepted Answer

Customer table;ID (primary key),name,str

Question 7

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

Accepted Answer

A) foreign key. 
B) primary key. 
C) relational key. 
D) linkage key. 
A) foreign key. 
B) primary key. 
C) relational key. 
D) linkage key.

Question 8

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

Question 9

The physical view of a database system refers to

Accepted Answer

A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program. 
A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program.

Question 10

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Accepted Answer

A schema describes the logical structure

Question 11

-Using the database depicted above,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 12

The logical view of a database system refers to

Accepted Answer

A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program. 
A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program.

Question 13

-Using the database depicted above,"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 14

In a well-structured relational database,

Accepted Answer

A) foreign keys cannot be null. 
B) there must be at least two foreign keys. 
C) every column in a row must be single valued. 
D) one table must be related to all other tables. 
A) foreign keys cannot be null. 
B) there must be at least two foreign keys. 
C) every column in a row must be single valued. 
D) one table must be related to all other tables.

Question 15

Identify one potential outcome of the insert 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 16

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A) Customer Order 
B) Customer 
C) Sales 
D) Sales Order 
A) Customer Order 
B) Customer 
C) Sales 
D) Sales Order

Question 17

A ________ is an abstract representation of a database's contents.

Accepted Answer

A) schema 
B) logical data model 
C) physical view 
D) data dictionary 
A) schema 
B) logical data model 
C) physical view 
D) data dictionary

Question 18

In a relational database,requiring that every record in a table have a unique identifier is 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 19

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 20

When the human resources manager wants to build a data dictionary,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

Exam 4: Relational Databases

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

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

The data dictionary usually is maintained

Describe the information that is contained in the data dictionary.

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

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

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?

The physical view of a database system refers to

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

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

The logical view of a database system refers to

-Using the database depicted above,"Item #" is best described as

In a well-structured relational database,

Identify one potential outcome of the insert anomaly.

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

A ________ is an abstract representation of a database's contents.

In a relational database,requiring that every record in a table have a unique identifier is called the

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?

When the human resources manager wants to build a data dictionary,the manager would use which language?

Conceptual Foundations of Accounting Information Systems

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