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

Froggy Jumps

Played 0

Create copy

About this activity

SQL basics, queries, subqueries, and project mgmt.

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
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
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

(261)

joc despre pizza
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 II Lowersixth Science Computer Science


Froggy Jumps Collecting,Organizing, Storing & Securing Data II Lowersixth Science Computer ScienceOnline version SQL basics, queries, subqueries, and project mgmt. by YAKILI LMS 1 Which SQL statement adds a new row to a table? a INSERT b UPDATE c DELETE 2 Which clause filters rows in a SELECT statement? a SORT b WHERE c GROUP BY 3 Which SQL statement creates a new table? a ADD TABLE b CREATE TABLE c NEW TABLE 4 Which keyword specifies a unique value in a column? a UNIQUE b DISTINCTS c DIFFERENT 5 Which clause sorts results by one or more columns? a ORDER BY b GROUP BY c SORT BY 6 Which function counts rows in a result set? a TOTAL() b COUNT() c SUM() 7 What is the primary purpose of SQL? a Design hardware b Manage relational data c Program UI 8 Which operator compares values for equality? a = b != c <> 9 Which statement changes data in existing rows? a MODIFY b UPDATE c CHANGE 10 Which statement deletes rows from a table? a DELETE b DROP c REMOVE 11 What does a SELECT ... FROM ... WHERE do? a Retrieve filtered data b Modify schema c Insert data 12 Which join type returns all rows from both tables? a CROSS JOIN b INNER JOIN c FULL OUTER JOIN 13 Which subquery returns a single value for comparison? a Inline subquery b Scalar subquery c Correlated subquery 14 Which clause groups rows for aggregate functions? a HAVING b ORDER BY c GROUP BY 15 Which clause filters groups after aggregation? a HAVING b GROUP BY c WHERE 16 Which statement creates or alters a table's structure? a CHANGE TABLE b MODIFY TABLE c ALTER TABLE 17 Which command removes a table from the database? a DROP TABLE b REMOVE TABLE c DELETE TABLE 18 What keyword introduces a subquery in WHERE? a WITH b SELECT c SUBQUERY 19 Which operation combines rows from two queries with UNION? a UNION b MERGE c JOIN 20 Which SQL statement adds a column to a table? a INSERT COLUMN b APPEND COLUMN c ALTER TABLE ADD COLUMN 21 Which keyword creates a new user-defined view? a CREATE VIEW b BUILD VIEW c MAKE VIEW 22 Which constraint ensures a value is not NULL? a NOT NULL b DISALLOW c NULLABLE 23 What does a primary key uniquely identify? a Each row in a table b Each column c The database 24 Which statement grants permissions in SQL? a ALLOW b PERMIT c GRANT 25 Which data type stores fixed-length strings? a CHAR b TEXT c VARCHAR 26 Which data type stores variable-length strings? a STRING b VARCHAR c CHAR 27 Which data type stores numeric values with decimals? a BOOLEAN b DECIMAL c INT 28 What is the purpose of a foreign key? a Store procedures b Index data c Link tables 29 Which statement returns the structure of a table? a DESCRIBE TABLE b SHOW STRUCTURE c EXPLAIN TABLE 30 Which clause limits rows returned by a query? a LIMIT b RESTRICT c TOP 31 What is a transaction in SQL? a Atomic unit of work b Query batch c Background job 32 Which command ends a transaction and saves changes? a COMMIT b APPLY c SAVE 33 Which command undoes a transaction? a REVERT b ROLLBACK c UNDO 34 Which clause includes computed results in a query? a LIKE b FROM c AS 35 Which operator checks a value within a set? a ANY b IN c EXISTS 36 Which operator checks a range with two bounds? a WITHIN b RANGE c BETWEEN 37 Which keyword creates a temporary table for a query? a AS_TEMP b WITH c TEMP 38 What is a correlated subquery? a Subquery referencing outer query b Inline view c Independent subquery 39 Which SQL feature supports data integrity across tables? a Constraints b Indexes c Triggers 40 Which statement creates a new index? a ADD INDEX b BUILD INDEX c CREATE INDEX 41 What is a common use of triggers? a Improve speed b Store data c Automate responses to events 42 Which project management activity aligns scope, time, cost? a Programming b Launching c Planning 43 Which artifact defines DB project tasks and milestones? a Project plan b Diagram c Codebase 44 Which role approves project deliverables? a Developer b Tester c Project sponsor 45 Which diagram helps model database structure? a Flowchart b ER diagram c UML class 46 Which method tracks SQL defects during project? a Change log b Issue log c Bug book 47 Which practice improves SQL performance? a Indexing b Redundancy c Medianing 48 Which test validates data retrieval results? a Unit test b Load test c Data validation 49 Which metric measures project progress? a Earned value b Throughput c Load factor 50 Which SQL clause can produce duplicates removal? a SELECT DISTINCT b SELECT UNIQUE c SELECT SEPARATE

Collecting,Organizing, Storing & Securing Data II 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

Phlebotomy Order of Draw Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

pizza

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

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

by YAKILI LMS

Which SQL statement adds a new row to a table?

Which clause filters rows in a SELECT statement?

Which SQL statement creates a new table?

Which keyword specifies a unique value in a column?

Which clause sorts results by one or more columns?

Which function counts rows in a result set?

What is the primary purpose of SQL?

Which operator compares values for equality?

Which statement changes data in existing rows?

Which statement deletes rows from a table?

What does a SELECT ... FROM ... WHERE do?

Which join type returns all rows from both tables?

Which subquery returns a single value for comparison?

Which clause groups rows for aggregate functions?

Which clause filters groups after aggregation?

Which statement creates or alters a table's structure?

Which command removes a table from the database?

What keyword introduces a subquery in WHERE?

Which operation combines rows from two queries with UNION?

Which SQL statement adds a column to a table?

Which keyword creates a new user-defined view?

Which constraint ensures a value is not NULL?

What does a primary key uniquely identify?

Which statement grants permissions in SQL?

Which data type stores fixed-length strings?

Which data type stores variable-length strings?

Which data type stores numeric values with decimals?

What is the purpose of a foreign key?

Which statement returns the structure of a table?

Which clause limits rows returned by a query?

What is a transaction in SQL?

Which command ends a transaction and saves changes?

Which command undoes a transaction?

Which clause includes computed results in a query?

Which operator checks a value within a set?

Which operator checks a range with two bounds?

Which keyword creates a temporary table for a query?

What is a correlated subquery?

Which SQL feature supports data integrity across tables?

Which statement creates a new index?

What is a common use of triggers?

Which project management activity aligns scope, time, cost?

Which artifact defines DB project tasks and milestones?

Which role approves project deliverables?

Which diagram helps model database structure?

Which method tracks SQL defects during project?

Which practice improves SQL performance?

Which test validates data retrieval results?

Which metric measures project progress?

Which SQL clause can produce duplicates removal?