OCR Computer Science – June 2018 Exam Paper 2 Exam

8 point(s)

A programmer has written an algorithm to output a series of numbers. The algorithm is shown below:

a)Give the first three numbers that will be printed by this algorithm:

Number 1 = Fill in the blank 1 of 8

Number 2 = Fill in the blank 2 of 8

Number 3 = Fill in the blank 3 of 8

b) State how many times line 03 will be executed if the algorithm runs through once

The algorithm will be executed Fill in the blank 4 of 8 times

c) What is the value of m when the algorithm is complete

The value of m is: Fill in the blank 5 of 8

d) When multiple values are stored in a single variable, this is known as a: Fill in the blank 6 of 8

e) A for loop is used in the above example this is also known as Fill in the blank 7 of 8

f) One of the 3 basic programming constructs. Instructions happening one after the other in order is: Fill in the blank 8 of 8

9 point(s)

OCR High School uses a computer system to store data about students’ conduct. The system
records good conduct as a positive number and poor conduct as a negative number. A TRUE
or FALSE value is also used to record whether or not a letter has been sent home about each
incident.

An example of the data held in this system is shown below in Fig. 1:

(a) State the most appropriate data type used to store each of the following items of data.
• StudentName: Fill in the blank 1 of 9
• Points : Fill in the blank 2 of 9
• LetterSent: Fill in the blank 3 of 9

(b) The data shown above in Fig. 1 is stored in a database table called Conduct.

Write an SQL statement to select the StudentName field for all records that have negative
Points.

Fill in the blank 4 of 9 StudentName
FROM Fill in the blank 5 of 9
Fill in the blank 6 of 9 Points < 0

(c) The third line in the sql statement reads: WHERE Points < 0 and returns 2 students.

(i)What could be an alternative value instead of “<0” to achieve the same results: Fill in the blank 7 of 9

(ii) What does the mathematical operation “<” mean: Fill in the blank 8 of 9

(e) State the wildcard that can be used in SQL to show all fields from a table.

Wildcard is: Fill in the blank 9 of 9

16 point(s)

The logic diagram below (Fig. 2) shows a system made up of two connected logic gates.

a) What is the name of gate 1: Fill in the blank 1 of 16

b) What is the name of gate 2: Fill in the blank 2 of 16

c) Complete the truth table below to show the output from this logic system.

A	B	Q
0	0	Fill in the blank 3 of 16
0	1	Fill in the blank 4 of 16
1	0	Fill in the blank 5 of 16
1	1	Fill in the blank 6 of 16

d) Complete the trace table for a AND gate

A	B	Q
0	0	Fill in the blank 7 of 16
0	1	Fill in the blank 8 of 16
1	0	Fill in the blank 9 of 16
1	1	Fill in the blank 10 of 16

e) Complete the trace table for a OR gate

Image result for or gate

A	B	Q
0	0	Fill in the blank 11 of 16
0	1	Fill in the blank 12 of 16
1	0	Fill in the blank 13 of 16
1	1	Fill in the blank 14 of 16

f) Complete the trace table for a NOT gate

Image result for not gate

A	Q
0	Fill in the blank 15 of 16
1	Fill in the blank 16 of 16

A	B	Q
0	0	BLANK 3 of 16
0	1	BLANK 4 of 16
1	0	BLANK 5 of 16
1	1	BLANK 6 of 16

A	B	Q
0	0	BLANK 7 of 16
0	1	BLANK 8 of 16
1	0	BLANK 9 of 16
1	1	BLANK 10 of 16

A	B	Q
0	0	BLANK 11 of 16
0	1	BLANK 12 of 16
1	0	BLANK 13 of 16
1	1	BLANK 14 of 16

OCR Computer Science – June 2018 Exam Paper 2 Exam

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question