Relational Databases and Sql | AQA GCSE Computer Science (8525)

Relational Databases and Sql

48 questions
3 subtopics
Paper 2
Paper 2

Relational Databases and SQL is examined in Paper 2, Computing concepts.

It covers relational databases and keys, SQL SELECT queries and SQL INSERT, UPDATE and DELETE.

Sample questions from Relational Databases and Sql

Answer each one closed book first, then open the answer.

Relational databases and keys

What is a data type in a database?

Show the answer
A data type sets what kind of value a field can hold. Common data types are integer, real, text, Boolean and date/time.
Relational databases and keys

What is data redundancy?

Show the answer
Data redundancy is the same data being stored more than once without need. Redundant copies waste storage space.
SQL SELECT queries

What does ORDER BY do in an SQL query, and what do ASC and DESC mean?

Show the answer
The ORDER BY clause sorts the results by a chosen field. ASC sorts in ascending order and DESC sorts in descending order.
SQL SELECT queries

A table Film has fields FilmID, Title, Year and Rating. What does SELECT Title FROM Film WHERE Year > 2010 AND Rating = 'PG' return?

Show the answer
The query returns the titles of PG films released after 2010. A film must meet both conditions to appear.
SQL INSERT, UPDATE and DELETE

What happens if an INSERT INTO command gives a new record the same primary key value as an existing record?

Show the answer
The database rejects the new record. A primary key value must be unique within its table.
SQL INSERT, UPDATE and DELETE

What does a DELETE FROM command do in SQL?

Show the answer
The DELETE FROM command removes the records that meet the WHERE condition. The table itself remains in the database.

The 3 subtopics

One subtopic is one session. Work down the list.

Subtopic	What it covers	Questions
Relational databases and keys	Databases, tables, records, fields and data types, primary and foreign keys, linked tables, and how a relational design removes data redundancy and inconsistency.	16
SQL SELECT queries	SELECT, FROM, WHERE and ORDER BY with ascending and descending sorts, worked queries on small tables, text in quotation marks, and queries that join two linked tables.	16
SQL INSERT, UPDATE and DELETE	Adding records with INSERT INTO, changing them with UPDATE and SET, removing them with DELETE FROM, worked commands on small tables, and the danger of a missing WHERE clause.	16

Relational Databases and Sql is 48 of the 664 questions in the guide.Get the guide, £7

How the guide is worked

Answering a question from memory stores it far better than reading the answer again. The guide runs that as a fixed procedure on one subtopic at a time, about twenty minutes a session.

Step 1 · Closed book
Cover the answers. Work through one subtopic and write down what you can. Leave blanks where you have nothing.
Step 2 · Open book
Go back to the top. Read each printed answer and write it out in full, including the ones you had right.
Step 3 · Closed book again
Same questions, same order, from memory. The gap between pass one and pass three is the session result.

Read the full method, the return schedule and the research behind it.