MIS 582 FINAL EXAM

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.

10 years ago

Report issue

MIS 582 FINAL EXAM

NOT RATED

Purchase the answer to view it

mis_582_final_exam.docx