CSEC ICT June 2019 Paper 1 Part 4

Which of the following CANNOT be

specified as data type in a database table?

• Text

• Array

• Yes/no

• Number

Given that E2 < F2, Which of the following functions will display the text

'LOW' in cell G2?

• =IF(E2>F2, "LOW")

• =IF(E2-F2, "LOW")

• =IF(E2<F2, "LOW")

• =IF(F2-E2, "LOW")

Consider the following algorithm.

a = 7

b = 9

a = b - a

b = a + b

Write a, b

The output of this algorithm is

• 2, 9

• 2, 11

• 7, 9

• 7, 11

When breaking down a simple problem

into its logical steps, what statement/

instruction would the adding of two

numbers be?

• An input

• A storage

• A process

• An output

What is the name given to an identifier that

always holds the same value?

• Storage

• Variable

• Location

• Constant

Which of the following is NOT a characteristic of an algorithm?

• It must terminate.

• It has an infinite number of steps.

• It has clearly defined and unambiguous steps.

• There is flow of control from one process to another.

The term 'top-down stepwise refinement' used in programming means

• breaking down a complex problem into a set of simple subproblems

• selecting the best solution to a complex problem

• dividing a complex problem into two halves

• creating several solutions to a problem

Which Of the following tasks does the following algorithm perform?

Read (A , B)

If A<B Then

Print(A);

• Reads two numbers and prints the first number

• Reads two numbers and prints the smaller number

• Reads two numbers and prints the first number if it is larger than the second number

• Reads two numbers and prints the first number if it is smaller than the second number

Which of the following is a high-level programming language?

• Binary

• C#

• Assembly

• Machine code

The LAST Step in solving a problem is to

• test the algorithm

• specify the design

• define the problem

• develop the algorithm