APPENDIX AAnswers

Answers For Lesson 1

Quiz

1. SQL determines what should be done, not how it should be done. The database must implement the SQL request. This feature is a big plus in cross-platform, cross-language development.

2. Apply Dr. Codd’s 12 (actually, 13) rules.

3. SQL enables you to select, insert, modify, and delete the information in a database; perform system security functions and set user permissions on tables and databases; handle online transaction processing within an application; create stored procedures and triggers to reduce application coding; and transfer data between different databases.

4. The Relational model is what Dr Codd’s RDBMS is based upon and breaks data up into discrete sets.

Answers For Lesson 2

Quiz

1. ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth 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.