Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Quiz

1:What are the three basic components of a trigger?
2:What are the three events that can cause a trigger to fire?
3:What is the advantage of implementing role security?
4:Name four uses for a trigger.
5:For what does the abbreviation UDT stand?

Exercises

1:Because MySQL does not support roles, use the Oracle syntax as shown in this chapter for this exercise. Write out the code to create a role and assign the SELECT privilege to that role. Then grant the role ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.