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

Froggy Jumps

Played 0

Create copy

About this activity

DB basics for Lower Sixth

Created by

YAKILI LMS

Cameroon

Download the paper version to play

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

The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(90)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
pizza

Lorelay Tyana

Romania

(262)

joc despre pizza
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(60)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.

		%
	Anonymous	%
		%
		%

Print your game

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


Froggy Jumps Collecting, Organizing, Storing & Securing Data Lowersixth Science Computer ScienceOnline version DB basics for Lower Sixth by 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

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

The Integumentary System

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

pizza

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

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

by 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?