
SQL Queries Quiz
Authored by DR MURTHY
Computers
12th Grade
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to retrieve data from a database?
INSERT
UPDATE
SELECT
DELETE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which clause is used to filter records in an SQL query based on a condition?
WHERE
GROUP BY
ORDER BY
HAVING
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL statements is used to remove rows from a table?
TRUNCATE
DELETE
DROP
REMOVE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will the following query do? SELECT COUNT(*) FROM Employee;
Returns the total number of columns in the Employee table
Returns the total number of rows in the Employee table
Returns the number of distinct employees
Returns the sum of all employee salaries
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL function is used to combine the values of multiple columns into one string?
CONCAT
SUM
LENGTH
GROUP_CONCAT
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In SQL, the INNER JOIN keyword:
Combines rows from two or more tables where there is a match in the columns being joined
Returns all rows from the left table
Returns all rows from the right table
Combines all rows regardless of whether they match
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is correct for selecting all columns from a table named Products?
SELECT all FROM Products;
SELECT * FROM Products;
SELECT columns FROM Products;
SELECT everything FROM Products;
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
15 questions
1.1.1 The structure and function of the processor
Quiz
•
11th Grade - University
15 questions
Quiz 1
Quiz
•
1st - 12th Grade
10 questions
PUNCTUATION SPACING RULES
Quiz
•
9th - 12th Grade
10 questions
COMPUTER PROGRAMMING Q2_FLOWCHART (2 points each)
Quiz
•
11th - 12th Grade
10 questions
2025 python class first quiz
Quiz
•
9th Grade - University
13 questions
Stepwise Refinement
Quiz
•
11th - 12th Grade
10 questions
MEDIA AND INFORMATION LITERACY
Quiz
•
12th Grade
11 questions
Threats to Data
Quiz
•
9th - 12th Grade
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