Docstoc

CIS 336 Quiz 1.doc

Document Sample
CIS 336 Quiz 1.doc Powered By Docstoc
					(TCO 3) Normalization works through a series of stages called normal
forms. Typically _________ stages must be completed before a table can
be considered normalized.

(TCO 3) The conflicts between design efficiency, information
requirements, and processing speed are often resolved through

(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
(TCO 9) The SQL command that lets you insert data into a table, one
row at a time, is _____________.

(TCO 4) Which command is used to restore the table's contents to their
default values?

(TCO 4) Which of the following SQL commands would alter the table
DEVRY and add a foreign key that references the CITY table?

(TCO 4) The SQL command that lets you save your work to disk, is
___________

(TCO 9) If the INSERT INTO command is used to insert data values
that violate an existing constraint in a table, which of the following will
happen?
(TCO 3) Explain under what circumstances a partial dependency can
exist in a database.

				
DOCUMENT INFO
Description: CIS 336 Quiz 1 CIS 336 Quiz 3 CIS 336 Quiz 2 CIS 336 Final Exam 4 CIS 336 Final Exam 4 Sets of Answers CIS 336 Final Exam 1 CIS 336 Final Exam 2 CIS 336 Final Exam 3 CIS 336 Entire Course: Devry University CIS 336: All iLabs Week 1 to Week 7: Devry University CIS 336 Week 1 iLab 1 Devry University CIS 336 Week 2 iLab 2 Devry University CIS 336 Week 3 iLab 3 Devry University CIS 336 Week 4 iLab 4 Devry University CIS 336 Week 5 iLab 5 DevryUniversity CIS 336 Week 6 iLab 6 Devry University CIS 336 Week 7 iLab 7 Devry University CIS 336 Quiz 4 CIS 336 Quiz 5 CIS 336 Week 3 Group Project Task 1 Data Model CIS 336 Week 4 Group Project Task 2 CIS 336 Week 5 Group Project Task 3 CIS 336 Week 6 Group Project Task 4 CIS 336 Week 7 Group Project Task 5
smartworkers2013 smartworkers2013
About