Home > Databases > Quizzes > MariaDB Practice Test
MariaDB Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 16% Most missed: “Is it possible to replace MySQL with MariaDB?”

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License.
The biggest advantage of MariaDB over MySQL is its speed and performance. When it comes to replication and performing queries, MariaDB is faster than MySQL. In addition, MariaDB also easily supports a high concurrent number of connections without much performance degradation.

MariaDB Practice Test
Time left 00:00
25 Questions

1. Which is not a large object data type in MariaDB?
2. Which is not a valid string function in MariaDB?
3. Which command is used to get the list of existing databases in MariaDB?"
4. Which of the following is the correct way to use ROW_COUNT() function?
5. Which statement is used to remove one or more MariaDB roles?"
6. Which of the following query is correct to get the first two names from 'students' table, ordered alphabetically?
7. Which MariaDB operator is used to combine the result sets of two or more SELECT statements without removing duplicate records?
8. Which command is used to drop/delete an existing database in MariaDB?"
9. What is the correct query syntax to delete an index in MariaDB?"
10. What is the name of this (<=>) Operator?
11. The output of the MariaDB Query SELECT 'b' BETWEEN 'a' AND 'c';?
12. Which MariaDB statement is used to display the list of all indexes?"
13. Is it possible to replace MySQL with MariaDB?
14. Which statement is used to rename existing MariaDB accounts?"
15. In MariaDB, what is Maria?
16. Which is the correct MariaDB query to get the list of products that starts with 'Sh'?
17. Which command is used to select an existing database in MariaDB?"
18. What will be the result of the following MariaDB Query?
TO_CHAR('1980-01-11 04:50:39', 'HH24-MI-SS')
16-50-39
19. Who is the lead developer/CTO of MariaDB ____?
20. What is the result of the following MariaDB query?
SELECT QUOTE('Don't!');
'Don\'t!'
21. In MariaDB, the DELETE statement deletes rows from a given table and returns a ____.
22. MariaDB supports the fork of ____.
23. We can create a table by using the ____ command and get the list of all existing tables by using the ____ command in MariaDB."
24. Which MariaDB operator is used to combine the result sets of two or more SELECT statements?
25. Which is the correct MariaDB query to lock an existing user?