Question 1

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 2

List the four DBMS "languages" and describe who uses each and for what purpose.

Accepted Answer

DDL is the data definition language used

Question 3

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 4

Which of the following elements link rows in one table to rows in another table?

Accepted Answer

A) primary keys 
B) foreign keys 
C) semantic keys 
D) link keys 
A) primary keys 
B) foreign keys 
C) semantic keys 
D) link keys

Question 5

What acts as an interface between the database and the various application programs?

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 6

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 7

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 notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth,Bob Farnsworth,and Snake Farnsworth all seem to be the same person.You explain to Kai that every customer must be identified by a unique customer number in the AIS.You are referring to the

Accepted Answer

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

Question 8

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 9

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 10

A data warehouse

Accepted Answer

A) is primarily used for analysis rather than transaction processing. 
B) stores transaction processing records in hard copy. 
C) replaces traditional transaction processing databases. 
D) increases the speed of transaction processing. 
A) is primarily used for analysis rather than transaction processing. 
B) stores transaction processing records in hard copy. 
C) replaces traditional transaction processing databases. 
D) increases the speed of transaction processing.

Question 11

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 12

The update anomaly in non-normalized 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.

Question 13

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 14

Explain the relational database data model.

Accepted Answer

A data model is an abstract representati

Question 15

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Accepted Answer

A) purge 
B) erase 
C) delete 
D) integrity 
A) purge 
B) erase 
C) delete 
D) integrity

Question 16

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 17

Identify the statement below that is false with regards to basic requirements of a relational database model.

Accepted Answer

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

Question 18

Shahnaz Vijaya is a new graduate who has been hired by a family-owned furniture manufacturing company in the south.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

Accepted Answer

A) independence. 
B) integration. 
C) redundancy. 
D) qualifications. 
A) independence. 
B) integration. 
C) redundancy. 
D) qualifications.

Question 19

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 20

A set of individual user views of the database is called the

Accepted Answer

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

The physical view of a database system refers to

List the four DBMS "languages" and describe who uses each and for what purpose.

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

Which of the following elements link rows in one table to rows in another table?

What acts as an interface between the database and the various application programs?

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

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

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

A data warehouse

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

The update anomaly in non-normalized database tables

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

Explain the relational database data model.

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

The data dictionary usually is maintained

Identify the statement below that is false with regards to basic requirements of a relational database model.

File-oriented approaches create problems for organizations because of

A set of individual user views of the database is called 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

The physical view of a database system refers to

List the four DBMS "languages" and describe who uses each and for what purpose.

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

Which of the following elements link rows in one table to rows in another table?

What acts as an interface between the database and the various application programs?

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

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

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

A data warehouse

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

The update anomaly in non-normalized database tables

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

Explain the relational database data model.

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

The data dictionary usually is maintained

Identify the statement below that is false with regards to basic requirements of a relational database model.

File-oriented approaches create problems for organizations because of

A set of individual user views of the database is called 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