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

9608_s21_qp_11_sc_5.c

9608_s21_qp_11_sc_5.c Question Image
9608_s21_qp_11_sc_5.c Question Image

9608_w19_qp_13_sc_3.c

9608_w19_qp_13_sc_3.c Question Image
9608_w19_qp_13_sc_3.c Question Image

9608_w19_qp_12_sc_4.b.ii

9608_w19_qp_12_sc_4.b.ii Question Image
9608_w19_qp_12_sc_4.b.ii Question Image

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

9608_w19_qp_13_sc_3.c

9608_w19_qp_13_sc_3.c Question Image
9608_w19_qp_13_sc_3.c Question Image

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

9608_w19_qp_13_sc_3.c

9608_w19_qp_13_sc_3.c Question Image
9608_w19_qp_13_sc_3.c Question Image

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

9608_w21_qp_11_sc_9.b

9608_w21_qp_11_sc_9.b Question Image
9608_w21_qp_11_sc_9.b Question Image

9608_s21_qp_13_sc_8.c

9608_s21_qp_13_sc_8.c Question Image
9608_s21_qp_13_sc_8.c Question Image

9608_s21_qp_12_sc_4.c

9608_s21_qp_12_sc_4.c Question Image
9608_s21_qp_12_sc_4.c Question Image

9608_s20_qp_13_sc_6.c.i

9608_s20_qp_13_sc_6.c.i Question Image
9608_s20_qp_13_sc_6.c.i Question Image

9608_s20_qp_13_sc_6.c.iii

9608_s20_qp_13_sc_6.c.iii Question Image
9608_s20_qp_13_sc_6.c.iii Question Image

9608_s20_qp_12_sc_6.c.i

9608_s20_qp_12_sc_6.c.i Question Image
9608_s20_qp_12_sc_6.c.i Question Image

9608_s20_qp_11_sc_7.c

9608_s20_qp_11_sc_7.c Question Image
9608_s20_qp_11_sc_7.c Question Image

9608_s20_qp_11_sc_7.d

9608_s20_qp_11_sc_7.d Question Image
9608_s20_qp_11_sc_7.d Question Image

9608_w19_qp_12_sc_4.b.ii

9608_w19_qp_12_sc_4.b.ii Question Image
9608_w19_qp_12_sc_4.b.ii Question Image

9608_w19_qp_12_sc_4.b.iii

9608_w19_qp_12_sc_4.b.iii Question Image
9608_w19_qp_12_sc_4.b.iii Question Image

9608_s19_qp_13_sc_3.e.i

9608_s19_qp_13_sc_3.e.i Question Image
9608_s19_qp_13_sc_3.e.i Question Image

9608_s19_qp_13_sc_3.e.ii

9608_s19_qp_13_sc_3.e.ii Question Image
9608_s19_qp_13_sc_3.e.ii Question Image

9608_w18_qp_11_sc_7.c

9608_w18_qp_11_sc_7.c Question Image
9608_w18_qp_11_sc_7.c Question Image

9608_s18_qp_13_sc_2.d.i

9608_s18_qp_13_sc_2.d.i Question Image
9608_s18_qp_13_sc_2.d.i Question Image

9608_s18_qp_13_sc_2.d.ii

9608_s18_qp_13_sc_2.d.ii Question Image
9608_s18_qp_13_sc_2.d.ii Question Image

9608_s18_qp_12_sc_7.d.i

9608_s18_qp_12_sc_7.d.i Question Image
9608_s18_qp_12_sc_7.d.i Question Image

9608_s18_qp_12_sc_7.d.ii

9608_s18_qp_12_sc_7.d.ii Question Image
9608_s18_qp_12_sc_7.d.ii Question Image

9608_w16_qp_12_sc_9.c

9608_w16_qp_12_sc_9.c Question Image
9608_w16_qp_12_sc_9.c Question Image

9608_s16_qp_13_sc_5.d.i

9608_s16_qp_13_sc_5.d.i Question Image
9608_s16_qp_13_sc_5.d.i Question Image

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

9608_s21_qp_13_sc_8.d

9608_s21_qp_13_sc_8.d Question Image
9608_s21_qp_13_sc_8.d Question Image

