Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Appendix C. Answers to Quizzes and Exercises
Hour 18, "Managing Database Users"
Quiz Answers
1:
What command is used to establish a session?
A1:
The CONNECT TO statement.
2:
Which option must be used to drop a schema that still contains database objects?
A2:
The CASCADE option allows the schema to be dropped if there are still objects under that schema.
3:
What statement is used to remove a database privilege?
A3:
The REVOKE statement is used to remove database privileges.
4:
What command creates a grouping or collection of tables, views, and privileges?
A4:
The CREATE SCHEMA statement.
Exercise Answers
1:
Describe or list the steps that allow a new employee database access.
A1:
The immediate supervisor should instigate the request process by completing a user ID request form, which contains all the information necessary to add the user to the database. The form should then be forwarded to the security officer. The user request is then routed to either the database administrator or the individual designated to assist the database administrator with security, so that the user can be added to the database. This is a general process that should be followed and modified accordingly for each company.
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 .