Database Normalization & Queries

Test

Parties jouées 0

Créer une copie

Test knowledge on normalization and SQL basics.

Dr. K Suneetha

India

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

Database Normalization & Queries


Database Normalization & QueriesVersion en ligne Test knowledge on normalization and SQL basics. par Dr. K Suneetha 1 What is the primary goal of database normalization? a Increase data redundancy b Eliminate data redundancy c Simplify hardware requirements d Improve query speed 2 Which normal form removes transitive dependencies? a BCNF b 1NF c 3NF d 4NF 3 In 1NF, data must be: a Composite b Atomic c Encrypted d Normalized 4 Which operation combines rows from two or more tables? a GROUP BY b JOIN c SELECT DISTINCT d ORDER BY 5 Which clause filters rows in SQL? a ORDER BY b GROUP BY c HAVING d WHERE 6 What does a primary key uniquely identify? a A column value b Each row in a table c The table name d The whole database 7 Which normal form ensures every determinant is a candidate key? a 3NF b 1NF c BCNF d 4NF 8 Which SQL clause sorts results? a ORDER BY b LIMIT c WHERE d GROUP BY 9 In SQL, which keyword creates a new table? a INSERT INTO b MAKE TABLE c BUILD TABLE d CREATE TABLE 10 Which normal form allows multi-valued dependencies? a 3NF b 2NF c BCNF d 4NF