CIS 336 Entire Course
For more course tutorials visit
www.uophelp.com
CIS 336 Entire Course: Devry University
............................................................................
CIS 336 Final Exam 1
For more course tutorials visit
www.uophelp.com
1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points: 4)
Elemental
linked
hierarchical
relational
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 makes 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
..........................................................................
CIS 336 Final Exam 2
For more course tutorials visit
www.uophelp.com
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 _______________________...