MariaDB is one of the most popular open-source relational databases, created by MySQL's original founder, Michael "Monty" Widenius. It is known for high performance, stability, and strong MySQL compatibility. Major platforms like Wikipedia and WordPress.com rely on it.
Below are 5 multiple-choice questions and 3 SQL practice problems to help you quickly master MariaDB essentials.
Part 1: MariaDB Fun Quiz Questions
1. What animal is the MariaDB mascot?
A. A sea lion
B. A dolphin
C. An elephant
D. A penguin
Answer: A. A sea lion
MariaDB chose the sea lion as its mascot after founder Monty encountered a playful sea lion off the coast of Cape Town, South Africa. The sea lion continues the open-source tradition of animal symbols, and MariaDB itself is named after Monty's younger daughter, Maria.
2. What is the latest LTS release of MariaDB Server?
A. 12.3
B. 12.2
C. 10.11
D. 11.8
Answer: D. 11.8
MariaDB 11.8 is the annual Long-Term Support (LTS) release for 2025, officially launched in June 2025. It is the first LTS version with native MariaDB Vector support, providing a stable foundation for AI workloads.
3. What do MariaDB and MySQL have in common?
A. Nothing, they are unrelated projects
B. They share a release schedule
C. The same original creator
D. They are owned by the same company
Answer: C. The same original creator
Both MariaDB and MySQL were created by Michael "Monty" Widenius. After Oracle acquired MySQL in 2009, Monty created MariaDB as a fork of MySQL out of concern for open-source freedom. Many original MySQL developers joined the new project.
4. MariaDB now has native vector search for AI workloads. Which of these is a real MariaDB data type?
A. VECTOR
B. NEURAL
C. EMBEDDING
D. TENSOR
Answer: A. VECTOR
MariaDB introduced native vector search starting with version 11.7 and defined the VECTOR data type. It supports efficient nearest-neighbor search and cosine similarity calculations. This feature is fully supported in the 11.8 LTS release, with no extra plugins or separate vector database required.
5. How do you switch MariaDB into Oracle compatibility mode?
A. You need MariaDB Enterprise for that
B. INSTALL PLUGIN oracle_compat;
C. SET SQL_MODE=ORACLE;
D. ALTER DATABASE SET DIALECT ORACLE;
Answer: C. SET SQL_MODE=ORACLE;
Run SET SQL_MODE=ORACLE;
to enable Oracle compatibility mode. MariaDB automatically activates a
set of compatibility settings that support Oracle PL/SQL syntax, data
types, and stored procedures, making migration from Oracle much easier.
6. Which technology gives MariaDB synchronous multi-master clustering out of the box?
A. MaxScale
B. Spider
C. Galera
D. ColumnStore
Answer: C. Galera
MariaDB Enterprise Cluster is built on Galera Cluster technology, providing true synchronous multi-master replication. Any node can read and write, and transactions are certified across all nodes before commit, ensuring zero data loss.
Part 2: SQL Practice Problems
Problem 1: Find the Oldest Departments
Task: Retrieve the name and established year of the oldest departments from the departments table.
SELECT name, established FROM departments WHERE established = (SELECT MIN(established) FROM departments);
Problem 2: Calculate Age at Enrollment
Task: Retrieve student information from the students table and calculate age_at_enrollment.
SELECT student_number, first_name, last_name, date_of_birth, enrollment_date, TIMESTAMPDIFF(YEAR, date_of_birth, enrollment_date) AS age_at_enrollment FROM students;
Problem 3: Filter NASA-Funded Active Research Projects
Task: Retrieve active research projects funded by NASA from the research_projects table.
SELECT title, start_date, end_date FROM research_projects WHERE status = 'active' AND funding_agency = 'NASA';
Part 3: How Can the MariaDB Foundation Be More Visible and Useful in Your Community?
The MariaDB Foundation can improve visibility and usefulness by:
Lowering the barrier to contribution: Offering more beginner-friendly tasks and documentation to encourage non-developers to participate in testing, translation, and community Q&A
Strengthening enterprise partnerships: Inviting more companies to become sponsoring members to drive feature customization and long-term support
Localizing community events: Hosting MariaDB meetups and tech talks in more regions so developers can learn about new features like AI vector search
Suggested Searches & Related Links
You can paste these searches directly into Google:
MariaDB 11.8 LTS release notes
MariaDB vs MySQL differences
MariaDB VECTOR data type tutorial
MariaDB Oracle compatibility mode
MariaDB Galera Cluster setup guide
Related Web Links:
Conclusion
MariaDB not only inherits MySQL's ecosystem compatibility but also keeps innovating with vector search, Oracle compatibility, and clustering solutions. Whether you are migrating a legacy system or building AI applications, MariaDB is worth serious consideration.
