CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 26

during the period of September 3rd thru September 5th of
1998.
5. (TCO 7) Write a query that will list the part number
and part description for all parts in the PART table.
(Points : 15)
===========================================
CIS 336 Final Exam 3 (Devry)
FOR MORE CLASSES VISIT
www.cis336study.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 keys are particularly useful.
(Points : 15)
4. (TCO 7) How are comparisons done on character string
data in a queries WHERE clause, and why would this be