Cis 336 Final Exam Devry - Complete Answer

CIS 336 Final Exam DeVry - Complete Answer

IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download

http://hwnerd.com/CIS-336-Final-Exam-DeVry-43099222.htm?categoryId=-1

If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com

Page 1 – Multiple Choice

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

elemental

linked

hierarchical

relational

2.

2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4)

information

processing

applications

programming

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) In a “one-to-many” relationship, which constraint is usually added to the “many” table?

(Points : 4)

UNIQUE

PRIMARY KEY

FOREIGN KEY

NOT NULL

5. (TCO 3) A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. (Points : 4)

surrogate primary keys

time-variant data

design trap

fan trap

6. (TCO 3) All of the following are true about a prime attribute except_____________. (Points : 4)

it is a key attribute

it is at least part of a key

it is not a key attribute

it may be part of a composite key

7. (TCO 3) The conflicts between design efficiency, information requirements, and processing speed are often resolved through_____________. (Points : 4)

conversion from 1NF to 2NF

conversion from 2NF to 3NF

compromises that include denormalization

conversion from 3NF to 4NF

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)

table

column

database

row

Page 2 – Multiple Choice

1. (TCO 4) In Oracle, the CONSTRAINT...