Question 1

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

Accepted Answer

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

Question 2

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 3

The delete anomaly

Accepted Answer

A)  may result in unintentional loss of important data. 
B)  is usually easily detected by users. 
C)  restricts the addition of new records. 
D)  prevents users from deleting outdated data from records or tables. 
A)  may result in unintentional loss of important data. 
B)  is usually easily detected by users. 
C)  restricts the addition of new records. 
D)  prevents users from deleting outdated data from records or tables.

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

The 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.is named the

Accepted Answer

A)  report writer. 
B)  report generator. 
C)  report creator. 
D)  report printer. 
A)  report writer. 
B)  report generator. 
C)  report creator. 
D)  report printer.

Question 6

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the

Accepted Answer

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

Question 7

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 8

Chelsana Washington is a medical equipment sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She,and the other sales reps,have access to view customer and product information.They have access that allows them to enter and cancel customer orders.The permissions for Chelsana define a(an)________ in the company's database management system.

Accepted Answer

A)  conceptual-level schema 
B)  subschema 
C)  data dictionary 
D)  physical view 
A)  conceptual-level schema 
B)  subschema 
C)  data dictionary 
D)  physical view

Question 9

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 10

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

Accepted Answer

Every row in every table must have a uni

Question 11

The ________ contains information about the structure of the database.

Accepted Answer

A)  data definition language 
B)  data dictionary 
C)  data warehouse 
D)  database management system 
A)  data definition language 
B)  data dictionary 
C)  data warehouse 
D)  database management system

Question 12

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 13

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 14

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 15

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 non-key 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 non-key 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 16

The person responsible for the database is the

Accepted Answer

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

Question 17

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A)  conceptual-level schema. 
B)  subschema. 
C)  internal-level schema. 
D)  external-level schema. 
A)  conceptual-level schema. 
B)  subschema. 
C)  internal-level schema. 
D)  external-level schema.

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

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 20

The update anomaly in file-based systems or unnormalized database tables

Accepted Answer

A)  occurs because of data redundancy. 
B)  restricts addition of new fields or attributes. 
C)  results in records that cannot be updated. 
D)  is usually easily detected by users. 
A)  occurs because of data redundancy. 
B)  restricts addition of new fields or attributes. 
C)  results in records that cannot be updated. 
D)  is usually easily detected by users.

Exam 4: Relational Databases

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

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

The delete anomaly

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

The 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.is named the

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the

The data dictionary usually is maintained

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

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

The ________ contains information about the structure of the database.

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?

The physical view of a database system refers to

Which would not generally be considered a data dictionary output report?

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

The person responsible for the database is the

A low-level view of the database that describes how the data are actually stored and accessed is the

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

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

The update anomaly in file-based systems or unnormalized database tables

Accounting Information Systems: an Overview

Overview of Transaction Processing and Erp Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Information Systems Controls for System Reliability Part 1: Information Security

Information Systems Controls for Systems Reliability Part 2: Confidentiality and Privacy

Information Systems Controls for Systems Reliability Part 3: Processing Integrity and Availability

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

The Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters