Practice gce model questions vol1 computer_studies 2018 Past Questions

Question 1 View Details

In a spreadsheet, columns B to E contain monthly sales figures for four products (rows 2‑5). Cell G2 contains the formula =AVERAGE(B$2:E$5) which was then copied down to G5. What value will appear in cell G4?

A. 147.80

Correct B. 147.81

C. 148.81

D. 146.81

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 2 View Details

A server stores 500 GB of data. The data consists of Documents ($40\%$), Images ($25\%$), Videos ($20\%$), Audio ($10\%$) and Others ($5\%$). During backup, Documents are compressed to 70 % of their original size, Images to 50 %, Videos to 80 %, Audio to 90 % and Others are not compressed. After backup, what percentage of the total backup size is occupied by the Videos?

A. 24.5

B. 20.0

C. 21.3

Correct D. 22.7

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 3 View Details

An organisation has been allocated the Class B network $172.16.0.0/16$. It needs subnets for three departments: HR requires at least 500 hosts, Finance at least 2000 hosts, and IT at least 1000 hosts. Using VLSM, determine the subnet mask for the IT department and give its network address.

Correct A. 172.16.10.0/22

B. 172.16.10.0/21

C. 172.16.8.0/22

D. 172.16.12.0/22

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 4 View Details

The following Python function is intended to return the sum of the first $N$ odd numbers, but it contains an error. ```python def sum_odds(N): total = 0 i = 1 count = 0 while count <= N: total += i i += 2 count += 1 return total ``` Identify the error and state the correct output of `sum_odds(7)` after fixing the code.

A. 56

B. 42

Correct C. 49

D. 64

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 5 View Details

A company requires passwords of length 8 characters. Each character can be an uppercase letter (26 choices), a lowercase letter (26 choices) or a digit (10 choices). The policy mandates that a password must contain at least one digit and at least one uppercase letter. How many different passwords satisfy the policy?

A. 62^{8} - 52^{8} - 36^{8} - 26^{8}

B. 62^{8} - 52^{8} - 36^{8}

C. 62^{8} - 52^{8} + 36^{8} - 26^{8}

Correct D. 62^{8} - 52^{8} - 36^{8} + 26^{8}

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 6 View Details

Consider the following pseudocode: ``` SET S = 0 FOR N = 1 TO 20 IF 60 MOD N = 0 THEN SET S = S + N ENDIF ENDFOR IF S > 50 THEN SET R = S - 30 ELSE SET R = S + 30 ENDIF OUTPUT R ``` What integer value is output?

Correct A. 48

B. 50

C. 54

D. 46

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 7 View Details

In which year was the Intel 4004 microprocessor, the first commercially successful microprocessor, released?

Correct A. 1971

B. 1970

C. 1980

D. 1972

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 8 View Details

A network administrator is given the class B address $172.16.0.0/16$. They need to create subnets that can each support up to 30 usable host addresses. Determine the subnet mask that should be used and the total number of such subnets that can be created from the original address space.

A. 255.255.255.240, 4096

Correct B. 255.255.255.224, 2048

C. 255.255.255.248, 512

D. 255.255.255.192, 1024

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 9 View Details

A password policy allows passwords to be formed from 62 characters (26 uppercase letters, 26 lowercase letters, and 10 digits). To ensure security, passwords must provide at least 1,000,000 different possibilities. (a) What is the minimum length $L$ of a password that satisfies this requirement? (b) If passwords are required to be exactly this minimum length and must not start with a digit, how many possible passwords are there? Give your answer as an integer.

A. 14776336

B. 199888

C. 12400000

Correct D. 12393056

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 10 View Details

A program implements the following algorithm on a positive integer $N$: ``` SET count = 0 WHILE N ≠ 1 IF N is even THEN SET N = N / 2 ELSE SET N = 3N + 1 ENDIF SET count = count + 1 ENDWHILE OUTPUT count ``` If the initial value of $N$ is 6, what integer does the program output?

A. 7

Correct B. 8

C. 12

D. 9

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 11 View Details

A spreadsheet is set up to calculate an employee's pay. Column A contains Hours Worked (regular hours), column B contains the Hourly Rate, column C contains Overtime Hours, column D contains Overtime Rate calculated as (1.5\times B\), column E contains Regular Pay = (A\times B\), column F contains Overtime Pay = (C\times D\), and column G contains Gross Pay = (E+F\). Overtime Pay is only added if the Gross Pay before tax exceeds £700. A tax of 10 % is deducted from the Gross Pay to give the Net Pay shown in cell H2. An employee works 40 regular hours and 5 overtime hours. The Net Pay recorded in H2 is £641.25. Determine the hourly rate applied (in pounds) and state whether overtime pay was included.

Correct A. £15 per hour, overtime paid

B. £15 per hour, overtime not paid

C. £18 per hour, overtime paid

D. £12 per hour, overtime paid

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 12 View Details

A program processes an array of $n$ integers. For each index $i$ ($1 \le i \le n$) it searches linearly through the first $i$ elements to find the maximum value among them. The outer loop stops immediately if it encounters an element equal to a given target value $T$, which is guaranteed to be present somewhere in the array. What is the worst‑case time complexity of this algorithm in Big‑O notation?

A. O(n)

B. O(n^3)

C. O(n log n)

Correct D. O(n^2)

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 13 View Details

A password generator creates an 8‑character password by selecting each character independently and uniformly from the 62‑character set consisting of 26 uppercase letters, 26 lowercase letters and 10 digits. What is the probability that a randomly generated password contains at least one uppercase letter, at least one lowercase letter and at least one digit? Express your answer as a fraction of the total number of possible passwords.

A. (62^8 - 36^8 - 52^8 + 10^8 + 2·26^8) / 62^8

B. (62^8 - 2·36^8 - 52^8 + 2·10^8 + 2·26^8) / 62^8

Correct C. (62^8 - 2·36^8 - 52^8 + 10^8 + 2·26^8) / 62^8

D. (62^8 - 2·36^8 - 52^8 + 10^8) / 62^8

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 14 View Details

Consider a relation $R(A,\,B,\,C,\,D)$ with the functional dependencies: $A \rightarrow B$, $B \rightarrow C$, $AD \rightarrow C$.\ (i) List all candidate keys of $R$.\ (ii) State the highest normal form that $R$ satisfies.\ (iii) Decompose $R$ into a set of relations that are in Boyce‑Codd Normal Form (BCNF).

Correct A. Candidate key: AD; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D)

B. Candidate key: AD; Highest normal form: 1NF; BCNF decomposition: R1(A,B,C), R2(A,D)

C. Candidate key: A; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D)

D. Candidate key: AD; Highest normal form: 2NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D)

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 15 View Details

An organization has been allocated the class B network 172.16.0.0. It needs to create subnets that can each support at least 200 usable host addresses.\ (i) What subnet mask should be used for the subnets?\ (ii) How many such subnets can be created from the original network?

A. Subnet mask /24; 128 subnets

B. Subnet mask /23; 128 subnets

C. Subnet mask /25; 128 subnets

Correct D. Subnet mask /24; 256 subnets

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 16 View Details

In a class of $240$ students a survey was conducted about the use of three types of storage devices: USB drives (U), external hard disks (H) and cloud storage (C). The results were: $120$ students use USB drives, $70$ use external hard disks, and $110$ use cloud storage. $50$ students use both USB drives and cloud storage, $20$ use both USB drives and external hard disks, and $15$ use both external hard disks and cloud storage. $5$ students use all three types. How many students use exactly one type of storage device?

A. 130

B. 150

Correct C. 145

D. 160

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 17 View Details

A web page is viewed on a screen that is $500$ px wide. The HTML structure is <div id="container"><div class="box" style="width:70%;"></div></div>. The CSS rules are: #container { width: 100%; } .box { width: 60%; padding: 15px; } #container .box { width: 500px; } @media (max-width:600px) { .box { width: 80%; } }. Considering the cascade, specificity, and the media query, what is the total rendered width (including padding) of the element with class "box" on this screen?

A. 400

B. 420

Correct C. 380

D. 350

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 18 View Details

Consider the following Python function: ```python def mystery(nums): total = 0 for i in range(len(nums)): for j in range(i+1, len(nums)): if (nums[i] + nums[j]) % 3 == 0: total += nums[i] * nums[j] return total ``` If the list `nums` is $[4, 7, 2, 5, 9]$, what integer value does `mystery(nums)` return?

A. 71

B. 85

Correct C. 77

D. 63

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 19 View Details

A company can obtain a software package either by a perpetual licence or by an annual subscription. The perpetual licence costs $\text{₦}150{,}000$. A maintenance fee equal to 20 % of the purchase price is payable each year, and each subsequent year's maintenance fee increases by 5 % over the previous year's fee. After two years, the company may purchase an upgrade for $\text{₦}40{,}000$, which it decides to buy at the start of the third year. The subscription costs $\text{₦}35{,}000$ per year. Over a period of three years, which option results in the lower total cost: the perpetual licence (including maintenance and upgrade) or the subscription?

A. maintenance only

Correct B. subscription

C. perpetual licence

D. upgrade only

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 20 View Details

Who is credited with designing the first mechanical computer, known as the Analytical Engine, in the 19th century?

A. Alan Turing

B. Ada Lovelace

C. George Boole

Correct D. Charles Babbage

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 21 View Details

The organisation has been allocated the address block $192.168.0.0/24$. It must create subnets for three departments: Department A needs at least $50$ usable host addresses, Department B needs at least $20$, and Department C needs at least $10$. All subnets must use the same subnet mask and be contiguous. Determine the smallest possible subnet mask (in CIDR notation) that can satisfy all three departments, and state the number of usable host addresses provided by that mask.

A. /28, 14 usable hosts per subnet

B. /27, 30 usable hosts per subnet

Correct C. /26, 62 usable hosts per subnet

D. /25, 126 usable hosts per subnet

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 22 View Details

A $15$ MB video file is first compressed using Codec A, which reduces the file size by $25$% of the original size. The resulting file is then compressed using Codec B, which reduces the current size by an amount equal to $15$% of the original $15$ MB (i.e., the reduction is based on the original size, not on the intermediate size). What is the final size of the video file after both compressions, expressed in megabytes? Does the final file fit within a storage limit of $10$ MB? Answer with the final size and a Yes/No.

A. 10 MB, Yes

B. 8 MB, No

C. 9.5 MB, No

Correct D. 9 MB, Yes

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 23 View Details

Two CPUs are to be compared for a program consisting of $10^{9}$ instructions with the following instruction mix: 40 % of the instructions are class A, 35 % are class B and 25 % are class C. CPU 1: clock rate $2.5$ GHz; CPI values - class A: 1.0, class B: 2.0, class C: 3.0. CPU 2: clock rate $3.0$ GHz; CPI values - class A: 1.2, class B: 1.8, class C: 2.5. Calculate the average CPI for each CPU, then the execution time for the program on each CPU, and state which CPU executes the program faster (give the faster CPU and its execution time rounded to two decimal places).

Correct A. CPU 2, 0.58 s

B. CPU 1, 0.55 s

C. CPU 1, 0.62 s

D. CPU 2, 0.71 s

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 24 View Details

A video stream requires a constant bitrate of $4.5$ Mbps. It is transmitted over a network link that has a latency of $80$ ms and a sustainable bandwidth of $6$ Mbps. The video player buffers enough data to cover exactly $2$ seconds of playback before starting. (a) What is the minimum buffer size in megabytes required to store $2$ seconds of video? (b) Assuming the link can transmit at its full bandwidth after the initial latency, calculate the total time from the start of the download until playback begins.

A. 1.125 MB, 1.75 s

B. 0.9 MB, 1.58 s

C. 1.2 MB, 1.45 s

Correct D. 1.125 MB, 1.58 s

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 25 View Details

Consider the following Python code: ```python count = 0 for i in range(1, 7): for j in range(1, i+1): if (i * j) % 4 == 0: count += 1 print(count) ``` What integer value is printed when the program is executed?

Correct A. 9

B. 12

C. 10

D. 8

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

gce model questions vol1 2018 computer_studies | Objective

Master the Exam!

Help others prepare! Share this practice hub: