DBMS Essentials Quiz

Test

Parties jouées 0

Créer une copie

Test basic DBMS concepts and SQL basics.

Revathy P

United States

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

Imprimez votre jeu

DBMS Essentials Quiz


DBMS Essentials QuizVersion en ligne Test basic DBMS concepts and SQL basics. par 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()