9608_s21_qp_11_sc_5.d

9608_s21_qp_11_sc_5.d Question Image
9608_s21_qp_11_sc_5.d Question Image

9608_s20_qp_13_sc_6.c.ii

9608_s20_qp_13_sc_6.c.ii Question Image
9608_s20_qp_13_sc_6.c.ii Question Image

9608_s20_qp_12_sc_6.c.ii

9608_s20_qp_12_sc_6.c.ii Question Image
9608_s20_qp_12_sc_6.c.ii Question Image

9608_s20_qp_11_sc_7.e

9608_s20_qp_11_sc_7.e Question Image
9608_s20_qp_11_sc_7.e Question Image

9608_w19_qp_12_sc_4.b.iv

9608_w19_qp_12_sc_4.b.iv Question Image
9608_w19_qp_12_sc_4.b.iv Question Image

9608_s19_qp_13_sc_3.e.iii

9608_s19_qp_13_sc_3.e.iii Question Image
9608_s19_qp_13_sc_3.e.iii Question Image

9608_s19_qp_11_sc_2.c.iii

9608_s19_qp_11_sc_2.c.iii Question Image
9608_s19_qp_11_sc_2.c.iii Question Image

9608_w18_qp_11_sc_7.d

9608_w18_qp_11_sc_7.d Question Image
9608_w18_qp_11_sc_7.d Question Image

9608_w17_qp_13_sc_7.d.i

9608_w17_qp_13_sc_7.d.i Question Image
9608_w17_qp_13_sc_7.d.i Question Image

9608_w17_qp_13_sc_7.e

9608_w17_qp_13_sc_7.e Question Image
9608_w17_qp_13_sc_7.e Question Image

9608_w17_qp_12_sc_7.c.i

9608_w17_qp_12_sc_7.c.i Question Image
9608_w17_qp_12_sc_7.c.i Question Image

9608_w17_qp_12_sc_7.d

9608_w17_qp_12_sc_7.d Question Image
9608_w17_qp_12_sc_7.d Question Image

9608_s17_qp_13_sc_1.d.i

9608_s17_qp_13_sc_1.d.i Question Image
9608_s17_qp_13_sc_1.d.i Question Image

9608_s17_qp_13_sc_1.d.ii

9608_s17_qp_13_sc_1.d.ii Question Image
9608_s17_qp_13_sc_1.d.ii Question Image

9608_s17_qp_12_sc_1.c.i

9608_s17_qp_12_sc_1.c.i Question Image
9608_s17_qp_12_sc_1.c.i Question Image

9608_s17_qp_12_sc_1.c.ii

9608_s17_qp_12_sc_1.c.ii Question Image
9608_s17_qp_12_sc_1.c.ii Question Image

9608_s17_qp_11_sc_1.d.i

9608_s17_qp_11_sc_1.d.i Question Image
9608_s17_qp_11_sc_1.d.i Question Image

9608_s17_qp_11_sc_1.d.ii

9608_s17_qp_11_sc_1.d.ii Question Image
9608_s17_qp_11_sc_1.d.ii Question Image

9608_s16_qp_13_sc_5.d.ii

9608_s16_qp_13_sc_5.d.ii Question Image
9608_s16_qp_13_sc_5.d.ii Question Image

9608_s16_qp_13_sc_5.d.iii

9608_s16_qp_13_sc_5.d.iii Question Image
9608_s16_qp_13_sc_5.d.iii Question Image

9608_s16_qp_12_sc_8.b.iii

9608_s16_qp_12_sc_8.b.iii Question Image
9608_s16_qp_12_sc_8.b.iii Question Image

9608_s16_qp_12_sc_8.b.iv

9608_s16_qp_12_sc_8.b.iv Question Image
9608_s16_qp_12_sc_8.b.iv Question Image

9608_s16_qp_11_sc_8.b.iii

9608_s16_qp_11_sc_8.b.iii Question Image
9608_s16_qp_11_sc_8.b.iii Question Image

9608_s16_qp_11_sc_8.b.iv

9608_s16_qp_11_sc_8.b.iv Question Image
9608_s16_qp_11_sc_8.b.iv Question Image