Essential Concepts of MariaDB in Database Systems Quiz

Explore fundamental principles of MariaDB, its features, and usage scenarios within database systems. Assess your understanding of MariaDB through practical, easy-level questions designed for learners and professionals alike.

1. MariaDB Storage Engine

   Which storage engine is the default in MariaDB for handling transactional data with ACID compliance?

   1. CSV
   2. MyISAM
   3. InnoDB
   4. MEMORY

   Explanation: InnoDB is the default storage engine in MariaDB, providing ACID compliance for reliable transactions. MyISAM lacks transaction support, MEMORY stores data in volatile memory without persistence, and CSV is designed only for storing tables as comma-separated files without transaction features.

2. User Authentication in MariaDB

   What command is used to grant a user all privileges on a specific database in MariaDB?

   1. ADD USER 'user' IDENTIFIED BY 'password';
   2. GRANT ALL PRIVILEGES ON database.* TO 'user'@'host';
   3. PERMIT USER 'user' TO database;
   4. SET PRIVILEGES FOR 'user'@'host' ON database;

   Explanation: The GRANT ALL PRIVILEGES ON database.* TO 'user'@'host'; statement correctly assigns all privileges to a user for a database. 'ADD USER' is not a valid MariaDB command, 'SET PRIVILEGES' and 'PERMIT USER' are not MariaDB syntax for user privileges.

3. MariaDB Data Types

   Which data type is suitable for storing date and time values in MariaDB?

   1. INT
   2. DATETIME
   3. BLOB
   4. VARCHAR

   Explanation: DATETIME is designed to store both date and time values. VARCHAR holds variable-length strings, BLOB is used for binary data, and INT only stores integer numbers, making them inappropriate for date and time information.

4. Backup Utility in MariaDB

   Which tool is commonly used for backing up MariaDB databases?

   1. psql
   2. mysqldump
   3. sqlite3
   4. mongodump

   Explanation: mysqldump is widely used to back up MariaDB databases by generating SQL statements for data restoration. psql is for PostgreSQL, mongodump is used for MongoDB, and sqlite3 is for SQLite, so these do not work with MariaDB.

5. Replication Types in MariaDB

   Which replication method allows MariaDB to synchronize data from a primary server to one or more secondary servers?

   1. Round-robin scheduling
   2. Load balancing
   3. Master-slave replication
   4. Data sharding

   Explanation: Master-slave replication enables synchronization from a primary (master) server to secondary (slave) servers in MariaDB. Round-robin scheduling and load balancing manage request distribution, not replication, while data sharding partitions data but does not synchronize changes.