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

Froggy Jumps

Jugadas 0

Crear copia

Sobre esta actividad

SQL basics, queries, subqueries, and project mgmt.

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
Sabiduría animal

Educaplay Educational Resources

España

(15351)

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

Melanie Rodriguez

Estados Unidos

(334)

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

(170)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(98)

Repasamos el vocabulario de la unidad

		%
	Anónimo	%
		%
		%

Imprime tu juego

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


Froggy Jumps Collecting,Organizing, Storing & Securing Data II Lowersixth Science Computer ScienceVersión en línea SQL basics, queries, subqueries, and project mgmt. por 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

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

El valle de los lobos

Froggy Jumps

Sabiduría animal

Froggy Jumps

Salva a la Ranita

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

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

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