Day 1 of 15 Days SQL Roadmap 🚀
Learning the basics: Database | DBMS | SQL
Follow for more SQL learning 📊
#SQL #LearnSQL #DataScience #Coding #Programming
https://www.instagram.com/p/DV1DBUwkpxB/?igsh=OG50ZHppNGV3ZnNw
Learning the basics: Database | DBMS | SQL
Follow for more SQL learning 📊
#SQL #LearnSQL #DataScience #Coding #Programming
https://www.instagram.com/p/DV1DBUwkpxB/?igsh=OG50ZHppNGV3ZnNw
Which SQL command is used to create a new database?
Anonymous Quiz
2%
MAKE DATABASE
1%
ADD DATABASE
2%
INSERT DATABASE
95%
CREATE DATABASE
Which SQL statement is used to retrieve data from a table?
Anonymous Quiz
11%
GET
7%
FETCH
79%
SELECT
3%
DISPLAY
Q. Which SQL operator is used to select values within a range?
Anonymous Quiz
80%
BETWEEN
10%
IN
1%
OR
10%
LIMIT
Which SQL clause is used to sort the result set?
Anonymous Quiz
53%
ORDER BY
34%
SORT
4%
LIMIT
10%
GROUP BY
Q. Which SQL function is used to calculate the average value?
Anonymous Quiz
5%
SUM ()
5%
COUNT ()
1%
MIN ()
90%
AVG ()
Which clause is used to filter grouped data?
Anonymous Quiz
8%
WHERE
61%
GROUP BY
28%
HAVING
3%
ORDER BY
Which SQL function is used to convert text into uppercase?
Anonymous Quiz
1%
LOWER ()
94%
UPPER ()
3%
CAPITAL ()
2%
CONVERT ()