CIS 336 Entire Course
For more classes visit
www.snaptutorial.com
CIS 336 Entire Course: Devry University
******************************************************************************************
CIS 336: All iLabs Week 1 to Week 7: Devry University
For more classes visit
www.snaptutorial.com
CIS 336: All iLabs Week 1 to Week 7: Devry Universitye.
******************************************************************************************
CIS 336 Final Exam 1
For more classes visit
www.snaptutorial.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 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
******************************************************************************************
CIS 336 Final Exam 3
For more classes visit
www.snaptutorial.com
1. (TCO 2) Explain what physical independence means. (Points : 15)
2. (TCO 8) Sally wants to query the EMP table and determine how many of the employees live in each of the cities the company has factories in. She writes the following query but it does not work. What is wrong with the way the query is constructed?
3. (TCO 3) Explain in what two specific cases presented in the text composite primary...