Practice Questions

Which JOIN returns only matching records from both tables?

A. LEFT JOIN B. RIGHT JOIN C. INNER JOIN D. FULL JOIN

What does the EXPLAIN statement do in MySQL?

A. Executes query faster B. Shows query execution plan C. Creates index D. Validates syntax

Which index type is best for full-text search?

A. B-Tree B. Hash C. FULLTEXT D. Bitmap

What is the default storage engine in MySQL 8.0?

A. MyISAM B. InnoDB C. Memory D. Archive

Which statement ensures all operations in a transaction are undone?

A. COMMIT B. SAVEPOINT C. ROLLBACK D. RELEASE

Which function extracts data from a JSON column?

A. JSON_PARSE() B. JSON_EXTRACT() C. JSON_READ() D. JSON_VALUE()