MySQL Functions
Master MySQL Functions
Test your knowledge of MySQL fun
Are you ready to challenge yourself? Here’s what you can expect:
- 20 multiple choice questions
- Instant feedback on your answers
- Enhance your MySQL knowledge
1) ________________functions operate on a single value to return a single value
Multiple row
Single row
Aggregate
Summation
2) SUM, AVG,COUNT are examples of ____________________functions.
Date
String
Multiple row
Single row
3) SELECT POW(-3,2) will display the output:
-6
-9
9
6
4) SELECT TRUNCATE(7.956,2) will result in
7.95
7.96
8
8.0
5) INSTR(str,str2) returns the position of the first occurrence of
Str in "MySQL"
Str in str2
Str2 in str
Str2 in "SQL"
6) Any String function returns
Only string
Only number
String or number
String, number or date type data.
7) Write the output of SELECT ROUND(7.3456, 2);
7.34
7.35
7.00
7
8) Write the output of SELECT TRUNCATE(2.3456, 2);
2.34
2.35
2.00
2
9) Write the output of SELECT DAYOFMONTH('2009-08-25');
08
25
09
Monday
10) Write the output of SELECT MONTH('2010-02-26');
26
02
February
Feb
11) Write the output of SELECT RIGHT('Informatics', 4);
Info
Tics
Scit
OfnI
12) Write the output of SELECT MID('Class 12', 2,3);
Cl
As
Las
Cla
13) Write the output of SELECT INSTR(‘UNICODE’,’CO’);
3
4
4,5
5
14) Write the output of Monathname('2009-08-25');
September
August
Sep
Aug
15) SELECT DAYOFYEAR(‘2022-02-28’);
28
02
58
59
16) Write the output of SELECT DAYNAME(‘2022-01-28’);
Monday
Friday
Today
Now
17) Write the output of Select Length('MySQL');
5
7
6
4
18) Write the output of Select left('MySQL',2);
My
SQL
MySQLMySQL
MyMy
19) Write the output of Select sysdate();
2022-01-28
2022-12-31
2022-01-01
2022-12-12
20) Write the output of Select year('2000-10-12');
2010
2012
2022
2000
{"name":"MySQL Functions", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of MySQL functions with our engaging quiz designed for both beginners and advanced users. This quiz covers essential SQL functions, helping you strengthen your understanding and skillset in database management.Are you ready to challenge yourself? Here’s what you can expect:20 multiple choice questionsInstant feedback on your answersEnhance your MySQL knowledge","img":"https:/images/course2.png"}