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 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 F# 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 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

Top 25 MySQL Interview Questions for 2022

1) What is MySQL?

MySql is defined as multi-user DBMS which is built and distributed my MySQLab now acquired by Oracle Co.

2) Enlist the features of MySQL.

  • Cross-Platform Support
  • Wide range of Interface for Application Programming
  • Pre-defined Procedure e.g. Triggers and Cursors.

3) What is the default port of MySQL.

Default Port: 3306.

4) Give some MySQL Function.

NOWO
CURRDATEO
CONCAT (X, Y)
DATEDIFF (X, Y)

5) What are the different tables present in MySQL?

  • MyISAM
  • Heap
  • Merge
  • INNO DB
  • ISAM

6) Differentiate between SQL and MySQL.

SQL is a Standard Query Language which is designed to access the database like MySQL, Oracle DBA. MySQL is a database which stores data in a defined architecture on which language as DDL, DML, DCL can be performed.

7) Describe HEAP Table in MySQL.

HEAP is a memory structure used to store high speed temporary storage.

8) What are the set operators used in MySQL.

  • UNION and UNION ALL
  • INTERSECT
  • MINUS

9) Describe MySQL Constraint in MySQL.

NOT NULL CONSTRAINT: It defines the value stored cannot be null for a particular column in the table of a database. PRIMARY KEY CONSTRAINT: When a primary key is generated for a table then that key is used to describe any relation is defined as primary key constraint. FOREIGN KEY CONSTRAINT: It allows foreign keys to let you cross-reference related data across tables, which help keep this spread-out data consistent.

10) Enlist the drivers required for MySQL?

  • PHP Driver
  • JDBC Driver
  • ODBC Driver
  • C WRAPPER
  • PYTHON Driver
  • PERL Driver
  • RUBY Driver
  • CAP11PHP Driver
  • Ado.net5.mxj

11) What is MySQL globalization?

  • MySQL characterset
  • MySQL collation

12) Differentiate between DROP and TRUNCATE ?

DROP: Completely Delete DATA as well as STRUCTURE from the table whereas TRUNCATE: It Delete the DATA but PRESERVES the structure.

13) Enlist the type of Join in MySQL.

INNER JOIN or JOIN
OUTER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN

14) Enlist the type of Trigger possible in MySQL.

  • Before Insert
  • After Insert
  • Before Update
  • After Update
  • Before Delete
  • After Delete

15) What is BLOB and TEXT in My SQL?

BLOB (Binary Large Object): It stores variable amount of data and is of 4 types.
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
TEXT: It is a case insensitive BLOB having non-binary string (character string). It is of 4 types.
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT

16) What is the storage engine for MySQL?

Storage tables are named as table types. The data is stored in the files using multiple techniques such as indexing, locking levels, capabilities and functions.

17) What is the difference between primary key and candidate key?

Primary key in MySQL is use to identify every row of a table in unique manner. For one table there is only one primary key. The candidate keys is used to reference the foreign keys.

18) What is the use of ENUM in MySQL?

ENUM in MySQL will limit the values that can go into a table. For instance; the user can create a table giving specific month values and other month values would not enter into the table.

19) How to resolve the problem of data disk that is full?

When the data disk is full and overloaded the way out is to create the soft link and move the .frm as well as the .idb files into that link location.

20) What are the storage models of OLAP?

The storage models in OLAP are:
MOLAP
ROLAP
HOLAP

21) Explain transaction in MySQL?

Transaction is logical unit of work where either all or none of the steps should be performed.

22) What is Drool?

Drool is the BRMS (Business Rule Management Systems) that has forward and backward chaining inference based rule engine. There are 2 major components of drool are:
  1. Authoring:This process comprises of the formation of Rules files which is .DRL files.
  2. RuntimeThis process comprises of the formation of occupied memory and handling the initiation.

23) What is JBoss Enterprise BRMS?

JBoss Enterprise BRMS is the reasoning engine for policy and rule developments for business. It also manages access and changes.

24) What are federated tables?

Federated tables allow access to the tables located on other databases on other servers.

25) What is ISAM?

ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.



ADVERTISEMENT
ADVERTISEMENT