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 ... |
Get Sams Teach Yourself SQL in 24 Hours, Second 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.
