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