5g Queries ***

Question 0

Give an example of a complex query that could be used to search the customer table. (2)

Answer 0

Join of AND/OR/NOT (1)
2 criteria (1)

Question 1

The database makes use of simple and complex queries.

i) What is the difference between a simple and a complex query? (2

Answer 1

Simple contains one criteria (1)

Complex contains more than one criteria / Complex uses AND,OR,NOT (1)

Question 2

The website uses static and dynamic queries.

Describe the difference between a static and a dynamic query. (2)

Answer 2

Static
Hard coded/entered at design (1)
Dynamic
Can be changed by end user/entered at run time (1).

Question 3

The hospital appointment database uses dynamic and static parameter queries.
Describe the difference between a dynamic and a static parameter query giving an example of the use of each. (4)

Answer 3

Dynamic requires parameter to be given at run time (1) whereas static the parameter is hard coded (1)
With static the parameter cannot change (1) with dynamic the parameter can be changed by the end user (1) Examples
Static: department / times of appointments (1)
Dynamic: patient name / date of appointment (1)