MIS 582 FINAL EXAM

Report Issue
1. (TCO A) A program whose job is to create, process, and administer databases is called a _____. (Points : 5)

database modeling system
database management system
data business model system
relational model manager
data business management service

 

Question 2.2. (TCO B) Attributes may be _____. (Points : 5)

A. composite identifiers
B. elements
C. multivalued
D. strong or weak
A and C

 

Question 3.3. (TCO C) A relation is in Boyce-Codd normal form if _____. (Points : 5)

there is more than one primary key
every attribute is a candidate key
there is more than one candidate key
every determinant is a primary key
every determinant is a candidate key

 

Question 4.4. (TCO C) A table that meets the definition of a relation is in _____ (Points : 5)

third normal form
fourth normal form
Boyce-Codd normal form
second normal form
first normal form

 

Question 5.5. (TCO D) In a SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified criteria? (Points : 5)

AND
EXISTS
HAVING
IN
WHERE

 

Question 6.6. (TCO E) We have obtained access to the company’s operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code, 567. This is an example of _____. (Points : 5)

dirty data
inconsistent data
nonintegrated data
a “wrong format” problem
a “too much data” problem

 

Question 7.7. (TCO E) One remedy for the inconsistencies caused by concurrent processing is _____. (Points : 5)

lost updates
checkpointing
rollback
resource locking
concurrency

 

Question 8.8. (TCO F) When the correct SQL command is used to delete a table’s structure, what happens to the data in the table? (Points : 5)

A. If the deleted table was a parent table, the data are added to the appropriate rows of the child table.
B. If the deleted table was a child table, the data are added to the appropriate rows of the parent table.
C. The data in the table are also deleted.
D. Nothing, because there were no data in the table, because only an empty table can be deleted.
A and B

 

Question 9.9. (TCO G) Which type of lock still allows other transactions to have read-only access to the locked resource? (Points : 5)

Exclusive lock
Shared lock
Two-phased lock
Explicit lock
Implicit lock

 

Question 10.10. (TCO G) Locks that are placed in the assumption that a conflict will occur are called (Points : 5)

dynamic locks.
explicit locks.
implicit locks.
optimistic locks.
pessimistic locks.