WorksheetsMYSQL Functions
Total questions: 8
Worksheet time: 5mins
Name
Class
Date
1.
Which of the following is not a text function?
a)
TRIM()
b)
TRUNCATE()
c)
LEFT()
d)
MID()
2.
What will be printed by the given query?
SELECT LENGTH( " INFORMATICS PRACTICES");
a)
21
b)
22
c)
23
d)
24
3.
Which of the following is not a numeric function?
a)
MOD
b)
SIGN
c)
MID
d)
POW
4.
Which of the following is not a date function?
a)
Month
b)
Year
c)
Now
d)
Pow
5.
Which of the following functions returns the substring from a given string?
a)
MID
b)
INSTR
c)
SUBSTR
d)
CHAR
6.
What will be returned by the given query?
SELECT INSTR("INDIA", "DI");
a)
2
b)
3
c)
-2
d)
-3
7.
What will be returned by the given query?
SELECT round(153.669, 2);
a)
153.6
b)
153.66
c)
153.67
d)
153.7
8.
What will be returned by the given query?
SELECT month('2020-05-11');
a)
5
b)
11
c)
May
d)
November
100 %
