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?