CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career 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 )