Data Definition Language (DDL) and Data Manipulation Language (DML)

Show understanding that the DBMS carries out all creation/modification of the database structure using its Data Definition Language (DDL)

Show understanding that the DBMS carries out all queries and maintenance of data using its DML

Show understanding that the industry standard for both DDL and DML is Structured Query Language (SQL)

9618_s23_qp_12_sc_2.c.iii

9618_s23_qp_12_sc_2.c.iii Question Image

Answer

9618_s23_qp_12_sc_2.c.iii Mark Scheme Image

Understand given SQL (DDL) statements and be able to write simple SQL (DDL) statements using a sub-set of statements

9618_w25_qp_13_sc_5.b

9618_w25_qp_13_sc_5.b Question Image

Answer

9618_w25_qp_13_sc_5.b Mark Scheme Image

9618_w25_qp_12_sc_4.b

9618_w25_qp_12_sc_4.b Question Image

Answer

9618_w25_qp_12_sc_4.b Mark Scheme Image

9618_w24_qp_13_sc_4.c.i

9618_w24_qp_13_sc_4.c.i Question Image

Answer

9618_w24_qp_13_sc_4.c.i Mark Scheme Image

9618_w24_qp_11_sc_2.b.ii

9618_w24_qp_11_sc_2.b.ii Question Image

Answer

9618_w24_qp_11_sc_2.b.ii Mark Scheme Image

9618_s24_qp_13_sc_4.b

9618_s24_qp_13_sc_4.b Question Image

Answer

9618_s24_qp_13_sc_4.b Mark Scheme Image

9618_s24_qp_12_sc_4.b

9618_s24_qp_12_sc_4.b Question Image

Answer

9618_s24_qp_12_sc_4.b Mark Scheme Image

9618_s24_qp_12_sc_4.c

9618_s24_qp_12_sc_4.c Question Image

Answer

9618_s24_qp_12_sc_4.c Mark Scheme Image

9618_s24_qp_11_sc_6.c.i

9618_s24_qp_11_sc_6.c.i Question Image

Answer

9618_s24_qp_11_sc_6.c.i Mark Scheme Image

9618_w23_qp_11_sc_3.c.i

9618_w23_qp_11_sc_3.c.i Question Image

Answer

9618_w23_qp_11_sc_3.c.i Mark Scheme Image

9618_s23_qp_11_sc_2.b.iii

9618_s23_qp_11_sc_2.b.iii Question Image

Answer

9618_s23_qp_11_sc_2.b.iii Mark Scheme Image

9618_w22_qp_13_sc_2.d

9618_w22_qp_13_sc_2.d Question Image

Answer

9618_w22_qp_13_sc_2.d Mark Scheme Image

9618_w22_qp_11_sc_4.d

9618_w22_qp_11_sc_4.d Question Image

Answer

9618_w22_qp_11_sc_4.d Mark Scheme Image

9618_w21_qp_12_sc_6.c.ii

9618_w21_qp_12_sc_6.c.ii Question Image

Answer

9618_w21_qp_12_sc_6.c.ii Mark Scheme Image

9618_s21_qp_12_sc_1.c.i

9618_s21_qp_12_sc_1.c.i Question Image

Answer

9618_s21_qp_12_sc_1.c.i Mark Scheme Image

9618_s21_qp_11_sc_7.b.iii

9618_s21_qp_11_sc_7.b.iii Question Image

Answer

9618_s21_qp_11_sc_7.b.iii Mark Scheme Image

Write an SQL script to query or modify data (DML) which are stored in (at most two) database tables

9618_w25_qp_13_sc_5.c

9618_w25_qp_13_sc_5.c Question Image

Answer

9618_w25_qp_13_sc_5.c Mark Scheme Image

9618_w25_qp_12_sc_4.c

9618_w25_qp_12_sc_4.c Question Image

Answer

9618_w25_qp_12_sc_4.c Mark Scheme Image

9618_w25_qp_11_sc_2.c.i

9618_w25_qp_11_sc_2.c.i Question Image

Answer

9618_w25_qp_11_sc_2.c.i Mark Scheme Image

9618_w25_qp_11_sc_2.c.ii

9618_w25_qp_11_sc_2.c.ii Question Image

Answer

9618_w25_qp_11_sc_2.c.ii Mark Scheme Image

