Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

CIS 336 Quiz 1.doc

VIEWS: 1 PAGES: 2

(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

More Info
									                        CIS 336 Quiz 1

           Click Here to Purchase the Tutorial
  http://www.devrycart.com/CIS-336/product-12035-
                       CIS-336-Quiz-1

        For more course tutorials visit
                www.devrycart.com
        Tutorial Purchased: 3 Times, Rating: B+



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

								
To top