
SQL Query Quiz
Authored by diksha goplani
Computers
12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query is used to select all columns from a table named Students where the Age is greater than 18?
SELECT * FROM Students WHERE Age > 18;
SELECT * FROM Students WHERE Age = 18;
SELECT Students FROM Age > 18;
SELECT * FROM Students WHERE Age >= 18;
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query is used to count the total number of employees in the Employee table?
SELECT COUNT(*) FROM Employee;
SELECT TOTAL(Employee) FROM Employee;
SELECT NUM(Employee) FROM Employee;
SELECT EMPLOYEE COUNT FROM Employee;
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query is used to retrieve the maximum salary from the Salaries table?
SELECT MAX(Salary) FROM Salaries;
SELECT HIGH(Salary) FROM Salaries;
SELECT SALARY MAX FROM Salaries;
SELECT MAXIMUM(Salary) FROM Salaries;
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the result of the following query? SELECT Name, Age FROM Students WHERE Age BETWEEN 18 AND 25;
Selects names and ages of students between 18 and 25 years old
Selects names and ages of students who are exactly 18 and 25 years old
Selects only students older than 25
Selects all students with names and ages
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query is used to select the first name, last name, and age of all employees from the Employee table, and sort them in ascending order of age?
SELECT FirstName, LastName, Age FROM Employee ORDER BY Age ASC;
SELECT * FROM Employee ORDER BY Age;
SELECT FirstName, LastName, Age FROM Employee ORDER BY Age DESC;
SELECT FirstName, LastName, Age FROM Employee WHERE Age > 30;
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query is used to find all unique cities from the Customers table?
SELECT DISTINCT City FROM Customers;
SELECT UNIQUE City FROM Customers;
SELECT City FROM Customers GROUP BY City;
SELECT City FROM Customers WHERE DISTINCT;
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which SQL query would be used to update the Salary of an employee with EmployeeID 102 to 50000 in the Employees table?
UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 102;
UPDATE Salary SET Employees = 50000 WHERE EmployeeID = 102;
UPDATE Employees SET Salary = 50000;
UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 101;
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
40 questions
Computer Science Pre-Assessment Quiz
Quiz
•
9th - 12th Grade
38 questions
Computer Hardware Basics+
Quiz
•
7th - 12th Grade
40 questions
Introduction to Microsoft Word
Quiz
•
8th - 12th Grade
45 questions
คอมพิวเตอร์เบื้องต้น
Quiz
•
10th - 12th Grade
39 questions
adobe photoshop 2015 certification quiz 1
Quiz
•
9th - 12th Grade
36 questions
Engineering Careers
Quiz
•
9th - 12th Grade
37 questions
ôn tập giữa kì 2 lớp 11
Quiz
•
11th Grade - University
40 questions
Կիսամյակային 12-րդ դասարան
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade