View note:MySql-interview-questions-advance



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)Using SELECT statement find the version of the server you are running and print the name of the current database

001
2) Is it possible to implement ‘AND’ with NOT (!) Operator.

001
3)USE NOT Operator (!) to select all the users except ‘SAM’ from a table say ‘Tecmint’

001
4)What IFNULL() statement is used for in MySQL?

001
5)You want to see only certain rows from a result set from the beginning or end of a result set. How will you do it?

001
6)Oracle Vs MySQL. Which one and Why?

001
7) How will you export tables as an XML file in MySQL?

001
8)What is MySQL_pconnect? And how it differs from MySQL_connect

001
9)You need to show all the indexes defined in a table say ‘user’ of Database say ‘mysql’. How will you achieve this?

001
10)What are CSV tables?

001
11) How to reset the autoincrement?

001
12)How to get number of days difference between two date

001
13)How to update the column where NULL value set?

001
14)How to get the next auto-increment id in mysql?

001
15)What is Query to delete a Index?

001
16)What is command to check table is exist?

001
17)How to update auto increment value to 1000?

001
18) How to get number of days difference between two date?

001
19)The datatype for single precision floating point number is

001
20)Which datatype is used for a fixed length binary string?

001
21)Which datatype means a variable length non binary string?

001
22)Which data and time datatype stores time value in ‘hh:mm:ss’ format?

001
23)Which spatial datatype is used to store a curve?

001
24) How many of the following attributes are allowed only for numeric types?

001
25)A DEFAULT value cannot be supplied to spatial types. a) True b) False

001
26)DEFAULT value cannot be supplied to TEXT types. a) True b) False

000
27)The datatype SMALLINT stores

001
28)The maximum non zero value for FLOAT is

001
29)The storage size in bytes required for the MEDIUMINT datatype ?

001
30)The maximum number of elements allowed in SET() .

001
31)MEMORY tables do not support BLOB and TEXT indexes. a) True b) False

001
32) MySQL works with spatial values in 3 formats a) True b) False

000
33) By default, MySQL clips out of range numeric values to the nearest fit value. a) True b) False

000
34)For which type are illegal values converted to the appropriate ‘zero’ value

000