
SQL Test on Functions
Authored by Nirender Prakash Singh
Computers
12th Grade
Used 8+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does SQL stand for?
Structured Query Language
Simple Query Language
Standard Question Language
Structured Question Language
Answer explanation
SQL stands for Structured Query Language, which is the standard language used for managing and manipulating relational databases. The other options do not accurately describe SQL.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to calculate the total number of rows in a table?
SUM()
COUNT()
TOTAL()
NUM()
Answer explanation
The COUNT() function is specifically designed to count the number of rows in a table. Unlike SUM(), TOTAL(), or NUM(), which serve different purposes, COUNT() directly provides the total row count.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will the following query return? SELECT UPPER('hello');
Hello
hello
HELLO
hELLO
Answer explanation
The query SELECT UPPER('hello') converts the string 'hello' to uppercase. Therefore, it returns 'HELLO', which is the correct answer.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to retrieve the current date in MySQL?
GETDATE()
CURRENT_DATE()
NOW()
TODAY()
Answer explanation
The function CURRENT_DATE() is used in MySQL to retrieve the current date. GETDATE() and NOW() are used in other SQL dialects, while TODAY() is not a valid MySQL function.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the ROUND() function do?
Rounds a number to the nearest integer
Rounds a number to a specified decimal place
Both A and B
None of the above
Answer explanation
The ROUND() function can round a number to the nearest integer or to a specified number of decimal places. Therefore, the correct answer is 'Both A and B'.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following functions can be used to find the length of a string in MySQL?
SIZE()
LENGTH()
COUNT()
CHAR_LENGTH()
Answer explanation
In MySQL, the LENGTH() function is used to find the length of a string in bytes. CHAR_LENGTH() can also be used to find the number of characters. SIZE() and COUNT() are not valid for this purpose.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will SELECT NOW(); return?
The current time
The current date and time
The current day
The current year
Answer explanation
The SELECT NOW(); command in SQL returns the current date and time in the format 'YYYY-MM-DD HH:MM:SS'. Therefore, the correct answer is 'The current date and time'.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
27 questions
Python Fundamentals - II
Quiz
•
11th - 12th Grade
25 questions
Visual Programming
Quiz
•
5th - 12th Grade
25 questions
Common Algorithms
Quiz
•
9th - 12th Grade
31 questions
Digital Literacy Chapter 11 Review
Quiz
•
9th - 12th Grade
26 questions
ÔN tập
Quiz
•
12th Grade
25 questions
REVIEWER| COMPUTER SYSTEM SERVICING 1 (CSS 1)
Quiz
•
12th Grade
25 questions
Inteledge'22 - First Round
Quiz
•
9th - 12th Grade
25 questions
Phishing Awareness Quiz 2
Quiz
•
6th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade