SQL Summative Test (G10 - ICT 1)
Authored by JOSEPH ALMONTE
others
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for selecting all records from a table named "Customers"?
SELECT * IN Customers;
SELECT ALL FROM Customers;
SELECT * FROM Customers;
SELECT ALL IN Customers;
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for selecting only distinct values from the "Country" column in the "Employees" table?
SELECT UNIQUE Country FROM Employees;
SELECT DIFFERENT Country FROM Employees;
SELECT DISTINCT Country FROM Employees;
SELECT UNIQUE VALUES Country FROM Employees;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for selecting all records from a table named "Students" where the value of the "Age" column is greater than or equal to 18?
SELECT * FROM Students WHERE Age >= 18;
SELECT * FROM Students WHERE Age => 18;
SELECT * FROM Students WHERE Age > 18;
SELECT * FROM Students WHERE Age 18;
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for selecting all records from a table named "Products" where the value of the "Price" column is between 10 and 20, inclusive?
SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;
SELECT * FROM Products WHERE Price IN (10, 20);
SELECT * FROM Products WHERE Price > 10 AND Price < 20;
SELECT * FROM Products WHERE Price BETWEEN 20 AND 10;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for selecting all records from a table named "Suppliers" where the value of the "CompanyName" column starts with "A"?
SELECT * FROM Suppliers WHERE CompanyName LIKE '%A';
SELECT * FROM Suppliers WHERE CompanyName = 'A';
SELECT * FROM Suppliers WHERE CompanyName IN ('A');
SELECT * FROM Suppliers WHERE CompanyName LIKE 'A%';
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for updating the value of the "City" column to "Seattle" for all records in a table named "Employees"?
UPDATE Employees SET 'Seattle' WHERE City;
UPDATE Employees SET City WHERE 'Seattle';
UPDATE Employees 'Seattle' WHERE City;
UPDATE Employees SET City = 'Seattle';
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for deleting all records from a table named "Students"?
DELETE Students WHERE Records=All;
TRUNCATE TABLE Students;
TRUNCATE Students;
DELETE FROM Students;
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
