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