Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions Network Architect Interview Questions

Top 22 MariaDB Interview Question for 2020

1) What is MariaDB?

It is a community based database devoloped by MySQL Devolopers. It provides same features as MySQL also, can be said that it is a replacement of MySQL.

2) Enlist some features of MariaDB.

  • It supports different Programming Languages and can run on many Operating Systems.
  • It provides Galera Cluster Technology.
  • It has more storage engines.
  • It has quicker and more transparent security release.

3) Write the default data directory for MariaDB?

The location of data directory is controlled by datadir variable. The default address is /etc/mysql/my.cnf file where MariaDBis configured to store data.

4) What is Galera Cluster in MariaDB?

Galera Cluster is a synchronous multi-master cluster for MariaDB but it is only for linux and only supports XtraDN/InnoDB.

5) Enlist some GUI/workbench for MariaDB.

  • MySQL Workbench
  • Webyog/SQLyog
  • HeidiSQL
  • dbForge Studio

6) Why does MariaDB 10.2 use InnoDB instead of XtraDB?

Keeping upto date with Mysql, MariaDB uses InnoDB/XtraDB but it has becomes a very difficult task to devolop. Devolopment was already going on with InnoDB which has taken more than half a year. Thus, to release ASAP they didn't switch to XtraDB.

7) What is an aggregate function?

Aggregate function are those functions which grouped multiple rows data on some condition to provide more significant result such as List, Set, Group etc.

8) Enlist some types of aggregate function?

  • COUNT Function
  • SUM Function
  • MIN Function
  • MAX Function
  • AVG Function

9) What are the different types of Clause used in MariaDB?

  • Where Clause
  • Order By Clause
  • Like Clause
  • Distinct Clause etc.

10) What is JOIN? How many types of JOIN in MariaDB?

Join is used to retreive data from multiple tables by applieng joins such as:
  • INNER JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN

11) What is the use of ORDER BY clause in MariaDB?

ORDER BY clause is used to sort the records in inreasing or decreasing order. Syntax:
SELECT expressions      

FROM tables      

[WHERE conditions]      

ORDER BY expression [ ASC | DESC ];

12) How MariaDB protects from SQL Injection?

SQL Injection problem occurs at the time of Insertion or Updation of data such as Name, Salary etc and code logic fails to analyze. To avoid SQL Injection we can provide Validation through pattern matching.

13) Enlist the types of Backups in MariaDB.

There are two types of Backups:
  • Logical Backups: It provides flexibility of restoring data on another machines. Logical Backups occurs at tables and database.
  • Physical Backups: This type of backups is smaller in size and vaery fast in restoring of data. It includes log and configuration files which occur at directory or file level.

14) Enlist some backup tools.

  • XtraBackup
  • Snapshots
  • LVM
  • TokuBackup

15) What is Indexs? How many types of Indexes in MariaDB?

Indexes: It is a tools which helps in faster retreival of records present in tables. Indexes is of 4 types:
  • Primary
  • Unique
  • Plain
  • Full-Text

16) What are Heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis.

17) Which Is The Max Storage Capacity Of Version 5.5 Mariadb?

InnoDB/XtraDB tables can be up to 64TB (terabytes) in size. On top of this you can have multiple tables per database and multiple databases per server.

18) What are Heap tables?

HEAP tables are present in memory and they are used for high speed storage on temporary basis.

19) What is function in MariaDB?

MariaDB function is a stored program that is used to pass parameters into them and return a value.

20) What is the use of DELETE statement in MariaDB?

The MariaDB DELETE statement is used to delete one or more records from the table in the database.

21) 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.

22) What is a procedure or a stored procedure in database?

Procedures are sort of functions in a database. Procedures are created when you want to perform a task repetitively. MariaDB procedure is a stored program that is used to pass parameters into it. It does not return a value like a function does.