CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 28

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".
8. (TCO 8) Write a query that will display the customer
number, first name, and last name for every customer with a
balance greater than $50. Display the first and last name as a
single column and provide an alias for the column.
9. (TCO 7) Write a query that will list the customer number,
last name, and first name for every customer represented by
sales rep 03 or sales rep 12.
10. (TCO 7) Write a query that will list the customer first
and last name and the sales rep commission rate using JOIN
ON.
-----------------------------------------------------------------------------CIS 336 Final Exam 4 (Devry)