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.

11 years ago

Report issue

Answer

NOT RATED

Purchase the answer to view it

mis_582_final_exam_2.docx