+
CIS336 Final Exam 2

CIS336 Final Exam 2

Rating:
Rating
(0)
Author: Christine Farr
Description:

http://www.devrygenius.com/product/cis336-final-exam-2

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 


(more)
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.

Tutorial