Sams Teach Yourself SQL in 21 Days, Fourth Edition

Q&A

Q1:	I have actually used roles and triggers before. Were they not a part of the standard before?
A1:	Some implementations have used roles and triggers; however, they have not actually been implemented into the ANSI SQL standard until now.
Q2:	What value does the CREATE TYPE statement add to SQL3?
A2:	The CREATE TYPE statement offers the availability of object-relational technology. You can define and use your own UDTs. These UDTs allow you more flexibility when defining the structure of your database, and when organizing the data.
Q3:	I understand about views being difficult to manage; would you consider the use of roles difficult to manage?
A3:	The management of roles could become as difficult as views. The number of roles used, the combinations ...