Home >> Top 210+ MySql Interview Questions and Answers in 2022

Top 210+ MySql Interview Questions and Answers in 2022

MySQL is the popular open source database used for web-based applications.
MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).
It is a structured collection of data.
MySQL stores data in tables made up of rows and columns. 

RDBMS is a database management system (DBMS) that is based on relational model as introduced by E.F.Code.
It is a DBMS in which the database is organized and accessed according to the relation between data.
In a relational database, relationships between two or more tables by primary and foreign key.
Example- SQL, Orcle, Mysql, Mysql server

Features
1)-Data to be stored in tables.
2)-Data in the form of rows and columns.
3)-Provides facility primary key to uniquely identify the rows.
4)-Creates indexes for quicker data retrival.
5)-Sharing a common column in two or more tables (Primary Key and Foreign Key).
6)-Provides multiuser accessibility that controlled by individual users.

Advantages
1)-Data Security
2)-On-Demand Scalability
3)-High Performance
4)-24×7 Uptime
5)-Comprehensive Transactional Support
6)-Complete Workflow Control
7)-Reduced Total Cost of Ownership
8)-Open Source

Disadvantages
1)-MySQL lower version (5.0 or less) doesn't support ROLE, COMMIT and stored procedure.
2)-MySQL does not support a very large database size as efficiently.
3)-MySQL doesn't handle transactions very efficiently.
4)-MySQL doesn't have a good developing and debugging tool compared to other databases.
5)-MySQL doesn't support SQL check constraints.

1 - What is mysql?
2 - Mysql is DBMS or RDBMS?
3 - What is RDBMS?
4 - What are features of RDBMS?
5 - What are the differences between DBMS and RDBMS?
6 - What are the differences between InnoDB and MYISAM?
7 - Table type / storage engine for table?
8 - What is the maximum size of table?
9 - What is the maximum size of MYISAM table?
10 - What is the maximum size of InnoDB table?
11 - Explain advantages of MYISAM over InnoDB?
12 - Explain advantages of InnoDB over MYISAM ?
13 - What are various DDL commands?
14 - What are various DML commands?
15 - What are various DCL commands?
16 - What is the default port of server?
17 - What are the differences between MyISAM static and MyISAM dynamic?
18 - What is purpose of the NVL function?
19 - Latest version?
20 - How can find current date function?

Copyright ©2022 coderraj.com. All Rights Reserved.