CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com

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 atribute.
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)
Question 1. 1. (TCO 4) When creating a table, which of the following
statements is NOT correct?