What is true about the contents of the INFORMATION_SCHEMATA table?
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
Explanation:
Reference:
http://www.mssqltips.com/sqlservertutorial/196/informationschematables/ (overview)
C.
B.
https://dev.mysql.com/doc/refman/5.6/en/schemata-table.html
C
B
From my Database:
It shows Tables, Triggers, and Views.
… character set, and collation but nothing about name.
select table_name from INFORMATION_SCHEMA.tables
where table_schema = ‘information_schema’;
table_name
‘CHARACTER_SETS’
‘COLLATIONS’
‘COLLATION_CHARACTER_SET_APPLICABILITY’
‘COLUMNS’
‘COLUMN_PRIVILEGES’
‘ENGINES’
‘EVENTS’
‘FILES’
‘GLOBAL_STATUS’
‘GLOBAL_VARIABLES’
‘KEY_COLUMN_USAGE’
‘OPTIMIZER_TRACE’
‘PARAMETERS’
‘PARTITIONS’
‘PLUGINS’
‘PROCESSLIST’
‘PROFILING’
‘REFERENTIAL_CONSTRAINTS’
‘ROUTINES’
‘SCHEMATA’
‘SCHEMA_PRIVILEGES’
‘SESSION_STATUS’
‘SESSION_VARIABLES’
‘STATISTICS’
‘TABLES’
‘TABLESPACES’
‘TABLE_CONSTRAINTS’
‘TABLE_PRIVILEGES’
‘TRIGGERS’
‘USER_PRIVILEGES’
‘VIEWS’
‘INNODB_LOCKS’
‘INNODB_TRX’
‘INNODB_SYS_DATAFILES’
‘INNODB_LOCK_WAITS’
‘INNODB_SYS_TABLESTATS’
‘INNODB_CMP’
‘INNODB_METRICS’
‘INNODB_CMP_RESET’
‘INNODB_CMP_PER_INDEX’
‘INNODB_CMPMEM_RESET’
‘INNODB_FT_DELETED’
‘INNODB_BUFFER_PAGE_LRU’
‘INNODB_SYS_FOREIGN’
‘INNODB_SYS_COLUMNS’
‘INNODB_SYS_INDEXES’
‘INNODB_FT_DEFAULT_STOPWORD’
‘INNODB_SYS_FIELDS’
‘INNODB_CMP_PER_INDEX_RESET’
‘INNODB_BUFFER_PAGE’
‘INNODB_CMPMEM’
‘INNODB_FT_INDEX_TABLE’
‘INNODB_FT_BEING_DELETED’
‘INNODB_SYS_TABLESPACES’
‘INNODB_FT_INDEX_CACHE’
‘INNODB_SYS_FOREIGN_COLS’
‘INNODB_SYS_TABLES’
‘INNODB_BUFFER_POOL_STATS’
‘INNODB_FT_CONFIG’
C
Ops I read over the scheMATA part of the question.
D
C
http://dev.mysql.com/doc/refman/5.7/en/schemata-table.html
C