MySQL Development quiz advanced level

Test description

This advanced test evaluates your knowledge of MySQL and its development up to version 8.0. It also checks advanced features offered by the DMBS.
The test covers some theoretical knowledge of new functionalities in MySQL, and practical code snippets.
Topics: indexes, regular expressions, correct table filtering, window functions and transactions.

Sample questions

1
What is true about full table scans?

They do not occur when you have indexes.

They can be avoided using FORCE INDEX.

They can happen if the table is small.

They are always slower than index scan.

Results between 1-5 / 20	60.87%
Results between 6-10 / 20	32.17%
Results between 11-15 / 20	4.35%
Results between 16-20 / 20	2.61%
Average results 5 / 20

MySQL Development quiz advanced level

Test description

Sample questions

Related tests

PostgreSQL quiz medium level

PostgreSQL DBA quiz medium level

SQL Server DBA quiz medium level

SQL quiz advanced level

SQL Development quiz medium level