Programming Construct Identification 1 (1 mark)
What programming construct is used in the code snippet shown below? for i 0 to 5 print(i) next i
Programming Construct Identification 1 (1 mark) Read More »
Development
Boolean Logic. (2 marks)
Explain the result of the Boolean expression (NOT A AND B) OR (A AND NOT B) where A = True and B = False.
Boolean Logic. (2 marks) Read More »
Operators and Expressions. (3 marks)
Given the expression: 9 * (3 + x) > 50 a) What is the role of the parentheses in this expression? b) Explain what this expression represents. c) List the operators used in this expression.
Operators and Expressions. (3 marks) Read More »
Variables and Constants. (2 marks)
Consider a scenario where a program keeps track of the score of a game and the maximum possible score. Define what you would use as a variable and what as a constant, and explain your reasoning. a) What would you define as a variable? b) What would you define as a constant?
Variables and Constants. (2 marks) Read More »
Procedures and Functions 3
What is a parameter and how does it differ from an argument?
Procedures and Functions 3 Read More »
Procedures and Functions 2
Explain 3 advantages of using subroutines when programming.
Procedures and Functions 2 Read More »
Procedures and Functions 1
What is the difference between a procedure and a function?
Procedures and Functions 1 Read More »
Databases and SQL 3
Consider the SQL query: SELECT * FROM table What is the purpose of the * in this SQL example?
Databases and SQL 3 Read More »
Databases and SQL 2
A database table called ‘leaderboard’, contains the percentage scores obtained by students in a recent assessment, along with the students’ names. The field names in the table are ‘students’ and ‘scores’. Write the SQL query needed to access the names of students who have achieved a score of over 50%.
Databases and SQL 2 Read More »
Databases and SQL 1
Study the table below (called ‘teachers’), which shows a selection of teachers of various subjects in a school. teacher subject Miss Small Maths Mrs Smith Maths Mr Jones English Mr White English Miss Green Maths Mrs Hughes Art Mr Morgan Computer Science Write the SQL query to return the names of teachers who teach ‘Maths’.
Databases and SQL 1 Read More »