Questions: Databases and SQL
New numbers every time.
Relational databases and records
- Database wordsIdentify, 1 mark, Plus
- Records and fieldsState, 2 marks, Plus
- Choose a primary keyIdentify, 1 mark, Plus
- Primary and foreign keysIdentify, 2 marks, Plus
- Choose a data type for a fieldIdentify, 1 mark, Plus
- Redundancy and inconsistencyIdentify, 1 mark, Plus
- Repeated data and updatesState, 2 marks, Plus
- Spot inconsistent dataIdentify, 1 mark, Plus
- Splitting a table to remove redundancyIdentify, 1 mark, Plus
- A table held in a 2D arrayState, 1 mark, Plus
- Searching records in a 2D arrayState, 2 marks, Plus
- Find a record in a 2D arrayState, 1 mark, Plus
- Adding up a field in a 2D arrayCalculate, 2 marks, Plus
- The record with the highest valueState, 2 marks, Plus
- Records and 2D arraysIdentify, 1 mark, Plus
- Explain the benefits of a relational databaseExplain, 4 marks, Plus
SQL queries
- SELECT with WHEREWrite down, 2 marks, Plus
- How many records match?State, 1 mark, Plus
- The size of a query resultState, 2 marks, Plus
- ORDER BY ASC and DESCWrite down, 2 marks, Plus
- SQL keywordsIdentify, 1 mark, Plus
- LIKE and wildcards: how many?State, 1 mark, Plus
- LIKE and wildcards: which records?Write down, 2 marks, Plus
- Choose the right queryIdentify, 1 mark, Plus
- Complete a queryComplete, 1 mark, Plus
- A range of valuesState, 1 mark, Plus
- Not equal toState, 1 mark, Plus
- A query over two tablesWrite down, 2 marks, Plus
- Counting over two tablesState, 1 mark, Plus
- Looking up a linked recordWrite down, 1 mark, Plus
- WildcardsIdentify, 1 mark, Plus
- Write an SQL queryWrite, 3 marks, Plus
Changing data and files
- INSERT INTOState, 2 marks, Plus
- A correct INSERT statementIdentify, 1 mark, Plus
- UPDATEState, 2 marks, Plus
- The table after an UPDATEComplete, 2 marks, Plus
- DELETEState, 1 mark, Plus
- What is left after DELETE?Write down, 2 marks, Plus
- Changing data with SQLIdentify, 1 mark, Plus
- Which SQL command?Identify, 1 mark, Plus
- Reading and writing filesIdentify, 1 mark, Plus
- Read, write or append?Identify, 1 mark, Plus
- Records and fields in a CSV fileState, 2 marks, Plus
- Processing a CSV fileCalculate, 2 marks, Plus
- Picking records from a CSV fileWrite down, 2 marks, Plus
- Building lines for a CSV fileWrite down, 1 mark, Plus
- A file or a database? (6 marks)Discuss, 6 marks, Plus
Writing SQL
- Every field of one recordWrite, 1 mark, Plus
- SELECT fields WHERE text matchesWrite, 2 marks, Plus
- WHERE with a comparisonWrite, 2 marks, Plus
- Two conditions with ANDWrite, 3 marks, Plus
- Either of two values with ORWrite, 3 marks, Plus
- LIKE with a wildcardWrite, 2 marks, Plus
- WHERE and ORDER BYWrite, 3 marks, Plus
- A query over two linked tablesWrite, 4 marks, Plus
- INSERT INTOWrite, 2 marks, Plus
- UPDATE one recordWrite, 3 marks, Plus
- UPDATE with a calculationWrite, 3 marks, Plus
- DELETE FROMWrite, 2 marks, Plus
- Change the data, then query itWrite, 5 marks, Plus
- Writing SQLIdentify, 1 mark, Plus
AQA, Pearson Edexcel and OCR are registered trade marks of their owners. Brainlag Learn is independent: it is not affiliated with or endorsed by any exam board, and every question on it is original.