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 will happen if a unique index is created on a nonunique field?
2:Are the following statements true or false?

  1. Indexes take up space in the database and therefore must be factored in the planning of the database size.

  2. If you have the disk space and you really want to get your queries smoking, the more indexes the better.

  3. An index is implicitly created when a primary key is specified for a table.

3:Is the following CREATE statement correct? 
 SQL> create ...

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.

Start your free trial