View note:MySql-Interview-questions



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)What is a Cursor?

001
2)What are the nonstandard string types

000
3)What are all the Common SQL Function?

001
4) Explain Access Control Lists

001
5)How Do You Add Three Minutes To A Date

002
6)How many TRIGGERS are allowed in MySql table?

001
7)What is the different between NOW() and CURRENT_DATE()?

000
8)What are the objects can be created using CREATE statement?

001
9)How MySQL Optimizes DISTINCT

000
10)How many columns can be used for creating Index

000
11)How to display top 50 rows

001
12)How to enter Characters as HEX Numbers?

000
13)What are the different tables present in MySQL

001
14)What is ISAM?

102
15)What is InnoDB

000
16)What is the difference between mysql_fetch_array and mysql_fetch_object?

000
17)How can we run batch mode in mysql?

000
18)What are different types of keys.

000
19)Where MyISAM table will be stored and also give their formats of storage

000
20) What is the difference between the LIKE and REGEXP operators

000
21)What is the difference between BLOB AND TEXT?

000
22)How can we get the number of rows affected by query?

000
23)Is Mysql query is case sensitive?

001
24)What are the drivers in MySQL

000
25)What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

000
26)What is the difference between primary key and candidate key?

000
27). How do you login to MySql using Unix shell?

002
28)What does myisamchk do?

000
29)How do you control the max size of a HEAP table

001
30)What is the difference between MyISAM Static and MyISAM Dynamic

000
31)What are federated tables?

001
32)What, if a table has one column defined as TIMESTAMP

000
33)What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

001
34)How can we find out which auto increment was assigned on Last insert?

001
35)How can you see all indexes defined for a table

000
36)What do you mean by % and _ in the LIKE statement?

002
37) How can we convert between Unix & MySQL timestamps?

001
38)What are the column comparisons operators?

000
39) How to represent ENUMs and SETs internally

000
40)What is the usage of ENUMs in MySQL?

001
41)Define REGEXP

000
42)Difference between CHAR and VARCHAR

001
43)Give string types available for column?

001
44)How to get current MySQL version

001
45)What storage engines are used in MySQL?

001
46)What are Heap tables?

001
47)What is the default port for MySQL Server?

002
48)What are the advantages of MySQL when compared with Oracle?

001
49)Differentiate between FLOAT and DOUBLE?

001
50)Differentiate CHAR_LENGTH and LENGTH?

000
51)What is MySQL?

001
52)What are the technical features of MySQL

000
53)Why MySQL is used?

001