MySQL Interview Questions And Answers

SOOPRO Pathshala provides MySQL Interview Questions and Answers

1. What is MySQL?

MySQL is a relational database management system based on SQL (Structured Query Language). It is an open source software owned by Oracle and can run on various platforms.

2. In which language has MySQL been written?

MySQL is written in C and C++. Its SQL parser is written in yacc.

3. What are the advantages of using MySQL?

MySQL is a fast, stable, and reliable solution that provides advantages like:

Data Security – most secure and reliable database management system

Flexibility – runs on all operating systems; features 24X7 support and enterprise indemnification

High Performance – powerful, designed to meet highly demanding applications while maintaining optimum speed and high performance

On-demand Scalability – offers on-demand scalability and complete customization

Enterprise-level SQL Features – the enterprise edition includes advanced features and management tools, and technical support for enterprise

Full-text Indexing and Searching – has support for full-text indexing and searching

Query Caching – unique memory caches help enhance the speed of MySQL greatly

Replication – one MySQL server can be duplicated on another, resulting in numerous benefits

4. What is a database?

Database is a collection of tables. It is generally controlled by a database management system.

5. What does 'MySQL' stand for?

'My' in MySQL represents the first name of its co-founder, Michael Widenius' daughter, My Widenius. SQL is an abbreviation for the term "Structured Query Language". SQL is also used in databases like Oracle and Microsoft SQL Server.

6. How to check MySQL version?

The command 'MySQL-v' can be used to check MySQL version on Linux

7. What does a MySQL database contain?

A MySQL database contains one or many tables, with each table containing several records or rows. Within these rows, data is contained in various columns or fields.

8. List the ways to interact with MySQL

There are 3 main ways users can interact with MySQL:

• Using a command line
• Through a web interface
• Using a programming language

9. What are the different tables in MySQL?

• MyISAM
• HeapMerge
• INNO DB
• ISAM

10. What are MySQL Database Queries?

A query is a request for data or information from a database. Users can query a database for specific information, and the resultant record/records are returned by MySQL.

11. What is BLOB??

BLOB is an acronym for a binary large object. It is a string data type used to hold a variable amount of data.

12. How do you add users in MySQL?

The CREATE command, along with necessary credentials, can be used to add users.

CREATE USER 'testuser' IDENTIFIED BY 'sample password';