Review

3 4

The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."

1. What are the differences between importing data and exporting data?
2. What tools are available to import data into or export data out of a SQL Server database?
3. What tasks can you perform by using DTS?
4. What data access technology is used by SQL Server to support distributed queries?
5. What two methods can you use in distributed queries to reference heterogeneous OLE DB data sources?
6. What is a linked server?
7. What functionality do cursors support in order to extend result processing?
8. Which three types of cursor implementations does SQL Server support?
9. How do Transact-SQL cursors differ from API server cursors?
10. What features are included in SQL Server to support XML functionalities?
11. What does the FOR XML clause in a SELECT statement enable you to do?
12. What does the OPENXML function enable you to do?