Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

The system catalog is also known as what in some implementations ?

The system catalog is also known as the data dictionary .

Can a regular user update the system catalog?

Not directly; however, when a user creates an object such as a table, the system catalog is automatically updated.

What Sybase system table is used to retrieve information about views that exist in the database?

SYSVIEWS

Who owns the system catalog?

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.

What is the difference between the Oracle system objects ALL_TABLES and DBA_TABLES?

ALL_TABLES shows all tables that are accessible by a particular user, whereas DBA_TABLES shows all tables that exist in the database.

Who makes modifications to the system tables?

The database server itself.

In Hour 19, you looked at the MySQL system tables in the default mysql database. Review these tables.

DESCRIBE COLUMNS_PRIV; DESCRIBE DB; DESCRIBE FUNC; DESCRIBE HOST; DESCRIBE TABLES_PRIV; DESCRIBE USER;

At the mysql> prompt, type the following to show common commands:

HELP;

Type the following command to see the current status of MySQL:

STATUS;

What is the current database?

mysql

At the mysql> prompt, change your database from mysql to learnsql, and then check the status again.

USE LEARNSQL; STATUS;