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"}
More Quizzes
SQL
1050
SQL
1050
Chosen Quiz
1050
Essen und Trinken
10547
Panic Attack - Free Self-Assessment for Symptoms
201017653
Which Vitamins Should I Take? - Free Supplement
201018444
Dental Assistant Certification Practice - Free
201017196
Do I Have Social Anxiety or Am I Just Shy? Free
201017071
King Henry Doesn't Drink Chocolate Milk - Metric Prefix
201016949
Migraine: Free Symptom Checker with Instant Results
201018444
Mechanical Engineering Fundamentals - Free Practice
201017010
Quiz 30 Pro - Pro Tools Audio Editing Skills Test
201021209