Hour 21, "Working with the System Catalog"
Quiz Answers
| 1: | The system catalog is also known as what in some implementations? |
| A1: | The system catalog is also known as the data dictionary. |
| 2: | Can a regular user update the system catalog? |
| A2: | Not directly; however, when a user creates an object such as a table, the System Catalog is automatically updated. |
| 3: | What Sybase system table is used to retrieve information about views that exist in the database? |
| A3: | SYSVIEWS |
| 4: | Who owns the system catalog? |
| A4: | The owner of the system catalog is often a privileged database user account called SYS or SYSTEM. The system catalog can also be owned by the owner of the database, but is not ordinarily owned by a particular schema in the database. |
| 5: | What is the difference ... |
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.
