Oracle Database MySQL 5.6 Developer — Question 17

What is true about the contents of the INFORMATION_SCHEMATA table?

Answer options

• A. It contains information about the table structure for all databases.
• B. It contains information about all the tables, triggers, and views for all databases.
• C. It contains information such as name, character set, and collation for all the databases on the server.
• D. It contains information including tables, trigger, stored routines, and views for all databases

Correct answer: C

Explanation

Option C is correct because the INFORMATION_SCHEMA table indeed contains details such as the name, character set, and collation of all databases on the server. The other options are incorrect as they refer to broader categories of information that are not included in the INFORMATION_SCHEMA table.