Skip to content

bhavyagupta99/mysql-interview-questions

 
 

Repository files navigation

MySQL Interview Questions

Click if you like the project. Pull Request are highly appreciated.

Table of Contents

Q. What are indexes in a Database? What are the types of indexes

An index is a database structure that you can use to improve the performance of database activity. A database table can have one or more indexes associated with it. An index is defined by a field expression that you specify when you create the index. Typically, the field expression is a single field name, like EMP_ID.

Q. What are the different tables present in MySQL

Note that MySQL supports two different kinds of tables: transaction-safe tables (InnoDB and BDB) and non-transaction-safe tables (HEAP, ISAM, MERGE, and MyISAM). Advantages of transaction-safe tables (TST): Safer.

Q. What are the technical features of MySQL

Relational Database Management System (RDBMS) MySQL is a relational database management system. ... Easy to use. MySQL is easy to use. ... It is secure. ... Client/ Server Architecture. ... Free to download. ... It is scalable. ... Speed. ... High Flexibility.

Q. Explain SELECT, LIKE, IN, Regular-Expression, Datatypes, Sub-Query in mySQL

Q. Explain JOIN Query in mySQL

Q. Explain Stored Procedure, View, Event, triggers in mySQL

Q. Explain Transaction in mySQL

Q. What is difference between procedures and triggers

Q. How do you find third highest salary

Q. How to prevent from database attacks/SQL Injection

Q. How many TRIGGERS are possible in MySql

Q. What are Heap tables

Q. What is the difference between BLOB AND TEXT

Q. Explain advantages of MyISAM over InnoDB

Q. What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()

Q. How to find the unique values if the value in the column is repeated

Q. Define REGEXP

Q. Difference between CHAR and VARCHAR

Q. Give string types available for column

Q. What are the nonstandard string types

Q. What are all the Common SQL Function

About

MySQL Interview Questions

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published