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."
- You want to back up the transaction log of your production database every hour during peak business hours (8:00 a.m. to 6:00 p.m.) and every three hours during non-peak hours (6:00 p.m. to 8:00 a.m.). What is the most efficient method for automating these tasks?
- The customer account manager has asked to be notified whenever a customer's credit limit is changed (increased or decreased). In addition, she wants the name of the customer representative who updated the customer's account, as well as any remarks about why the change was made. How would you accomplish this task?
- Your new database application is now in production, and you want to execute tests to review its performance. Specifically, you want to know whether the lock wait time is over 20 seconds. How can you be notified automatically when this event occurs?