Day 1

Quiz

1: What makes SQL a nonprocedural language?
A1: 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: How can you tell whether a database is truly relational?
A2: Apply Dr. Codd's 12 (actually 13) rules.
3: What can you do with SQL?
A3: 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: Name the process that separates ...

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.