Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer Science

Froggy Jumps

Jugadas 0

Crear copia

Sobre esta actividad

DB basics for Lower Sixth

Creada por

YAKILI LMS

Camerún

Descarga la versión para jugar en papel

Crea tu propio juego gratis desde nuestro creador de juegos

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto

El valle de los lobos

Marcos Signes

España

(107)

20 preguntas de este maravilloso libro
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(98)

Repasamos el vocabulario de la unidad
Sabiduría animal

Educaplay Educational Resources

España

(15387)

Conviértete en un genio del Reino Animal
Salva a la Ranita

Melanie Rodriguez

Estados Unidos

(336)

Contesta las siguientes multiplicaciones correctamente para salvar a la ranita y evitar que caiga al agua, mucha suerte!
Quiz de Culpa mía película

Yamila Chavez

Argentina

(171)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.

		%
	Anónimo	%
		%
		%

Imprime tu juego

Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer Science


Froggy Jumps Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer ScienceVersión en línea DB basics for Lower Sixth por YAKILI LMS 1 What command inserts a new row into a table in SQL? a INSERT INTO b ADD INTO c ADD ROW 2 Which clause filters rows in a SELECT query? a FILTER b WHERE c LIMIT 3 Which data type is best for whole numbers? a INT b VARCHAR c TEXT 4 Which keyword returns unique rows only? a UNIQUE b CHOOSE c DISTINCT 5 Which form element is used to submit data? a Reset button b Checkbox c Submit button 6 What is the purpose of a form in a database app? a Display images b Collect user input c Store data locally only 7 Which SQL command updates existing rows? a MODIFY b CHANGE c UPDATE 8 Which SQL clause sorts results? a SORT b ORDER BY c ARRANGE 9 What does a primary key ensure? a Row uniqueness b Data type c Column size 10 Which command deletes a table? a REMOVE TABLE b DROP TABLE c DELETE TABLE 11 Which operation creates a new table in a database? a CREATE TABLE b MAKE TABLE c BUILD TABLE 12 What is a foreign key? a Links to another table b Unique in the table c Encrypts data 13 Which statement is used to import data from a CSV? a LOAD DATA b IMPORT CSV c READ FILE 14 Which action exports a database to a file? a Copy b Back up c Export 15 Which form control is used for single-line text input? a Radio button b Text area c Text field 16 In a form, which control lets users pick a date? a Time picker b Calendar view c Date picker 17 Which SQL clause determines the number of rows? a ROWCOUNT b LIMIT c TIMELIMIT 18 Which data type is commonly used for names? a VARCHAR b INT c BOOLEAN 19 What is a database schema? a Structure of data b User roles c Data content 20 Which form element allows multiple selections? a Text field b Radio button c Checkbox group 21 What is normalization in databases? a Compressing files b Encrypting data c Organizing data to reduce redundancy 22 Which command drops a database? a DELETE DB b DROP DATABASE c ERASE DATABASE 23 Which statement creates a primary key constraint? a PRIMARY KEY b FOREIGN KEY c UNIQUE KEY 24 What is a view in SQL? a Virtual table b Procedure c Physical table 25 Which clause groups rows by a column? a GROUP BY b COLLECT c ORDER 26 Which function counts rows in a result set? a SUM() b COUNT() c TOTAL() 27 Which command adds a new column to a table? a UPDATE TABLE b CHANGE TABLE c ALTER TABLE ... ADD 28 What is a record in a database? a A table b A column c A row 29 Which key uniquely identifies a record in a table? a Foreign key b Candidate key c Primary key 30 What is a candidate key? a A potential primary key b An index c A foreign key 31 Which command creates an index? a INIT INDEX b CREATE INDEX c BUILD INDEX 32 Which clause filters grouped data? a LIMIT b HAVING c WHERE 33 Which clause filters after grouping? a WHERE b ORDER BY c HAVING 34 Which tool helps import/export databases in many RDBMS? a Spreadsheets b Emails c SQL scripts 35 What is an ER diagram used for? a Modeling entities and relations b Styling UI c Documenting code 36 Which form attribute ensures required input? a required b must c mandatory 37 Which join returns all records from left table? a INNER JOIN b RIGHT JOIN c LEFT JOIN 38 What does AUTOINCREMENT do? a Automatically increases a value b Deletes a row c Sets default value 39 Which SQL keyword selects unique cities? a SELECT City b SELECT UNIQUE City c SELECT DISTINCT City 40 Which form control groups options? a Text field b Radio buttons c Submit button 41 Which data type stores true/false? a BOOLEAN b VARCHAR c INT 42 Which constraint prevents duplicate emails? a CHECK b UNIQUE c PRIMARY 43 Which clause limits rows after sorting? a HALT b LIMIT c STOP 44 What is a composite key? a A foreign key b A key made of multiple columns c A single column key 45 Which file format is common for data import/export? a XML b CSV c BIN 46 Which SQL statement removes a row? a REMOVE b DELETE c DROP 47 Which form feature validates input before submit? a Client-side validation b Server-side validation c None 48 Which SQL function returns the maximum value? a AVG() b MIN() c MAX() 49 Which operation copies data to another table? a MOVE b COPY c INSERT INTO ... SELECT 50 What is a foreign key constraint? a Indexes data b Encrypts data c Maintains referential integrity

Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer Science

Froggy Jumps

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

El valle de los lobos

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

Sabiduría animal

Froggy Jumps

Salva a la Ranita

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer ScienceVersión en línea

por YAKILI LMS

What command inserts a new row into a table in SQL?

Which clause filters rows in a SELECT query?

Which data type is best for whole numbers?

Which keyword returns unique rows only?

Which form element is used to submit data?

What is the purpose of a form in a database app?

Which SQL command updates existing rows?

Which SQL clause sorts results?

What does a primary key ensure?

Which command deletes a table?

Which operation creates a new table in a database?

What is a foreign key?

Which statement is used to import data from a CSV?

Which action exports a database to a file?

Which form control is used for single-line text input?

In a form, which control lets users pick a date?

Which SQL clause determines the number of rows?

Which data type is commonly used for names?

What is a database schema?

Which form element allows multiple selections?

What is normalization in databases?

Which command drops a database?

Which statement creates a primary key constraint?

What is a view in SQL?

Which clause groups rows by a column?

Which function counts rows in a result set?

Which command adds a new column to a table?

What is a record in a database?

Which key uniquely identifies a record in a table?

What is a candidate key?

Which command creates an index?

Which clause filters grouped data?

Which clause filters after grouping?

Which tool helps import/export databases in many RDBMS?

What is an ER diagram used for?

Which form attribute ensures required input?

Which join returns all records from left table?

What does AUTOINCREMENT do?

Which SQL keyword selects unique cities?

Which form control groups options?

Which data type stores true/false?

Which constraint prevents duplicate emails?

Which clause limits rows after sorting?

What is a composite key?

Which file format is common for data import/export?

Which SQL statement removes a row?

Which form feature validates input before submit?

Which SQL function returns the maximum value?

Which operation copies data to another table?

What is a foreign key constraint?