Basic SQL Quiz

Test

Parties jouées 2

Créer une copie

À propos de cette activité

Essential SQL basics

Créé par

Cebin Alex Panicker

India

Téléchargez la version pour jouer sur papier

Top 10 résultats

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! 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

Practice Quiz - Punnett Square, Variation, and Mutations

Benjamin D Morgan

United States

(14)

Practice Quiz - Punnett Square, Variation, and Mutations
UPS 5 Seeing Habits Quiz

Heather Bell

United States

(12)

Test your knowledge about the 5 seeing habits discussed in the text 'UPS 5 seeing habits'.
Tissues - Practice Quiz

Benjamin D Morgan

United States

(16)

Tissues - Practice Quiz
Photosynthesis vs Cellular Respiration - Practice Quiz

Benjamin D Morgan

United States

(39)

Photosynthesis vs Cellular Respiration - Practice Quiz
Spanish Alphabet Listening

Falkenberg Falkenberg

United States

(87)

Spanish alphabet, listening-based assessment

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Basic SQL Quiz


Basic SQL QuizVersion en ligne Essential SQL basics par Cebin Alex Panicker 1 Which SQL statement selects data from a table named employees? a SHOW employees; b FETCH ALL FROM employees; c SELECT * FROM employees; d GET * FROM employees; 2 Which clause filters rows in a query? a GROUP BY b HAVING c ORDER BY d WHERE 3 Which keyword removes duplicate rows in a result set? a FILTER b ALLOW DISTINCT c DISTINCT d UNIQUE 4 Which clause sorts results by a column? a GROUP BY b FILTER BY c ARRANGE BY d ORDER BY 5 Which function counts rows in a group? a TOTAL() b COUNT() c AVG() d SUM() 6 Which statement creates a new table? a ADD TABLE b MAKE TABLE c BUILD TABLE d CREATE TABLE 7 What does the JOIN clause do? a Creates a new table b Filters columns only c Deletes rows from a table d Combines rows from two tables 8 Which operator tests for a pattern in strings? a LIKE b MATCH c CONTAINS d REGEXP 9 Which clause filters groups after GROUP BY? a WHERE b LIMIT c ORDER BY d HAVING 10 Which clause limits the number of returned rows? a LIMIT b CAP c TOP d ROW LIMIT Feedback 1 SELECT retrieves data; FROM specifies the table. 2 WHERE restricts rows by a condition. 3 DISTINCT eliminates duplicates in results. 4 ORDER BY sorts the output by column values. 5 COUNT() returns the number of rows. 6 CREATE TABLE defines a new table structure. 7 JOIN merges related data from two tables. 8 LIKE with % wildcards matches patterns. 9 HAVING applies conditions to grouped results. 10 LIMIT restricts the result size in many SQL dialects.

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.

Basic SQL Quiz

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

UPS 5 Seeing Habits Quiz

Test

Tissues - Practice Quiz

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Spanish Alphabet Listening

Basic SQL QuizVersion en ligne

par Cebin Alex Panicker

Which SQL statement selects data from a table named employees?

Which clause filters rows in a query?

Which keyword removes duplicate rows in a result set?

Which clause sorts results by a column?

Which function counts rows in a group?

Which statement creates a new table?

What does the JOIN clause do?

Which operator tests for a pattern in strings?

Which clause filters groups after GROUP BY?

Which clause limits the number of returned rows?

Feedback