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:In Oracle, how can you find out what tables and views you own?
2:What types of information are stored in the data dictionary?
3:How can you use performance statistics?
4:What are some database objects?

Exercises

Questions 1 and 2 are based upon the MySQL implementation of SQL.

1:MySQL has a database that is part of the server package that contains tables that hold data pertaining to privileges. What is the name of the database?
2:Although you didn't 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.