Question 1

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Accepted Answer

Update anomaly is an improper database o...

Question 2

Identify one potential outcome of the update anomaly.

Accepted Answer

A)  inconsistent data
B)  inability to add new data
C)  unintentional loss of data
D)  none of the above

Question 3

The logical structure of a database is described by the

Accepted Answer

A)  data dictionary.
B)  schema.
C)  database management system.
D)  context diagram.

Question 4

Which of the following would not be found in a data dictionary entry for a data item?

Accepted Answer

A)  records containing a specific data item
B)  physical location of the data
C)  source of the data item
D)  field type

Question 5

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

Accepted Answer

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

Question 6

What is the difference in logical view and physical view?

Accepted Answer

The logical view is how the user or prog...

Question 7

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.

Question 8

Which is probably the most immediate and significant effect of database technology on accounting?

Accepted Answer

A)  Replacement of the double entry-system.
B)  Change in the nature of financial reporting.
C)  Elimination of traditional records such as journals and ledgers.
D)  Quicker access to and greater use of accounting information in decision-making.

Question 9

Identify one potential outcome of the delete anomaly.

Accepted Answer

A)  inconsistent data
B)  inability to add new data
C)  unintentional loss of data
D)  none of the above

Question 10

A row in a table that contains data about a specific item in a database table is call

Accepted Answer

A)  a data model.
B)  an attribute.
C)  a tuple.
D)  a relational record.

Question 11

Pat Owen is chair of the National Grizzly Society,which maintains a database of all grizzly bears within the United States.One table will store the name,birth date,and other characteristics of all of the grizzly bears that have been registered.Each grizzly bear is uniquely identified by a registration number.A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers.The primary key in the second table is

Accepted Answer

A)  name.
B)  birth date.
C)  the same as the primary key in the first table.
D)  a combination of primary keys in the first table.

Question 12

Describe a major advantage of database systems over file-oriented transaction processing systems.

Accepted Answer

Database systems separate logical and ph...

Question 13

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.

Exam 4: Relational Databases

Identify one potential outcome of the update anomaly.

Correct Answer
verified

The logical structure of a database is described by the

Correct Answer
verified

All of the following are benefits of the database approach except

Correct Answer
verified

A row in a table that contains data about a specific item in a database table is call

Correct Answer
verified

What is the difference in logical view and physical view?

Correct Answer
verified
The logical view is how the user or prog...
View Answer

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Correct Answer
verified
Update anomaly is an improper database o...
View Answer

Identify one potential outcome of the delete anomaly.

Correct Answer
verified

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

Correct Answer
verified

Which is probably the most immediate and significant effect of database technology on accounting?

Correct Answer
verified

Describe a major advantage of database systems over file-oriented transaction processing systems.

Correct Answer
verified
Database systems separate logical and ph...
View Answer

Correct Answer
verified

Which of the following would not be found in a data dictionary entry for a data item?

Correct Answer
verified

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

Correct Answer
verified

Exam 4: Relational Databases

Identify one potential outcome of the update anomaly.

Correct AnswerverifiedShow Answer

The logical structure of a database is described by the

Correct AnswerverifiedShow Answer

All of the following are benefits of the database approach except

Correct AnswerverifiedShow Answer

A row in a table that contains data about a specific item in a database table is call

Correct AnswerverifiedShow Answer

What is the difference in logical view and physical view?

Correct AnswerverifiedThe logical view is how the user or prog...View AnswerShow Answer

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Correct AnswerverifiedUpdate anomaly is an improper database o...View AnswerShow Answer

Identify one potential outcome of the delete anomaly.

Correct AnswerverifiedShow Answer

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

Correct AnswerverifiedShow Answer

Which is probably the most immediate and significant effect of database technology on accounting?

Correct AnswerverifiedShow Answer

Describe a major advantage of database systems over file-oriented transaction processing systems.

Correct AnswerverifiedDatabase systems separate logical and ph...View AnswerShow Answer

Correct AnswerverifiedShow Answer

Which of the following would not be found in a data dictionary entry for a data item?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The logical view is how the user or prog...
View Answer

Correct Answer
verified
Update anomaly is an improper database o...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Database systems separate logical and ph...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified