Review

[Previous] [Next]

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

1. You want to create a DTS package using a basic query. What tool is most appropriate?

Answer

2. You want to be certain that a DTS package is secure so that no one can copy it or view sensitive information. What can you do to secure this DTS package?

Answer

3. You plan to upgrade the hardware that currently runs SQL Server 7. The new hardware will be faster. Which tool would you select to transfer the database and all of its objects to the new hardware?

Answer

4. You are required to recommend a solution for an organization that has an existing Oracle database and a new SQL Server database. The applications using the SQL Server database need access to a table on the Oracle server. Which of the following would provide the best solution?

• A. Set up SQL Server replication to replicate the table from Oracle to SQL Server.
• B. Create a DTS package and schedule it to transfer the contents of the table from Oracle to SQL Server once every hour.
• C. Add the Oracle database as a linked server on SQL Server.
• D. Install the Oracle and SQL Server client software on every user's computer and access the Oracle table directly from the application.

Answer