Microsoft SQL Server 7.0 System Administration Training Kit

[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. When the season changes, the supplier sets different prices on certain items. How can you use Web Assistant Wizard to republish the price list in order to reflect these changes?
  2. Answer

  3. Does the Web Publishing Wizard create dynamic Web pages for which users can specify variable parameter values and see real-time data?
  4. Answer

  5. You have created a Web Assistant job and scheduled it to update your HTML Web pages weekly. If you receive a new price list from the marketing department and update the database with the new information, do you have to wait until the Web Assistant job executes on schedule, or can you execute the job immediately to update the Web pages?
  6. Answer

  7. The marketing department at your firm has been entering a large amount of free-text information about customers into the customer database for many months. The marketing manager says that her staff is struggling to create reports based on customer profiles. Can you suggest a way to make it possible to create more effective queries of this information?
  8. Answer

  9. When trying to define full-text indexing on a table using SQL Server Enterprise Manager, you find that all of the full-text indexing menus are grayed (not available). What would cause this?
  10. Answer

Категории