9618_s25_qp_13_sc_6.b

9618_s25_qp_13_sc_6.b Question Image

Answer

9618_s25_qp_13_sc_6.b Mark Scheme Image

9618_s25_qp_13_sc_6.c

9618_s25_qp_13_sc_6.c Question Image

Answer

9618_s25_qp_13_sc_6.c Mark Scheme Image

9618_s25_qp_12_sc_5.d.i

9618_s25_qp_12_sc_5.d.i Question Image

Answer

9618_s25_qp_12_sc_5.d.i Mark Scheme Image

9618_s25_qp_12_sc_5.d.ii

9618_s25_qp_12_sc_5.d.ii Question Image

Answer

9618_s25_qp_12_sc_5.d.ii Mark Scheme Image

9618_s25_qp_11_sc_5.e

9618_s25_qp_11_sc_5.e Question Image

Answer

9618_s25_qp_11_sc_5.e Mark Scheme Image

9618_w24_qp_13_sc_4.b

9618_w24_qp_13_sc_4.b Question Image

Answer

9618_w24_qp_13_sc_4.b Mark Scheme Image

9618_w24_qp_12_sc_6.b.ii

9618_w24_qp_12_sc_6.b.ii Question Image

Answer

9618_w24_qp_12_sc_6.b.ii Mark Scheme Image

9618_w24_qp_11_sc_2.b.iii

9618_w24_qp_11_sc_2.b.iii Question Image

Answer

9618_w24_qp_11_sc_2.b.iii Mark Scheme Image

9618_s24_qp_13_sc_4.c

9618_s24_qp_13_sc_4.c Question Image

Answer

9618_s24_qp_13_sc_4.c Mark Scheme Image

9618_s24_qp_11_sc_6.c.ii

9618_s24_qp_11_sc_6.c.ii Question Image

Answer

9618_s24_qp_11_sc_6.c.ii Mark Scheme Image

9618_w23_qp_13_sc_3.b.ii

9618_w23_qp_13_sc_3.b.ii Question Image

Answer

9618_w23_qp_13_sc_3.b.ii Mark Scheme Image

9618_w23_qp_11_sc_3.c.ii

9618_w23_qp_11_sc_3.c.ii Question Image

Answer

9618_w23_qp_11_sc_3.c.ii Mark Scheme Image

9618_s23_qp_12_sc_2.c.ii

9618_s23_qp_12_sc_2.c.ii Question Image

Answer

9618_s23_qp_12_sc_2.c.ii Mark Scheme Image

9618_s23_qp_12_sc_2.c.iii

9618_s23_qp_12_sc_2.c.iii Question Image

Answer

9618_s23_qp_12_sc_2.c.iii Mark Scheme Image

9618_s23_qp_11_sc_2.b.iv

9618_s23_qp_11_sc_2.b.iv Question Image

Answer

9618_s23_qp_11_sc_2.b.iv Mark Scheme Image

9618_w22_qp_13_sc_2.c

9618_w22_qp_13_sc_2.c Question Image

Answer

9618_w22_qp_13_sc_2.c Mark Scheme Image

9618_w22_qp_12_sc_5.b

9618_w22_qp_12_sc_5.b Question Image

Answer

9618_w22_qp_12_sc_5.b Mark Scheme Image

9618_w22_qp_11_sc_4.c.ii

9618_w22_qp_11_sc_4.c.ii Question Image

Answer

9618_w22_qp_11_sc_4.c.ii Mark Scheme Image

9618_w21_qp_12_sc_6.c.i

9618_w21_qp_12_sc_6.c.i Question Image

Answer

9618_w21_qp_12_sc_6.c.i Mark Scheme Image

9618_w21_qp_11_sc_5.c.i

9618_w21_qp_11_sc_5.c.i Question Image

Answer

9618_w21_qp_11_sc_5.c.i Mark Scheme Image

9618_w21_qp_11_sc_5.c.ii

9618_w21_qp_11_sc_5.c.ii Question Image

Answer

9618_w21_qp_11_sc_5.c.ii Mark Scheme Image

9618_s21_qp_12_sc_1.c.ii

9618_s21_qp_12_sc_1.c.ii Question Image

Answer

9618_s21_qp_12_sc_1.c.ii Mark Scheme Image