MariaDB Interview Questions

Are you a person who has an interest in Databases and its applications? If you have a good knowledge in the database and its working, then you should definitely go with the MariaDB. This database provides the stability and availability in the market which is absolutely free. So, track down into MariaDB as a database engineer and get equipped yourself with its features and functions. To help you in cracking job, here we present you some questions which may ask in the interviews.

Here we have listed a few popular MariaDB Interview Questions.

#1 What do you mean by JOIN in MariaDB?

It is also known as inner join. You can select it by the SELECT statement. JOIN is used to recover the data from tables that should be two in number or can be more than it.

#2 Why it is the name as MariaDB?

The company says that MariaDB is a modification of MySQL. MySQL is linked to the Oracle because the trademark is suggested by Oracle. Thus, the company decided to continue this trademark. As MySQL name has come from Monty's first daughter "My", so, for maintaining the continuity MariaDB has come from elder daughter Maria.

#3 Is user can create own functions in MariaDB? If yes, then how?

Yes, the user can easily create the functions in MariaDB by following the syntax.

Create FUNCTION function-name [data type]

RETURNS return-datatype |Deterministic |Not Deterministic|

{contains SQL | NO SQL data}

|SQL Security (Definer | Invoker}

|Comment ‘comment-expression’

BEGIN

Declaration section

Executable section

END;

#4 what are the steps to change Innodb_page_size?

It does need to do anything with a new install. There are steps to follow if you want to change the size. These are:

  • Firstly, go through your data and export it by moving it or by deleting the database and folders.
  • When it is done, fixed innobd_page_size to any of the 4k or 8k
  • After that, restart the MariaDB.
  • When it is on, there appears a new XtraDB but having smaller page size.
  • Now you are free to introduce your data and do what you want to do.

So, in this whole procedure, you don't need to do anything with the new installment.

#5 Mention the various clauses used in MariaDB?

It supports almost all types of clauses in RGDBM. For example:

    • MariaDB WHERE clause: For WHERE clause there is 4 statement depending on the selection or change of location. These four statements are INSERT, DELETE, SELECT, and UPDATE.

Syntax: SELECT field1, field2 FROM table_name1, table_name2 WHERE field LIKE conditions.

    • MariaDB Order by clause: In MariaDB, Order By clause is used to set the result in ascending or descending order.

Syntax: Select expressions from table_name Order By expression.

    • MariaDB Distinct clause: This clause is used to delete duplicate records from the table if any.

Syntax: Select Distinct from expressions.

    • MariaDB From clause: The FROM clause is used to fetch the data from the tables.

Syntax: Select columns FROM table;

#6 Which command is used to delete the table in MariaDB’s database?

The command DROP TABLE is used to delete the table in MariaDB’s database. It is needed to make sure if you really want to delete the table because it permanently deletes the table and it can’t be recovered. Triggers are also removed with the table definitions and table data so it needs to do when you are sure.

Also Prepare: Frequently Asked OrientDB interview questions

#7 What is the main objective of MariaDB?

The main purpose of MariaDB is to supply a better, firm and community developed and also that is compatible with MySQL. It is always free DBMS on the basic level.

#8 What do you understand by the MariaDB?

MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology. It also provides a similar trait as MySQL.IT is the modification of MySQL. Maria DB is efficient in transferring the data into the applications. The main reason for being used MariaDB is because it is scalable, speedy and easy to hand. Moreover, it provides a lot of services like the plugin, storage and much more.

#9 What do you understand by the function in the MariaDB?

MariaDB function is work as a stored program in which a particular type of parameters is allowed to pass through them which in exchange, they return a value.

#10 Which Version of MariaDB Is preferable to Work on Windows 7 X64?

Although 5.2.5 is also efficient for windows 7 X64. But all these versions are like to prefer 5.2.6 or latest more versions.

#11 What are deterministic and non-deterministic functions in MariaDB database?

Deterministic means that the result should be one value given a number of inputs parameters.

Non-deterministic means that the result can give a different value given a number of input parameters. The result can be changed because of the data, numbers, tables etc.

#12 Mention some characteristics of MariaDB?

It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are: -

  • MariaDB is licensed under GPL, LGPL, or BSD.
  • It is authorized under the BSD, LGPL, GPL MariaDB.
  • It is suitable to work with the data sources like RDBMS.
  • It provides a great number of storage engines.
  • It provides some great extraordinary performance engines.
  • It has a good paradigm inquiring language.
  • It supports a lot of operating systems and can work on it.
  • It supports a large number of programming language.
  • It even supports the most used web development language that is PHP.
  • Galera cluster technology is also supported by MariaDB.
  • As it is the modification of MySQL, it supports many functions that are absent in MySQL.
  • It contributes commands and many operations.
  • It removes some unnecessary features present in MySQL.

#13 What is the difference between delete and truncate statement in MariaDB?

  • TRUNCATE TABLE is used only when the whole table has to be deleted or removed permanently while the DELETE TABLE is considerably used when it has to remove only columns which can be one or more in number or has to remove the whole table.
  • Both of these TABLES (TRUNCATE and DELETE) are exactly the same. The basic difference between these two is WHERE clause.
  • Truncate table is quite faster than the delete table.
  • DELETE TABLE is used to delete row only one at a particular time and this is recorded in the transaction log.
  • TRUNCATE TABLE also kept the record in the transaction log but it firstly eliminates the data by deallocating it which is efficient to store and record. That is the main reason that TRUNCATE is faster than the DELETE TABLE.

#14 How many types of procedures are there in MariaDB database?

There are 3 types of procedures in MariaDB database on the basis of references and parameter overwritten. These are

  • 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 parameter 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 it can’t be overwritten by a procedure.

#15 What are the various functions used in MariaDB?

The main basic functions are:

    • SUM (): This function is used to summed 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 where conditions.

    • MIN (): It is used to find the minimum value from all of the expressions present in the table. It can also accept the string arguments and return the minimum string values.

Syntax: Select MIN from table;

    • MAX (): It is opposite to MIN function. We can see it from the name that this is used to return the maximum value of an expression from the table. Same as MIN (), it also returns maximum string value if the argument is a string in form.

Syntax: Select MAX from table;

    • AVG (): This function is used to find the average value of the expressions in the table. This means it retrieves the average value of an expression.

Syntax: Select AVG (aggregate expression) from table;

Ask a Question