DBMS Essentials Quiz

Quiz

Played 0

Create copy

About this activity

Test basic DBMS concepts and SQL basics.

Created by

Revathy P

United States

Download the paper version to play

Top 10 results

There are still no results for this game. Be the first to stay in the ranking! 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

Spanish Alphabet Listening

Falkenberg Falkenberg

United States

(88)

Spanish alphabet, listening-based assessment
Photosynthesis vs Cellular Respiration - Practice Quiz

Benjamin D Morgan

United States

(39)

Photosynthesis vs Cellular Respiration - Practice Quiz
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


DBMS Essentials QuizOnline version Test basic DBMS concepts and SQL basics. by Revathy P 1 What uniquely identifies a row in a table? a Primary Key b Index c Foreign Key d Unique Constraint 2 Which key links two tables in a relational database? a Candidate Key b Superkey c Primary Key d Foreign Key 3 Which constraint ensures no duplicate values in a column? a Check b Primary Key c Foreign Key d Unique 4 Which SQL clause filters rows before grouping? a ORDER BY b HAVING c GROUP BY d WHERE 5 Which join returns all rows from left table and matches from right? a Left Join b Inner Join c Full Join d Right Join 6 Which SQL function counts rows in a group? a AVG() b MAX() c SUM() d COUNT() 7 Which keyword is used to remove duplicates in results? a NO_DUP b DISTINCT c UNIQUE d SELECTED 8 What does the GROUP BY clause do? a Aggregates rows by column values b Sorts results c Creates a new table d Deletes rows 9 Which SQL statement retrieves data from a table? a UPDATE b SELECT c DELETE d INSERT 10 Which built-in function returns the average value of a column? a SUM() b COUNT() c MAX() d AVG()

DBMS Essentials QuizOnline version

Test basic DBMS concepts and SQL basics.

by Revathy P

What uniquely identifies a row in a table?

Primary Key

Index

Foreign Key

Unique Constraint

Which key links two tables in a relational database?

Candidate Key

Superkey

Primary Key

Foreign Key

Which constraint ensures no duplicate values in a column?

Check

Primary Key

Foreign Key

Unique

Which SQL clause filters rows before grouping?

ORDER BY

HAVING

GROUP BY

WHERE

Which join returns all rows from left table and matches from right?

Left Join

Inner Join

Full Join

Right Join

Which SQL function counts rows in a group?

AVG()

MAX()

SUM()

COUNT()

Which keyword is used to remove duplicates in results?

NO_DUP

DISTINCT

UNIQUE

SELECTED

What does the GROUP BY clause do?

Aggregates rows by column values

Sorts results

Creates a new table

Deletes rows

Which SQL statement retrieves data from a table?

UPDATE

SELECT

DELETE

INSERT

Which built-in function returns the average value of a column?

SUM()

COUNT()

MAX()

AVG()

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 Essentials Quiz

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Spanish Alphabet Listening

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

UPS 5 Seeing Habits Quiz

Quiz

Tissues - Practice Quiz

DBMS Essentials QuizOnline version

by Revathy P

What uniquely identifies a row in a table?

Which key links two tables in a relational database?

Which constraint ensures no duplicate values in a column?

Which SQL clause filters rows before grouping?

Which join returns all rows from left table and matches from right?

Which SQL function counts rows in a group?

Which keyword is used to remove duplicates in results?

What does the GROUP BY clause do?

Which SQL statement retrieves data from a table?

Which built-in function returns the average value of a column?

		%
	Anonymous	%
		%
		%