Workshop

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour  18.  Managing Database Users


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:

What command is used to establish a session?

2:

Which option must be used to drop a schema that still contains database objects?

3:

What statement is used to remove a database privilege?

4:

What command creates a grouping or collection of tables, views, and privileges?

Exercises

1:

Describe or list the steps that allow a new employee database access.

2:

At the mysql> prompt, type the following to show the status of your current MySQL session:

  status;  

If you are using Microsoft Windows, the user is probably ODBC@localhost. ODBC stands for Open Database Connectivity. ODBC is a standard protocol that is used to connect to a relational database. ODBC is often used to communicate between two or more differing relational database (SQL) implementations .


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net