Website Registration and Web Hosting at SYSCOM INDIA: MariaDB Essentials: 5 Fun Quiz Questions + 3 SQL Practice Problems (with Answers)

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

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.

Website Registration and Web Hosting at SYSCOM INDIA

Monday, 12 October 2026

MariaDB Essentials: 5 Fun Quiz Questions + 3 SQL Practice Problems (with Answers)