Questions: Databases and SQL
Pick a question type. Each time you get new numbers. Free ones are marked free.
Relational databases and records
- Database wordsIdentify, 1 mark, free
- Records and fieldsState, 2 marks, free
- Choose a primary keyIdentify, 1 mark, free
- Primary and foreign keysIdentify, 2 marks, free
- Choose a data type for a fieldIdentify, 1 mark, free
- Redundancy and inconsistencyIdentify, 1 mark, free
- 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, free
- 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, free
- How many records match?State, 1 mark, free
- The size of a query resultState, 2 marks, free
- ORDER BY ASC and DESCWrite down, 2 marks, free
- SQL keywordsIdentify, 1 mark, free
- 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
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.