MariaDB, a multi-threaded, open-source, RDMS. fIts speed is one of its highlights. MariaDB is extraordinarily scalable, capable of handling tens of thousands of tables and billions of data rows. It can also quickly and smoothly manage small amounts of data, making it suitable for small companies or personal projects.
Below are few major features of Mariadb
Q1. What is MariaDB?
MariaDB is a popular public source under GNU GPL which is related to database management technology developed by MySQL developers. Basically, it is the modification of MySQL that is more scalable, speedy, and easy to hand in and also provides a lot of services like the plugin, storage, and much more.
Q2. Enlist few features of MariaDB?
Some of the features of MariaDB are as follows:
Q3. Write syntax to create a Database in MariaDB?
The syntax to create a Database in MariaDB is CREATE DATABASE. Syntax - create [or replace] database [if not exists] database_name
Q4. Who is the founder of MariaDB?
Michael “Monty” Widenius is the founder of MariaDB as well as the founder of MYSQL. The main focus of the MariaDB Foundation is to keep the quality of the MariaDB project high.
Q5. What is difference between MariaDB & Mysql?
The difference between MariaDB & Mysql can be stated as MySQL is open-source relational database management developed by oracle which is used in many small and large-scale industrial applications and is capable of handling a large volume of data. Whereas MariaDB is an open-source relational database management system developed by MariaDB Foundation, developed as the replacement of MySQL as it is consists of a significantly high number of new features, which makes it better in terms of performance and user orientation.
Q6. What do you mean by stored procedure?
In MariaDB, the stored procedures are basically the procedures that work as a stored program in which a particular type of parameter is allowed to pass through them but in exchange, they do not return any value.
Q7. How many types of procedures are available in MariaDB?
There are three types of procedures available in the MariaDB database on the basis of references and parameter overwritten, which are as follows:
IN procedure- In this type of procedure, the values of a parameter can be overwritten and referenced by the procedure.
OUT procedure- In this type of procedure, the values of parameters can be overwritten by the procedure but it can’t be referenced by a procedure.
IN OUT- In this type of procedure, the values of a parameter can be referenced by the procedure but they can’t be overwritten by a procedure.
Q8. Enlist types of JOIN's available in MariaDB?
There are basically two types of JOIN present in MariaDB. These are as follows:
Inner join - Inner join is a type of join that works only when the conditions are satisfied. It is used to recover the rows from two or more tables.
Outer join - It can be categorized as:
Q9. List some tools of Gui/workbench For MariaDB Aria?
Some of the important tools of Gui/workbench for MariaDB Aria are as follows:
Q10. Explain temporary tables in MariaDB?
When the table is not compressed, MariaDB writes to a shared temporary tablespace as defined by the innodb_temp_data_file_path system variable.
Q11. What is the use of LIKE clause in MariaDB?
In MariaDB, the LIKE clause is used with the SELECT statement to retrieve data when an operation needs an exact match.
Q12. How to create table alias in MariaDB?
You can create a table alias in MariaDB with the help of the following steps:
Q13. What is use of truncate in MariaDB?
In MariaDB, the TRUNCATE command is used only when the whole table has to be deleted or removed permanently. It is faster and also kept the record in the transaction log but it firstly eliminates the data by deallocating it which is efficient to store and record.
Q14. What is the use of SUM() function in MariaDB?
In MariaDB, the SUM() function is used to sum all values in the expressions and returns the final result. In case, if there are no values in the expressions, then it returns a null value. Syntax - Select SUM from tables were conditions.
Q15. Enlist few aggregate function available in MariaDB?
Some of the aggregate functions available in MariaDB is as follows:
AVG - Returns the average value.
BIT_AND - Bitwise AND.
BIT_OR - Bitwise OR.
BIT_XOR - Bitwise XOR.
COUNT - Returns the count of non-null values.
COUNT DISTINCT - Returns the count of a number of different non-NULL values.
GROUP_CONCAT - Returns a string with concatenated values from a group.
MAX - Returns the maximum value.
MIN - Returns the minimum value.
STD - Population standard deviation.
STDDEV - Population standard deviation.
STDDEV_POP - Returns the population standard deviation.
STDDEV_SAMP - Standard deviation.
SUM - Sum total.
VARIANCE - Population standard variance.
VAR_POP - Population standard variance.
VAR_SAMP - Returns the sample variance.