SQL part 6 – Interpretation

SQL part 6 – Interpretation
 

• In some questions, you are required to explain the purpose of a SQL statement. These should be answered in the context of the scenario.

Relevant past paper:

DSE ICT Elect A(SP-2016): SP 1e. 2012 1cii,2c,4d. 2013 1ei. 2014 2e. 2015 1e. 2016 2bi.

AS CA(2000-2013): 2004 1d. 2009 8f. 2010 8e. 2011 7a. 2012 1c. 2013 9eiii.

• Some questions require you to make changes to the table. For examples, adding fields, decomposing tables, etc. Need to specify the data type if new fields are created.

Relevant past paper:

DSE ICT Elect A(SP-2016): SP 2e. 2012 3bii. 2014 1c. 2016 1f.

AS CA(2000-2013): 2002 4bii. 2005 6b. 2005 8g.

• You may be required to write the output of a SQL statement.

Relevant past paper:

AS CA(2000-2013): 2010 5ai.

AL CS(2003-2006): 2004 2. 2005 8a.