Mysql is a relational database management system (RDBMS), below are some commonly asked MySQL interview questions.

Q1) What is Database?

Ans: A database is a collection of  related data files. In other words, a database is a collection of tables and objects such as views, indexes etc.

Q2) What is data security?

Ans: Data security is the protection of data against modification or destruction by unauthorized users.

Q3) What is first normal form?

Ans: If no two rows are identical and each table entry is single valued then the table is said to be in first normal form(1NF).

Q4) What is second normal form?

Ans: If the table is in 1NF and each non-key attribute is dependent on the entire key then table is said to be in second normal form(2NF).

Q5) What is third normal form?

Ans: If the table is in 2NF and all non-key attributes are not dependent upon primary key then the table is said to be in third normal form(3NF).

Q6) What are indexes?

Ans: An index is an internal structure which provides quick access to rows of a table based on the values of more than one columns.

Q7) What is locking?

Ans: Locking is a feature that preserves transaction isolation.

Q8) How do you find the MYSQL server program?

Ans: In Bin directory, you can find mysql server program.

Q9) What is SQL injection?

Ans: SQL injection is like an unauthorized attack on the database on internet. In sql injection unauthorized sql command is used to steal information from a database.

Q10) What is transaction?

Ans: A transaction is a sequence of related instructions that must be treated as one invisible unit. A transaction is atomic.