SQL quizz

Quiz
•
Specialty
•
Professional Development
•
Easy
Mai Anh Nguyễn
Used 3+ times
FREE Resource
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
What is missing in this code?
SELECT * FROM WHERE genre = 'action' ORDER BY year ARC;
Table name
Capitalize action
Missing an AND
None of these
2.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
Match the following SQL term with a description - ORDER BY
The table used in the query
The criteria that must be met
The field and order used to sort the results
The fields to display
3.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
When examining a row in a table, we refer to it as a...
result
result number
row number
record
4.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
How do we select all rows for the "Designer" table?
SELECT Designer.*
SELECT [All] FROM Designer
SELECT FROM Designer
SELECT * FROM Designer
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
What does the SQL term 'JOIN' refer to?
Combining rows from two or more tables based on a related column between them
Sorting the results in ascending order
Filtering rows based on a condition
Grouping rows with the same value
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which SQL statement is used to delete a table?
REMOVE TABLE table_name;
DROP TABLE table_name;
DELETE TABLE table_name;
ERASE TABLE table_name;
7.
MULTIPLE CHOICE QUESTION
5 sec • 1 pt
What is the purpose of the SQL statement 'GROUP BY'?
To filter rows based on a condition
To sort the results in descending order
To group rows that have the same values into summary rows
To update existing records in a table
Create a free account and access millions of resources
Similar Resources on Wayground
14 questions
snow9

Quiz
•
Professional Development
12 questions
snow5

Quiz
•
Professional Development
13 questions
snow3

Quiz
•
Professional Development
10 questions
RARE ANIMALS

Quiz
•
5th Grade - Professio...
15 questions
Server exam Test 2

Quiz
•
Professional Development
12 questions
My Singing Monsters: Dawn of Fire Quiz

Quiz
•
KG - Professional Dev...
8 questions
FUNDAMENTOS BASE DATOS

Quiz
•
Professional Development
10 questions
Bones of the Skull

Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade