Oracle
1Z0-883 · Question #9
1Z0-883 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Question
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: - The Mysql instance has 400 databases. - Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA,
ENGINE', COUNT (*), SUM (data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = BASE TABLE' GROUP BY TABLE_SCHEMA, `ENGINE' ; Why is this query slow to execute?Options
- ACounting and summarizing all table pages in the InnoDB shared tablespace is time consuming.
- BCollecting information requires various disk-level operations and is time consuming.
- CAggregating details from various storage engine caches for the final output is time consuming.
- DCollecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.