Comparing MariaDB and MySQL: Fundamentals and Features Quiz

1. Origin of MariaDB

   Which statement correctly describes the origin of MariaDB as it relates to MySQL?

   1. MariaDB was forked from MySQL due to licensing concerns.
   2. MariaDB is an entirely new database built from scratch.
   3. MariaDB was acquired by the same company as MySQL.
   4. MariaDB stands for My Arithmetic Database.
   5. MariaDB and MySQL have always been separate and unrelated.

2. Supported SQL Syntax

   If you write a simple SELECT query to fetch data from a table, which of these correctly describes how MariaDB and MySQL handle basic SQL syntax?

   1. Both MariaDB and MySQL use mostly identical SQL syntax for basic queries.
   2. Only MariaDB supports the SELECT statement.
   3. MariaDB uses different keywords for queries compared to MySQL.
   4. MySQL does not support the WHERE clause.
   5. MariaDB only supports advanced queries, not basic ones.

3. Storage Engine Choices

   Which option best describes the approach to storage engines in MariaDB compared to MySQL?

   1. MariaDB includes more storage engines by default than MySQL.
   2. MySQL uses only one storage engine.
   3. MariaDB does not support pluggable storage engines.
   4. Both support the exact same storage engines all the time.
   5. MariaDB uses a proprietary storage engine only.

4. Performance Features

   A developer wants improved replication speed and stability; which database is known for introducing enhanced replication features first?

   1. MariaDB
   2. MycQL
   3. MySOL
   4. MariDB
   5. MySqll

5. License Differences

   Which type of license is associated with MariaDB to encourage open-source development?

   1. GPL license
   2. BSD licensed
   3. Commercial only license
   4. Apache v3 license
   5. Private license