Complete the following sentence. The INFORMATION_SCHEMA.SCHEMATA table contains information about ...

The correct answer is C. ... all of the databases on the server, such as name, character set and collation. A schema is a database, so the SCHEMATA table provides information about databases. This information consists of: SCHEMA_NAME (Database) DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME

MySQL Information Schema

Question

Options

A... the table structure for all databases.
B... all of the tables, triggers and views for every database.
C... all of the databases on the server, such as name, character set and collation.
D... every database's structure including tables, triggers, stored routines, views, etc.

How the community answered

(28 responses)

A
7% (2)
B
18% (5)
C
71% (20)
D
4% (1)

Explanation

A schema is a database, so the SCHEMATA table provides information about databases. This information consists of: SCHEMA_NAME (Database) DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME

Topics

#INFORMATION_SCHEMA#SCHEMATA table#database metadata#character set collation

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice