Quiz: Basic SQL Quiz


Basic SQL QuizOnline version Essential SQL basics by 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.

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.

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Basic SQL Quiz

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Spanish Alphabet Listening

Quiz

Tissues - Practice Quiz

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

UPS 5 Seeing Habits Quiz

Basic SQL QuizOnline version

by 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

		%
	Anonymous	%
		%
		%