DBMS Constraints & Aggregates Quiz

Froggy Jumps

(1)

Played 15

Create copy

About this activity

DBMS constraints & aggregates

Created by

Pratikesh Devarasetty

India

Download the paper version to play

Top 10 results

#	Player	Accuracy	time
1	Pratikesh Devarasetty April 16, 2026	% 100	01:15
2	Krish D Shah April 17, 2026	% 100	02:46

Do you want to stay in the Top 10 of this game? Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
pizza

Lorelay Tyana

Romania

(259)

joc despre pizza
The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(89)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.


Froggy Jumps DBMS Constraints & Aggregates QuizOnline version DBMS constraints & aggregates by Pratikesh Devarasetty 1 Which constraint uniquely identifies each row in a table and cannot be NULL? a FOREIGN KEY b PRIMARY KEY c UNIQUE 2 Which constraint uniquely identifies each row in a table and cannot be NULL? a FOREIGN KEY b PRIMARY KEY c UNIQUE 3 Which constraint uniquely identifies each row in a table and cannot be NULL? a FOREIGN KEY b PRIMARY KEY c UNIQUE 4 Which is TRUE about FOREIGN KEY? a It must always be UNIQUE b It automatically creates indexes c It can contain NULL values 5 Which constraint prevents duplicate values in a column, not considering NULLs? a NOT NULL b CHECK c UNIQUE 6 Which constraint defines a condition that must be true for all rows? a FOREIGN KEY b CHECK c DEFAULT 7 Which scenario causes AVG(column) to return NULL a Column has one NULL value b Column has only NULL values c Column has 0 and NULL values 8 Which aggregate function counts rows, ignoring NULLs by default? a SUM b MAX c COUNT 9 Which aggregate function gives the average value of a numeric column? a MIN b AVG c SUM 10 Which expression is always equivalent to AVG(column)? a SUM(column) / COUNT(*) b SUM(column) / COUNT(column) c SUM(column) / COUNT(DISTINCT column) 11 Which constraint combination is equivalent to a PRIMARY KEY a UNIQUE + DEFAULT b CHECK + NOT NULL c UNIQUE + NOT NULL 12 Which clause groups rows for aggregate calculations, often with HAVING for filters? a ORDER BY b GROUP BY c WHERE

Froggy Jumps

DBMS Constraints & Aggregates QuizOnline version

DBMS constraints & aggregates

by Pratikesh Devarasetty

Which constraint uniquely identifies each row in a table and cannot be NULL?

FOREIGN KEY

PRIMARY KEY

UNIQUE

Which constraint uniquely identifies each row in a table and cannot be NULL?

FOREIGN KEY

PRIMARY KEY

UNIQUE

Which constraint uniquely identifies each row in a table and cannot be NULL?

FOREIGN KEY

PRIMARY KEY

UNIQUE

Which is TRUE about FOREIGN KEY?

It must always be UNIQUE

It automatically creates indexes

It can contain NULL values

Which constraint prevents duplicate values in a column, not considering NULLs?

NOT NULL

CHECK

UNIQUE

Which constraint defines a condition that must be true for all rows?

FOREIGN KEY

CHECK

DEFAULT

Which scenario causes AVG(column) to return NULL

Column has one NULL value

Column has only NULL values

Column has 0 and NULL values

Which aggregate function counts rows, ignoring NULLs by default?

SUM

MAX

COUNT

Which aggregate function gives the average value of a numeric column?

MIN

AVG

SUM

Which expression is always equivalent to AVG(column)?

SUM(column) / COUNT(*)

SUM(column) / COUNT(column)

SUM(column) / COUNT(DISTINCT column)

Which constraint combination is equivalent to a PRIMARY KEY

UNIQUE + DEFAULT

CHECK + NOT NULL

UNIQUE + NOT NULL

Which clause groups rows for aggregate calculations, often with HAVING for filters?

ORDER BY

GROUP BY

WHERE

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.

DBMS Constraints & Aggregates Quiz

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

DBMS Constraints & Aggregates QuizOnline version

by Pratikesh Devarasetty

Which constraint uniquely identifies each row in a table and cannot be NULL?

Which constraint uniquely identifies each row in a table and cannot be NULL?

Which constraint uniquely identifies each row in a table and cannot be NULL?

Which is TRUE about FOREIGN KEY?

Which constraint prevents duplicate values in a column, not considering NULLs?

Which constraint defines a condition that must be true for all rows?

Which scenario causes AVG(column) to return NULL

Which aggregate function counts rows, ignoring NULLs by default?

Which aggregate function gives the average value of a numeric column?

Which expression is always equivalent to AVG(column)?

Which constraint combination is equivalent to a PRIMARY KEY

Which clause groups rows for aggregate calculations, often with HAVING for filters?

		%
	Anonymous	%
		%
		%