OCR Computer Science – June 2018 Exam Paper 2 Exam
Quiz Summary
0 of 3 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 3 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- June 2018 Exam Paper 0%
- 1
- 2
- 3
- Current
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 3
1. Question
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 =
Number 2 =
Number 3 =
b) State how many times line 03 will be executed if the algorithm runs through once
The algorithm will be executed times
c) What is the value of m when the algorithm is complete
The value of m is:
d) When multiple values are stored in a single variable, this is known as a:
e) A for loop is used in the above example this is also known as
f) One of the 3 basic programming constructs. Instructions happening one after the other in order is:
Correct / 8 PointsIncorrect / 8 Points -
-
Question 2 of 3
2. Question
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:
• Points :
• LetterSent:(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.StudentName
FROM
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:Â
(ii) What does the mathematical operation “<” mean:
(e) State the wildcard that can be used in SQL to show all fields from a table.
Wildcard is:
Correct / 9 PointsIncorrect / 9 Points -
-
Question 3 of 3
3. Question
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:
b) What is the name of gate 2:
c) Complete the truth table below to show the output from this logic system.
A B Q 0 0 0 1 1 0 1 1 d) Complete the trace table for a AND gate
A B Q 0 0 0 1 1 0 1 1 e) Complete the trace table for a OR gate
A B Q 0 0 0 1 1 0 1 1 f) Complete the trace table for a NOT gate
A Q 0 1
Correct / 16 PointsIncorrect / 16 Points -