Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

The correct answer is B. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND D. SELECT * FROM information_schema.COLUMN_STATISTICS. https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

MySQL Architecture

Question

Options

ADESCRIBE manufacturing.parts;
BSELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND
CSHOW INDEXES FROM manufacturing.parts;
DSELECT * FROM information_schema.COLUMN_STATISTICS;
EEXPLAIN SELECT INDEXES FROM manufacturing.parts;

How the community answered

(56 responses)

A
2% (1)
B
89% (50)
C
7% (4)
E
2% (1)

Explanation

https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

Topics

#SHOW INDEXES#information_schema.statistics#index metadata#COLUMN_STATISTICS

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice