CIS 336 Week 8 Final Exam

CIS 336 Week 8 Final Exam

Author: Abraham Nolito


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)
2. (TCO 1) A relational DBMS provides protection of the _____ through security, control, and recovery facilities. (Points : 4)
3. (TCO 2) A relationship is an association between _____ (Points : 4)
4. (TCO 2) A _____ key is a key that is composed of more than one attribute
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)
6. (TCO 3) The extended entity relationship model (EERM) is sometimes referred to as the _____ (Points : 4)
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)
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)
Page 2 - Multiple Choice
1. (TCO 4) When creating a table, which of the following statements is NOT correct? (Points : 4)
2. (TCO 4) Which of the following SQL statements would you use to create a table named DEVRY? (Points : 4)
3. (TCO 5) The Crow's Foot model is more _____-oriented than the Chen model. (Points : 4)
4. (TCO 5) Knowing the _____ number of entity occurrences is very helpful at the application software level. (Points : 4)
5. (TCO 6) The _____ statement can be used to enable or disable a constraint. (Points : 4)
6. (TCO 6) When modifying the data characteristics of a column in Oracle, which of the following is correct? (Points : 4)
7. (TCO 6) Which of the following keywords can be used to change the size, datatype, or default value of an existing column? (Points : 4)
8. (TCO 7) Any type of subquery can be used in the _____ clause of a SELECT statement. (Points : 4)
Page 3

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.