What does SELECT DISTINCT * FROM table_name; do in MySQL?
Can you use DISTINCT * with WHERE clause? Provide an example.
What is the difference between SELECT * FROM table_name; and SELECT DISTINCT * FROM table_name;?
How does MySQL handle NULL values when using SELECT DISTINCT *?
Is it more efficient to use DISTINCT * or to use GROUP BY on all columns? Why?
What are the limitations of using SELECT DISTINCT * in terms of performance?
How does SELECT DISTINCT * work internally in MySQL?
Can you optimize a query that uses SELECT DISTINCT * on a table with a high number of duplicate records?
Explain a scenario where using SELECT DISTINCT * might not be the best choice and provide an alternative.
In a MySQL certification exam, you might encounter a question like: "Given a table with many duplicate rows, describe how you could use indexing to make a SELECT DISTINCT * query more efficient. Provide an SQL example."