SQL Exam Paper
SQL Exam Prep Pack – Part 1
Introduction.
This Exam Prep Pack is to help students get an appreciation of the type and style of SQL questions on the exam as well as an idea of what is being tested and what sort of answers might be expected.
In addition, extra problems of a similar style are listed for you to attempt. If I can, I will monitor this and help out where necessary but this will be primarily a student-driven forum.
Each question in this document has a unique number to make it easier to identify when posting to the forum.
Remember, there is no direct correlation between these questions and the exam questions. The material covered in this document is goes beyond the scope of the exam. This is intended to give you a general sense of the standard of questions, some ideas on how to solve them and an opportunity to practice.
There is a fair bit to cover so rather than wait until the document is complete, I am releasing this documents in parts.
Preamble
The questions are based on the Research database used in the course. The tables are reproduced here for convenience.
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum*, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum*, AcNum*)
Field(FieldNum, ID, Title)
Interest(FieldNum*, AcNum*, Descrip)
The Questions.
Q1.0 List the Academic Numbers of all academics who have a given name starting with S.
What is being tested.
Single table question. Basic query structure. Simple string handling. Note: letter is case sensitive
A1.0
Select acnum
From academic
Where givename like 'S%';
31 rows selected.
Additional Questions.
Q1.1 List the Academic Numbers of all academics who have a given name the a second letter of
t. (Note: trick here is how to test the second letter)
Q2.0 List the Academic Numbers of all academics who have a given name starting with S and whose department number is greater than 100.
What is being tested.
Introduction.
This Exam Prep Pack is to help students get an appreciation of the type and style of SQL questions on the exam as well as an idea of what is being tested and what sort of answers might be expected.
In addition, extra problems of a similar style are listed for you to attempt. If I can, I will monitor this and help out where necessary but this will be primarily a student-driven forum.
Each question in this document has a unique number to make it easier to identify when posting to the forum.
Remember, there is no direct correlation between these questions and the exam questions. The material covered in this document is goes beyond the scope of the exam. This is intended to give you a general sense of the standard of questions, some ideas on how to solve them and an opportunity to practice.
There is a fair bit to cover so rather than wait until the document is complete, I am releasing this documents in parts.
Preamble
The questions are based on the Research database used in the course. The tables are reproduced here for convenience.
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum*, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum*, AcNum*)
Field(FieldNum, ID, Title)
Interest(FieldNum*, AcNum*, Descrip)
The Questions.
Q1.0 List the Academic Numbers of all academics who have a given name starting with S.
What is being tested.
Single table question. Basic query structure. Simple string handling. Note: letter is case sensitive
A1.0
Select acnum
From academic
Where givename like 'S%';
31 rows selected.
Additional Questions.
Q1.1 List the Academic Numbers of all academics who have a given name the a second letter of
t. (Note: trick here is how to test the second letter)
Q2.0 List the Academic Numbers of all academics who have a given name starting with S and whose department number is greater than 100.
What is being tested.