CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 4

Question 1 . 1 . ( TCO 7 ) Write a join query that for every order placed on September 5 , 1998 , ( use ' 05-SEP-1998 ') will list the order number and order date along with the customer number , last name , and first name of the customer who placed the order .

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

Question 3 . 3 . ( TCO 8 ) Write a subquery that will list the part number , part description , and units on hand of all parts where the number of units on hand is greater than the average of units on hand for all parts .

Question 4 . 4 . ( TCO 7 ) Using the orders table , write a query that will list the order number , date , and customer number for every order that was made prior to September 5 , 1998 . Format the date in your result set to be in the same format as above ( i . e ., September 5 , 1998 ).

Question 5 . 5 . ( TCO 7 ) Using a NATURAL JOIN method , write a query that will list the customer number , last name , and first name for every customer who currently has an order on file for an iron .

--------------------------------------------------------------------------------------- CIS 336 Final Exam 1 ( Devry ) FOR MORE CLASSES VISIT www . cis336study . com

1 . ( TCO 1 ) Most DBMS are referred to as _____________ database management systems . ( Points : 4 )