Exam tips

EXAM TIP: Past exams show that it is unlikely you will be asked to create a table in the exam, however you need to know how to do it before you learn all of the other statements that you will need in the exam. 

Creating a table is the first step. You need to CREATE a table before you can SELECT from it!  

The CREATE TABLE statement is not a part of the AQA Specification 

EXAM TIP: INSERT INTO is certainly one of the more simpler statements. There is not much space for ambiguity really. Make sure you learn it, as it is a part of the AQA spec.  

EXAM TIP: It is highly likely that you will need to write an advanced SELECT statement (to join two tables, at the most).

SELECT statements are defined on the AQA Specification.  It also explicitely states that "Exam questions will require that data is extracted from no more than two tables for any one query. ". 

Learn how to write this SQL statement thoroughly!! This is where you will get most of your marks for this unit.

EXAM TIP: UPDATE. 

The UPDATE statement is a part of the AQA Specification. 

EXAM TIP: DELETE FROM is certainly one of the more simpler statements. 

The DELETE FROM statement is a part of the AQA Specification. 

EXAM TIP: Past exams show that it is unlikely you will be asked to alter a table in the exam.

The ALTER TABLE statement is not a part of the AQA Specification 

EXAM TIP: Past exams show that it is unlikely you will be asked to drop a table in the exam.

The DROP TABLE statement is not a part of the AQA Specification 

EXAM TIP: You will need to learn the key terms. Click the button below to practice learning these.

EXAM TIP: You will need to learn the key terms & core concepts. Click the buttons below to practice learning these.