Cis 336 Week 8 Final Exam

CIS 336 Week 8 Final Exam  


Click Link Below To Buy:
http://hwaid.com/shop/cis-336-week-8-final-exam/


Question 1. 1. (TCO 1) A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions? (Points : 4)  
Question 2. 2. (TCO 1) A relational DBMS provides protection of the _____ through security, control, and recovery facilities. (Points : 4)
      user
      network
      system
      database

 

Question 3. 3. (TCO 2) A relationship is an association between _____ (Points : 4)
      objects.
      entities.
      databases.
      fields.

 

Question 4. 4. (TCO 2) A _____ key is a key that is composed of more than one attribute. (Points : 4)
      primary
      foreign
      composite
      domain

 

Question 5. 5. (TCO 3) The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls. This rationale belongs to _____ (Points : 4)
      unique values.
      nonintelligent.
      preferably single-attribute.
      security complaint.

 

Question 6. 6. (TCO 3) The extended entity relationship model (EERM) is sometimes referred to as the _____ (Points : 4)
      entity relationship model.
      enhanced entity relationship model.
      entity clustering relationship model.
      extended entity relationship doctrine.

 

Question 7. 7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in _____ (Points : 4)  

 

Question 8. 8. (TCO 4) When a constraint is created at the _____ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition. (Points : 4)
      table
      column
      database
      row...