MariaDB Interview Preparation Guide
Download PDF

MariaDB Frequently Asked Questions in various MariaDB job interviews by interviewer. The set of questions are here to ensures that you offer a perfect answer posed to you. So get preparation for your new job interview

55 MariaDB Questions and Answers:

1 :: Tell me what Version Of Mariadb Is Workable On Windows 7 X64?

Any released version.

However, MariaDB 5.2.5 and below were all compiled for 32-bit Windows only. These versions of MariaDB will run under 64-bit Windows, but they will run as 32-bit processes.

MariaDB 5.2.6 and above have 64-bit Windows binaries available. 64-bit binaries (and MSI packages) can also be built from the source, as described in Building MariaDB on Windows.

2 :: Do you know what Is The Goal Of Mariadb?

To provide a community developed, stable, and always Free DBMS that is, on the user level, broadly compatible with MySQL.

We strive for interoperability with both our own, and our upstream, communities.

Until MariaDB 5.5, MariaDB was kept up to date with the latest MySQL release from the same branch. For example MariaDB 5.1.47 was up to date with MySQL 5.1.47, and so on.

We did a merge from the main MySQL branch for every new MySQL release or when there was some critical bugfix applied to the main branch.

Since MariaDB 10.0, MariaDB includes backported features from MySQL as well as entirely new features not found anywhere else, but does not necessarily include all MySQL features.

We strive to keep our main trees as free from bugs as possible. It should be reasonably safe to pull from our trees at any time.

3 :: Tell me can I Get Help With Mariadb? Something's Broken!?

If you can't find help in the MariaDB documentation, in many cases the documentation for MySQL can be used. New features of MariaDB are mentioned on the MariaDB versus MySQL page and in greater detail under the MariaDB category.

If you have a question about a feature that is not properly documented or something that is not working as expected, go to the corresponding Knowledge Base page and ask your question there.

You can report and check on bugs which are unique to MariaDB in JIRA. MySQL bugs that also affect MariaDB should also be reported to MySQL.

You can also subscribe to the mailing lists and or join the IRC channel to communicate with MariaDB users and developers.

The MariaDB Corporation offers commercial support for MariaDB and all major MySQL versions (starting from MySQL 3.23).

4 :: Please explain what are the main features of MariaDB?

Following is a list of features of MariaDB:

☛ MariaDB can run on different operating systems and support a wide variety of programming language.
☛ MariaDB follows a standard and popular querying language.
☛ MariaDB provides Galera cluster technology.
☛ MariaDB provides supports for PHP which is the most popular web development language.

5 :: Tell me how can you retrieve limited number of records from a table?

LIMIT clause is used with SELECT statement to select a limited number of records from a table. It facilitates you to retrieve records according to your use.

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT row_count;

6 :: Tell me what are the different types of clauses used in MariaDB?

MariaDB supports all clauses used in RDBMS. For example:

☛ MariaDB Where Clause
☛ MariaDB Like Clause
☛ MariaDB Order By Clause
☛ MariaDB DISTINCT Clause
☛ MariaDB FROM Clause
☛ Etc.

7 :: Tell us what is the use of COUNT() aggregate function?

MariaDB COUNT() aggregate function is used to return the count of an expression.

SELECT COUNT(aggregate_expression)
FROM tables
[WHERE conditions];

8 :: Please explain what is LEFT OUTER JOIN in MariaDB?

MariaDB LEFT OUTER JOIN is used to return all rows from left-hand table specified in the ON condition and only those rows from the other table where the joined condition is satisfied.


SELECT columns
FROM table1
ON table1.column = table2.column;

9 :: Tell me how can you stop replication on all slave servers at the same point in time?

This will show if they use tools or hack methods.
Normally, replication stops when an error occurs on the slave, so if they force an error that is replicated it would stop the all slaves at the same point in time, an "old school" method to stoping the slaves.

10 :: Tell us what is has been the hardest problem you ever had to solve with MySQL?

☛ Allow them explain and go into detail about the problem as well as the solution.
☛ Why was it a problem ?
☛ How did you fix it?
☛ Was it a revenue dependent emergency fix?
☛ Did the problem reappear or stay fixed ?