CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c

CIS 336 Final Exam (Feb 2016)
FOR MORE CLASSES VISIT
www.cis336study.com
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?
Question 2. 2. (TCO 1) A relational DBMS provides protection of
the _____ through security, control, and recovery facilities.
Question 3. 3. (TCO 2) A relationship is an association between
_____
Question 4. 4. (TCO 2) A _____ key is a key that is composed of
more than one attribute.
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 _____
Question 6. 6. (TCO 3) The extended entity relationship model
(EERM) is sometimes referred to as the _____
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 _____
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)