Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 21. Working with the System Catalog
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C,"Answers to Quizzes and Exercises," for answers.
Quiz
1:
The system catalog is also known as what in some implementations ?
2:
Can a regular user update the system catalog?
3:
What Sybase system table is used to retrieve information about views that exist in the database?
4:
Who owns the system catalog?
5:
What is the difference between the Oracle system objects ALL_TABLES and DBA_TABLES?
6:
Who makes modifications to the system tables?
Exercises
1:
In Hour 19, you looked at the MySQL system tables in the default mysql database. Review these tables.
2:
At the mysql> prompt, type the following to show common commands:
HELP;
3:
Type the following command to see the current status of MySQL:
STATUS;
What is the current database?
4:
At the mysql> prompt, change your database from mysql to learnsql, and then check the status again.