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 between the Oracle system objects ALL_TABLES and DBA_TABLES? |
| A5: | ALL_TABLES shows all tables that are accessible by a particular user, while DBA_TABLES shows all tables that exist in the database. |
| 6: | Who makes modifications to the system tables? |
| A6: | The database server itself. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.