25/08/2022
Interview Question Blog 1
MySql
1. Difference between dml dcl dql & ddl
2. Type of Mysql Engines
(i) Difference btw MyISAM vs InnoDB
(ii) Why MyIsam is faster than InnoDb
3. Difference btw Foreign Key,Primary Key, Unique key , Candidate key & composite key.
(i) How many no of column can be primary key
(ii) How many no of column can be unique key
4. Diff types of data types
difference btw varchar & text
5. Diff btw delete & trancate
6. having vs where
7. Difference btw function & store procedure
(i) Why store procedure is fast ?
8. Indexing
(i) How to create indexing
(ii) Type of indexing
(iii) Diff btw cluster & non-cluster indexing
(iv) How indexing works
9. What is view
10. Any sql query can be ask like example
how to get employee name & manager name by single table
11. Types of joining & explanation
12. Which version of mysql are you working
13 How to optimize sql query
14. what is noSql
(i) diff btw noSql & sql
(ii) on which nomysql did you work
(iii) why nosql is faster than sql
15 what is group by
16 Name of any 5 user defined function
17 what is rollback
18 what is ACID properties
19 MySQL table maximum row size limit
20 Syntax for creating table, update table
21 Normalization
(i) what is normalization
(ii) types of normalization
(iii) explain all types with example
(iv) what is BCNF
22 What is RDMS
This blog is just for education purpose, If you understand above all mention topics, you can 90% crack of your mysql interview.
Upcoming blogs will come on interview ques on :
Like share the post for connecting better with us.
For more update you can connect me at
Instagram :https://www.instagram.com/ersahajarora , https://www.instagram.com/webfreetutorials/
Facebook : https://www.facebook.com/WebDeveloperSahajArora/
YouTube : https://www.youtube.com/channel/UCpRo7OeY70kD18p-XC74v6g
Twitter : https://twitter.com/ersahajarora
LinkedIn : https://www.linkedin.com/in/ersahajarora
