Data Basics & MySQL Quiz

Test

Parties jouées 0

Créer une copie

À propos de cette activité

Fundamental data modeling and SQL concepts

Créé par

Hernán Schramm

Argentina

Téléchargez la version pour jouer sur papier

Top 10 résultats

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

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Data Basics & MySQL Quiz


Data Basics & MySQL QuizVersion en ligne Fundamental data modeling and SQL concepts par Hernán Schramm 1 What does ER in ER model stand for? a Entity-Relationship b Entity-Register c Event-Relation d Entity-Relation 2 In a relational table, what is a PRIMARY KEY? a A foreign key to another table b A column that can be NULL c A duplicate key for speed d A unique identifier for each row 3 What does 1NF require in a table? a There must be exactly one row per table b Keys can be NULL c Each cell contains a single value d Columns can hold multiple values 4 What is the purpose of a FOREIGN KEY? a Replicates data for speed b Stores computed values c Acts as a primary key too d References a primary key in another table 5 Difference between INNER JOIN and LEFT JOIN? a INNER JOIN excludes grouped data; LEFT JOIN groups it b INNER JOIN returns matching rows; LEFT JOIN includes all left-side rows c INNER JOIN returns all rows; LEFT JOIN returns none d INNER JOIN is slower than LEFT JOIN in all cases 6 What is 3NF about in normalization? a Removing all foreign keys b Eliminating transitive dependencies; use separate tables c Combining all tables into a single file d Musing about all fields in one table 7 Which data type is best for monetary values with decimals? a CHAR(10) b FLOAT c DECIMAL(p,s) d INT 8 What does AUTO_INCREMENT do in MySQL? a Enforces foreign key constraints only b Resets IDs on each insert c Requires manual input for IDs d Automatically assigns a unique id value 9 Which SQL command fetches data from tables with a join? a SELECT with a JOIN clause b ALTER TABLE to join data c DROP TABLE and rejoin later d CREATE TABLE with a JOIN 10 What is a data model used for in databases? a A plan describing how data is organized and related b A hardware diagram c A user interface layout d A programming language Feedback 1 ER models map real-world entities, their attributes, and how they relate. 2 PK uniquely identifies each record and is not NULL. 3 1NF eliminates multi-valued fields; each cell is atomic. 4 FK enforces referential integrity by linking tables. 5 INNER JOIN requires matches in both tables; LEFT JOIN keeps all left rows. 6 3NF reduces redundancy by separating dependent attributes. 7 DECIMAL provides fixed precision suitable for money. 8 AUTO_INCREMENT generates unique consecutive IDs. 9 Use SELECT ... FROM ... JOIN ... to retrieve joined data. 10 A data model outlines structure, entities, and relationships.

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Data Basics & MySQL Quiz

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Tissues - Practice Quiz

Test

Spanish Alphabet Listening

Test

UPS 5 Seeing Habits Quiz

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Data Basics & MySQL QuizVersion en ligne

par Hernán Schramm

What does ER in ER model stand for?

In a relational table, what is a PRIMARY KEY?

What does 1NF require in a table?

What is the purpose of a FOREIGN KEY?

Difference between INNER JOIN and LEFT JOIN?

What is 3NF about in normalization?

Which data type is best for monetary values with decimals?

What does AUTO_INCREMENT do in MySQL?

Which SQL command fetches data from tables with a join?

What is a data model used for in databases?

Feedback