Structured Query Language
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Medium
Emily Argall
Used 2+ times
FREE Resource
Enhance your content in a minute
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
WHICH QUERY?
defines the list of fields to be displayed
SELECT
FROM
WHERE
ORDER BY
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
WHICH QUERY?
defines the list of tables the data will come from
SELECT
FROM
WHERE
ORDER BY
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
WHICH QUERY?
defines the list of search criteria
SELECT
FROM
WHERE
ORDER BY
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
WHICH QUERY?
defines the way in which the data will appear
e.g. ______ age DESC
SELECT
FROM
WHERE
ORDER BY
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which symbol can be used as a 'wild card' in sql?
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which query can be used to search for a pattern in the WHERE clause?
e.g. WHERE word _____ '%ing' to search for words ending in 'ing'
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
What are the two ways in which you can specify links between tables?
WHERE tblCustomer.custID = tblSubscription.custID
WHERE custID.tblSubscription = custID.tblCustomer
JOIN tblPlayer, tblTeam
ON teamID
JOIN tblPlayer
ON tblPlayer.teamID = tblTeam.teamID
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?
Similar Resources on Wayground
19 questions
Informatika Kelas 5 Bab 2
Quiz
•
5th Grade - University
20 questions
Ինֆորմատիկա 10 II կիսամյակի ամփոփիչ աշխատանք
Quiz
•
10th - 12th Grade
20 questions
Ms Excel Test
Quiz
•
1st - 12th Grade
20 questions
RDBMS
Quiz
•
10th - 12th Grade
23 questions
IT Fun Objective 5 - Database
Quiz
•
11th - 12th Grade
20 questions
Pengayaan Informatika
Quiz
•
12th Grade
20 questions
Data Quiz
Quiz
•
9th - 12th Grade
20 questions
Access Lesson 7
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
