MariaDB

Which function is used to concatenate two strings in MariaDB? a) ADD() b) CONCAT() c) MERGE() d) JOIN() Answer: b) CONCAT() Explanation: The CONCAT() function is used to concatenate two or more strings in MariaDB, combining them into one string. Reference: MariaDB Quiz – MCQ Questions and Answers

How can you change a column’s data type in an existing MariaDB table? a) MODIFY TABLE b) UPDATE COLUMN c) ALTER TABLE d) CHANGE TYPE Answer: c) ALTER TABLE Explanation: The ALTER TABLE command is used to modify the structure of an existing table, including changing the data type of a column. Reference: MariaDB Quiz

What does the DISTINCT keyword do in a MariaDB SELECT query? a) It removes duplicate rows from the result set b) It sorts the result set c) It calculates averages for each column d) It limits the number of rows returned Answer: a) It removes duplicate rows from the result set Explanation: The DISTINCT keyword

What is a JOIN operation in MariaDB used for? a) To combine rows from two or more tables based on a related column b) To backup a table c) To encrypt data across multiple tables d) To aggregate data into a new table Answer: a) To combine rows from two or more tables based on

Which function is used to count the number of rows in a MariaDB table? a) COUNT() b) SUM() c) LENGTH() d) AVG() Answer: a) COUNT() Explanation: The COUNT() function is used to return the number of rows that match a specified condition in a MariaDB table. Reference: MariaDB Quiz – MCQ Questions and Answers

What does ACID stand for in the context of MariaDB transactions? a) Asynchronous, Consistent, Independent, Durable b) Automatic, Correct, Invariant, Deterministic c) Atomicity, Consistency, Isolation, Durability d) Application, Consistency, Index, Dependency Answer: c) Atomicity, Consistency, Isolation, Durability Explanation: ACID refers to the set of properties that guarantee that database transactions are processed reliably: Atomicity, Consistency,

How can you list all databases in MariaDB? a) SHOW TABLES b) LIST DATABASES c) SHOW DATABASES d) DATABASE LIST Answer: c) SHOW DATABASES Explanation: The SHOW DATABASES command is used to list all databases in MariaDB. Reference: MariaDB Quiz – MCQ Questions and Answers

What is a foreign key in MariaDB? a) A key that encrypts data b) A key used for caching c) A key that links data between two tables d) A key used for indexing Answer: c) A key that links data between two tables Explanation: A foreign key is used to establish a relationship between

Which command is used to update existing data in a MariaDB table? a) MODIFY b) ALTER c) UPDATE d) SET Answer: c) UPDATE Explanation: The UPDATE command is used to modify the data in existing rows in a MariaDB table. Reference: MariaDB Quiz – MCQ Questions and Answers

Which of the following storage engines is not supported by MariaDB? a) InnoDB b) Aria c) XtraDB d) Cassandra Answer: d) Cassandra Explanation: MariaDB supports multiple storage engines like InnoDB, Aria, and XtraDB, but Cassandra is not a supported storage engine. Reference: MariaDB Quiz – MCQ Questions and Answers

What command is used to delete a table in MariaDB? a) REMOVE TABLE b) DROP TABLE c) DELETE TABLE d) DESTROY TABLE Answer: b) DROP TABLE Explanation: The DROP TABLE command is used to permanently delete a table and its data from the database in MariaDB. Reference: MariaDB Quiz – MCQ Questions and Answers

How can you back up a MariaDB database? a) Using the SQL command BACKUP DATABASE b) Using the mysqldump command-line tool c) By exporting the data as a text file d) By using a GUI tool like MySQL Workbench Answer: b) Using the mysqldump command-line tool Explanation: The mysqldump tool is commonly used to back

What is a primary key in MariaDB? a) A key that identifies a unique record in a table b) A key that is always indexed c) A key that encrypts the database d) A key used to sort the records Answer: a) A key that identifies a unique record in a table Explanation: A primary

Which of the following is true about MariaDB replication? a) It only supports master-master replication b) It supports master-slave replication c) It does not support replication d) It only replicates schema, not data Answer: b) It supports master-slave replication Explanation: MariaDB supports both master-slave and master-master replication, making it suitable for distributed databases and high

Which command is used to create a new database in MariaDB? a) CREATE DATABASE b) NEW DATABASE c) CREATE SCHEMA d) INIT DATABASE Answer: a) CREATE DATABASE Explanation: The CREATE DATABASE command is used to create a new database in MariaDB. Reference: MariaDB Quiz – MCQ Questions and Answers

What is the function of the WHERE clause in MariaDB SQL queries? a) To limit the number of rows returned b) To filter records based on a specific condition c) To sort the result set d) To join two tables Answer: b) To filter records based on a specific condition Explanation: The WHERE clause is

What is the default storage engine in MariaDB? a) MyISAM b) InnoDB c) Aria d) RocksDB Answer: b) InnoDB Explanation: InnoDB is the default storage engine in MariaDB, known for its ACID-compliant transactions and support for foreign keys. Reference: MariaDB Quiz – MCQ Questions and Answers

Which query language does MariaDB use? a) NoSQL b) SQL c) SPARQL d) GraphQL Answer: b) SQL Explanation: MariaDB uses Structured Query Language (SQL) for interacting with relational data, just like MySQL. Reference: MariaDB Quiz – MCQ Questions and Answers

MariaDB is a fork of which database? a) PostgreSQL b) Oracle c) MySQL d) SQL Server Answer: c) MySQL Explanation: MariaDB was created as a fork of MySQL, offering a similar feature set with improved performance, open-source development, and community-driven enhancements. Reference: MariaDB Quiz – MCQ Questions and Answers

What is MariaDB? a) A NoSQL database b) A relational database management system (RDBMS) c) A file storage system d) A distributed caching system Answer: b) A relational database management system (RDBMS) Explanation: MariaDB is a relational database management system (RDBMS) that provides a structured way to store, retrieve, and manage data using SQL queries.