Slightbook.com Slightbook.com

MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL
1
Explain Access Control Lists.?
2
What are all the Common SQL Function?
3
What are the nonstandard string types?
4
How many TRIGGERS are allowed in MySql table?
5
What are the objects can be created using CREATE statement?
6
How to display top 50 rows?
7
How MySQL Optimizes DISTINCT?
8
Where MyISAM table will be stored and also give their formats of storage?
9
What is the difference between mysql_fetch_array and mysql_fetch_object?
10
What is the difference between BLOB AND TEXT?
11
Is Mysql query case sensitive?
12
How can you see all indexes defined for a table?
13
How do you login to MySql using Unix shell?
14
What is the difference between primary key and candidate key?
15
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
16
What are the drivers in MySQL?
17
What storage engines are used in MySQL?
18
Give string types available for column?
19
Difference between CHAR and VARCHAR?
20
What are the advantages of MySQL when compared with Oracle?
21
What are Heap tables?
22
Why MySQL is used?
23
What are the technical features of MySQL?
24
What is MySQL?