SQL statements 1
Authored by Karen Tan
Computers
University
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
In the SQL SELECT statement below which keyword is responsible for selecting all records starting with a:
Select * from studtb WHERE surname LIKE 'a%';
SELECT
LIKE
WHERE
FROM
studtb
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SQL SELECT statement below which keyword is responsible for filtering records by surname
Select * from studtb WHERE surname LIKE 'a%';
SELECT
LIKE
WHERE
FROM
studtb
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SQL SELECT statement below which keyword is responsible for specifying the source of the data
Select * from studtb WHERE surname LIKE 'a%';
SELECT
LIKE
WHERE
FROM
studtb
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SQL SELECT statement below which what is the table name?
Select * from studtb WHERE surname LIKE 'a%';
SELECT
LIKE
WHERE
FROM
studtb
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SQL SELECT statement below what keyword is used to choose all records / specific records in the database?
Select * from studtb WHERE surname LIKE 'a%';
SELECT
LIKE
WHERE
FROM
studtb
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What keyword is responsible for allowing records within a specific range to be selected?
SELECT * FROM Students
WHERE Age BETWEEN 22 AND 25;
BETWEEN
AND
Students
Age
22, 25
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What keyword / operator is responsible for returning records only if both conditions are TRUE?
SELECT * FROM Students
WHERE Age BETWEEN 22 AND 25;
BETWEEN
AND
Students
Age
22, 25
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
Already have an account?
