CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 27

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
especially useful in comparing certain attributes? (Points :
15)
5. (TCO 6) Oracle will not allow the changing of a column's
data type unless the column is empty, and even then it may
still be prohibited. Discuss why? (Points : 15)
6. (TCO 7) Write a join query using NATURAL JOIN that
for every order in the ORDERS table will list the order
number and order date along with the cusnumber, last
name, and first name of the customer who placed the order.
7. (TCO 8) Write a query that will list the part number, part
description, and on-hand value (units on hand * unit price)
for each part in item class AP. Give the expression an alias
of "On Hand Value".