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...