CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 27
number of units on hand is greater than the average of units on hand for all parts .
4 . ( TCO 7 ) Using the BETWEEN operator , write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998 .
5 . ( TCO 7 ) Write a query that will list the part number and part description for all parts in the PART table .
( Points : 15 ) ============================================= CIS 336 Final Exam 3 ( Devry ) FOR MORE CLASSES VISIT www . cis336study . com
1 . ( TCO 2 ) Explain what physical independence means . ( Points : 15 )
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 ?
number of units on hand is greater than the average of units on hand for all parts .
4 . ( TCO 7 ) Using the BETWEEN operator , write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998 .
5 . ( TCO 7 ) Write a query that will list the part number and part description for all parts in the PART table .
( Points : 15 ) ============================================= CIS 336 Final Exam 3 ( Devry ) FOR MORE CLASSES VISIT www . cis336study . com
1 . ( TCO 2 ) Explain what physical independence means . ( Points : 15 )
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 ?