Tech - MySQL

Posted at 2022-04-29Updated at 2022-04-29 interview  interview tech 

Q & A of mysql ^[1][2][3].

# Basics

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

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

# What are the technical features of MySQL

• Easy to use. MySQL is easy to use.
• It is secure.
• Client/ Server Architecture.
• Free to download.
• It is scalable.
• Speed.
• High Flexibility.

# What are some of the advantages of using MySQL?

• Flexibility: MySQL runs on all operating systems
• Power: MySQL focuses on performance
• Enterprise-Level SQL Features: MySQL had for some time been lacking in advanced features such as subqueries, views, and stored procedures.
• Full-Text Indexing and Searching
• Query Caching: This helps enhance the speed of MySQL greatly
• Replication: One MySQL server can be duplicated on another, providing numerous advantages
• Configuration and Security

# Explain SELECT, LIKE, IN, Regular-Expression, Datatypes, Sub-Query in MySQL

# Explain JOIN Query in MySQL

# What are Heap tables

# How many TRIGGERS are possible in MySQL?

# Explain Transaction in MySQL

---

1. MySQL Interview Questions ↩︎

2. MySQL Interview Questions ↩︎

3. MySQL Interview Questions ↩︎