CIS 336 Final Exam( Feb 2016) FOR MORE CLASSES VISIT www. 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
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)