The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P136: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Implementing Objects Chapter 14 657 19. In your database system you must frequently convert from EURO currency to USD currency using the exchange rate stored in the ExchangeRates table. What is the best way to achieve this A. Create a function that accepts an @EURAmount parameter and returns the USD value. B. Create a stored procedure that accepts an @EURAmount parameter and selects the USD value using the SELECT statement. C. Create a view that accepts an @EURAmount parameter and selects the USD value. D. Create a stored procedure that accepts an @EURAmount parameter and returns the USD value using the SELECT statement. 20. You wish to add a new column to an existing view object. What are some of the ways to do this Select all that apply A. Use Visual Studio object designer. B. Use the SQL Management Studio object designer. C. Use the ALTER VIEW statement. D. Use the ALTER COLUMN statement. 658 Chapter 14 Implementing Objects Self Test Quick Answer Key 1. B 11. B 2. A 12. C 3. A F 13. A 4. C 14. A 5. D 15. B 6. C 16. A B 7. D 17. B 8. C 18. B 9. D 19. A 10. A 20. B C Index A accent sensitivity 247 ADDRESS parameter 540 Address Windowing Extensions AWE 104 ad hoc distributed queries enabling 339-340 OPENDATASOURCE function basic syntax for 348 querying data with 349 OPENQUERY function basic syntax of 353 querying data with 354 OPENROWSET function basic syntax of 343 for bulk loading data 347 copying data with 346 identifier 343 modifying data with 346 problem with 353 querying data with 344-345 table-valued function 342 XML file 347-348 administrator account 61 Advanced tab 93 AdventureWorks2008 database bulk operations and recovery model 335 querying data from a table in 338-339 schemas 133 AES algorithm 538 alias creating 99-100 managing 99 ALL_ERRORMSGS option 269 ALTER CONTRACT command 528 ALTER DATABASE command 212 446 ALTER DDL Statement 615 ALTER INDEX statement with FILLFACTOR 264 ALTER PARTITION FUNCTION TSQL command 585 ALTER QUEUE
