CIS 336 Week 8 Final Exam

CIS 336 Week 8 Final Exam

Author: Christine Farr


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)

See More
Introduction to Psychology

Analyze this:
Our Intro to Psych Course is only $329.

Sophia college courses cost up to 80% less than traditional courses*. Start a free trial now.