Workshop

The quiz questions are designed to strengthen the knowledge you gain each hour. The exercises help you build on that knowledge by providing you with the opportunity to apply it to real problems.

Quiz

1: Which SQL statement is used to add a new table to a database?
2: What criteria must a column or combination of columns satisfy to be able to serve as a primary key?
3: How do CHAR and VARCHAR fields differ?

Exercises

1: Install a relational database for your own use. If you own Microsoft Office Professional, you can use Access. If you don’t, check out MySQL (http://www.mysql.net).

Quiz Answers

A1: You can add new records to a table using the INSERT statement.
A2: In order for a column or group of columns to serve as the primary key ...

Get Sams Teach Yourself CGI in 24 Hours, Second 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.