Web Tutorials

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

wifi is hacked

Share your comments

Proud to be an Software Engineer
Share it
If you are also proud

Which country is this ?
Wow

If girl become a programer