Q&A
| Q1: | Why should I use the views and tables in the data dictionary? |
| A1: | Using the views in the data dictionary is the most accurate way to discover the nature of your database. The tables can tell you what you have access to and what your privileges are. They can also help you monitor various other database events such as user processes and database performance. |
| Q2: | How is the data dictionary created? |
| A2: | The data dictionary is created when the database is initialized. Oracle Corporation provides several scripts to run when creating each database. These scripts create all necessary tables and views for that particular database's data dictionary. |
| Q3: | How is the data dictionary updated? |
| A3: | The data dictionary is updated internally by the RDBMS during ... |
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.
