CIS 336 FINAL EXAM 2 DEVRY

CIS 336 FINAL EXAM 2 DEVRY

CIS 336 FINAL EXAM 2 DEVRY


To purchase this visit here:
http://www.nerdypupil.com/product/cis-336-final-exam-2-devry/
Contact us at:
nerdypupil@gmail.com

CIS 336 FINAL EXAM 2 DEVRY

CIS 336 Final Exam 2 (Devry)

1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4)

elemental
linked
hierarchical
relational

2. (TCO 1) A relational DBMS provides protection of the _______________________ through security, control, and recovery facilities. (Points : 4)

user
network
system
database

3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)

referential
restrictive
secondary
redundant

4. (TCO 2) A field that consists of integer values is a _________ type field. (Points : 4)

Date/Time
Yes/No
Memo
Numeric

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)

Unique values
Nonintelligent
Preferably single-attribute
Security complaint

6. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be in_____________. (Points : 4)

1NF.
2NF.
3NF.
4NF.
BCNF.

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)

1NF.
2NF.
3NF.
4NF.
BCNF.

8. (TCO 4) In Oracle, the DEFAULT constraint is used to ____________________. (Points : 4)

define which column is the default primary key if one is not explicitly named
define which column is the default foreign key if on is not explicitly named
assign a value to an attribute when a new row is added and a value is not defined
validate data when a value is added to an attribute

Page 2 – Multiple Choice

1. (TCO 4) Which of...

Similar Essays