Grade 10 · Computing
This quiz helps revise “Databases and SQL” in Computing for grade 10. It has 25 questions in five categories: Database Structure, Reading Data, Filtering Data, Changing Data, Links and Summaries. Questions get harder as the points go up, from 100 to 500.
The 100- and 200-point questions are open here. The rest show only their first words, and there are no answers: all of that is in the game itself.
What is a vertical field in a relation that stores one named property across many records called?
Which common SQL data type is used for whole numbers?
Which common SQL data…
In the gameWhich constraint uniquely identifies…
In the gameWhich constraint links a…
In the game
Which keyword begins a query that returns chosen fields?
Which symbol in a query's result list requests every field?
Which keyword removes duplicate…
In the gameWhich clause arranges query…
In the gameWhich keyword makes sorting…
In the gameWhich clause keeps only records for which a condition is true?
Which comparison operator tests whether two expressions have exactly the same value?
Which SQL operator checks…
In the gameWhich operator tests whether…
In the gameWhich SQL test checks…
In the gameWhich statement adds new records to an existing relation?
Which statement changes field values in existing records?
Which statement removes records…
In the gameWhich statement creates a…
In the gameWhich statement changes the…
In the game
Which aggregate function returns the number of records in a set?
Which aggregate function returns the arithmetic mean of numeric values?
Which operation combines matching…
In the gameWhich clause partitions records…
In the gameWhich clause filters aggregated…
In the gameAll 25 questions and the answers are in the game. Invite your class or friends with a link — guests need no account.