SQL SELECT Essentials Quiz

Froggy Jumps

Parties jouées 4 %Précision 45 Temps moyen 01:51

Créer une copie

À propos de cette activité

Test your SQL SELECT knowledge.

Créé par

Teresa

United Kingdom

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	Teresa 20 Février 2026	% 55	02:20

Voulez-vous apparaître dans le Top 10 de ce jeu? Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

SQL SELECT Essentials Quiz


Froggy Jumps SQL SELECT Essentials QuizVersion en ligne Test your SQL SELECT knowledge. par Teresa 1 Which clause lists the columns to return in a SELECT statement? a WHERE list b FROM list c SELECT list 2 Which keyword returns only distinct values from a column? a SELECT DISTINCT b SELECT SEPARATE c SELECT UNIQUE 3 Which clause limits rows to a subset based on a condition? a FILTER b HAVING c WHERE 4 Which clause sorts the result set by one or more columns? a SORT b ORDER BY c GROUP BY 5 Which operator pattern uses % to match multiple characters in LIKE? a % b _ c ~ 6 Which keyword returns the first N rows of a query (depending on DB)? a SELECT TOP b SELECT FIRST c SELECT LIMIT 7 Which operator selects records matching any of several values in IN? a ANY (value1, value2) b IN (value1, value2, ...) c MATCH (value1, value2) 8 Which operator filters a range of values inclusively? a RANGE b INSIDE c BETWEEN 9 Which clause can combine multiple conditions with AND/OR and parentheses? a JOIN b HAVING c WHERE 10 What is the purpose of the SELECT statement in SQL Server? a To modify data in a table b To define a database schema c To retrieve data from one or more tables 11 Which clause lists the columns to return in a SELECT? a WHERE list b SELECT list c FROM list 12 What does SELECT * FROM table do? a Returns all columns from the table b Deletes all rows in the table c Returns only the first column 13 Which keyword returns only distinct values? a SELECT UNIQUE b SELECT DISTINCT c SELECT DIFFERENT 14 Which clause limits returned rows with a condition? a GROUP BY b HAVING c WHERE 15 Which operator sorts results in descending order by default? a ORDER BY with DESC b ORDER BY ASC c SORT DESC 16 What does the TOP clause do in SELECT? a Deletes top rows b Limits the number or percent of rows returned c Creates a new table of top rows 17 Which operators combine conditions with AND/OR? a Bitwise operators b Logical operators c Arithmetic operators 18 Which clause filters groups after GROUP BY? a HAVING b ORDER BY c WHERE 19 Which pattern-matching operator searches for a text pattern? a MATCH b COMPARE c LIKE

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

SQL SELECT Essentials Quiz

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

SQL SELECT Essentials QuizVersion en ligne

par Teresa

Which clause lists the columns to return in a SELECT statement?

Which keyword returns only distinct values from a column?

Which clause limits rows to a subset based on a condition?

Which clause sorts the result set by one or more columns?

Which operator pattern uses % to match multiple characters in LIKE?

Which keyword returns the first N rows of a query (depending on DB)?

Which operator selects records matching any of several values in IN?

Which operator filters a range of values inclusively?

Which clause can combine multiple conditions with AND/OR and parentheses?

What is the purpose of the SELECT statement in SQL Server?

Which clause lists the columns to return in a SELECT?

What does SELECT * FROM table do?

Which keyword returns only distinct values?

Which clause limits returned rows with a condition?

Which operator sorts results in descending order by default?

What does the TOP clause do in SELECT?

Which operators combine conditions with AND/OR?

Which clause filters groups after GROUP BY?

Which pattern-matching operator searches for a text pattern?