SQL 1
Authored by O Hawkridge
Computers
11th Grade
Used 15+ 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 SELECT QUESTION
1 min • 1 pt
Which of the following are components of an SQL statement? (PICK 3)
SELECT
FROM
WHERE
PROJECT
CARTESIAN PRODUCT
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What does SQL stand for?
Sample Query Language
Sequential Query Language
Sample Query Language
Structured Query Language
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
Select * from Persons where FirstName = "Peter"
Select [all] from Persons where FirstName = "Peter"
Select * from Persons where FirstName <> "Peter"
Select [all] from Persons where FirstName Like "Peter"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the * character?
E.g., SELECT *
FROM celebs;
It selects new values in the table.
It only selects fields where values are not empty in the table.
It selects the leftmost field in the table.
It selects every field in the table.
Answer explanation
Correct! It allows us to select every column in a table without having to name each one individually.
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which statement is used to extract the table from a database?
Extract
Get
Open
Select
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you were wanting to filter data, which clause would you use?
Where
Order by
From
Select
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Using which word allows you to specify that more than one condition must be met in a query?
Also
And
Or
Where
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?
