GCSE J277 - 2.2.3 - SQL
Authored by Paul Greenwood
Computers
7th Grade
Used 239+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these is NOT a valid clause (part) of a SQL statement
SELECT
FROM
WHERE
TABLE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct order for these keywords in a SQL statement
SELECT, WHERE, FROM
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM, SELECT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choosing which fields of data are retrieved is done in which part of the statement
SELECT
FROM
WHERE
ORDER BY
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choosing the criteria for which data is retrieved is done in which part of the statement
SELECT
FROM
WHERE
ORDER BY
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choosing the table data is extracted from is done in which part of the statement
SELECT
FROM
WHERE
ORDER BY
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these wildcards would retrieve ALL fields (Columns) from a table
!
ALL
*
@
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these statements would retrieve everyone with the name "Jim"
SELECT * FROM users WHERE name = "Jim"
SELECT * FROM users WHERE name = Jim
SELECT * FROM users WHERE name == "Jim"
SELECT * FROM users WHERE name == Jim
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?
