sql
Authored by C Romer
Computers
6th - 9th Grade
Used 31+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does SQL stand for?
Standard Query Language
Sequential Query Language
Structured Question Language
Structured Query Language
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Match the following SQL term with a description - FROM
The criteria which must be met
The fields to display
The field and order used to sort the results
The table used in the query
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In what order does SQL process the instructions?
FROM - SELECT - WHERE - ORDER BY
WHERE - FROM - SELECT - ORDER BY
SELECT - FROM - WHERE - ORDER BY
SELECT - FROM - ORDER By - WHERE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which statement is used to extract data from a database?
Extract
Get
Open
Select
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Less than or equal to?
>=
=>
=<
<=
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A primary key can be NULL in the table? TRUE or FALSE
TRUE
FALSE
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?
