1z0-908: MySQL 8.0 Database Administrator Queries Practice Questions

During a performance audit, you notice that some queries are not leveraging indexes. What can you do to improve the performance?

• AA. Write more complex queries
• BB. Add indices to the underlying tables
• CC. Reduce the dataset size
• DD. Upgrade hardware

A user's application frequently runs complex JOINs on large tables. What indexing strategy could help optimize these queries?

• AA. No indexing
• BB. Composite indexing
• CC. Full-text indexing
• DD. Spatial indexing

A user reports their queries are running slowly. Which MySQL command can help identify slow-running queries?

• AA. SHOW PROCESSLIST
• BB. EXPLAIN
• CC. DESCRIBE
• DD. SHOW VARIABLES