CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 28
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 ".
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 .
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 ".
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 .