Practice gce model questions vol1 computer_studies 2019 Past Questions

Question 1 View Details

A company recorded the number of files processed each day from Monday to Friday. The counts were: Monday 120, Wednesday 150, Friday 200. The average number of files processed over the five days was $160$, and Thursday's count was $20\%$ higher than Tuesday's count. How many files were processed on Tuesday?

A. 130

B. 160

C. 140

Correct D. 150

Correct Answer: D

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

Question 2 View Details

A desktop computer has four identical RAM modules, each with a capacity of $2$ GB. If one module fails and is not replaced, what is the total RAM capacity (in GB) now available to the system?

A. 4

B. 10

Correct C. 6

D. 8

Correct Answer: C

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

Question 3 View Details

Consider the following Python function: ```python def mystery(k): total = 0 for i in range(1, k+1): for j in range(i, k+1): if (i*j) % 3 == 0: total += 1 return total ``` What integer value does `mystery(5)` return?

Correct A. 5

B. 7

C. 4

D. 6

Correct Answer: A

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

Question 4 View Details

A password policy requires passwords to be exactly $6$ characters long. Each character can be an uppercase letter (26 choices), a lowercase letter (26 choices) or a digit (10 choices). Additionally, a valid password must contain at least one digit and at least one uppercase letter. How many different passwords satisfy the policy?

A. 3516175936

Correct B. 35161759360

C. 35161759300

D. 35161759361

Correct Answer: B

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

Question 5 View Details

In which year was Intel's 4004 microprocessor, the first commercially successful microprocessor, introduced?

A. 1975

B. 1973

C. 1969

Correct D. 1971

Correct Answer: D

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

Question 6 View Details

A software project is estimated to require (800) person‑hours in total, divided among four phases as follows: Phase 1 - 20 % of the total, Phase 2 - 30 %, Phase 3 - 30 %, Phase 4 - 20 %. During execution the following adjustments occur: Phase 1 actually takes 15 % more time than estimated, Phase 2 takes 5 % less, Phase 3 takes 10 % less because of code reuse, and Phase 4 is completed exactly as estimated. What is the actual total number of person‑hours spent on the project?

A. 800

B. 812

C. 824

Correct D. 788

Correct Answer: D

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

Question 7 View Details

A container <div> has a fixed width of (960) px. Inside it a content <div> is styled with the following CSS properties: width: 70 %; padding: 10 px on each side; border: 2 px solid on each side; margin-left and margin-right each set to 5 % of the content div's original width (the width before padding and border). What is the total horizontal space occupied by the content <div> (including its margins) in pixels? Give your answer to one decimal place.

A. 759.2

B. 792.0

Correct C. 763.2

D. 765.6

Correct Answer: C

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

Question 8 View Details

In a spreadsheet the cells A1:A5 contain the numbers 12, 7, 15, 14, 20 respectively. Cells D1:E3 form a lookup table: \[\begin{array}{c|c} D & E \\hline 12 & 120 \\ 15 & 150 \\ 20 & 200 \end{array}\] Cell B1 contains the formula (=IF(A1>10, IFERROR(VLOOKUP(A1,\$D\$1:\$E\$3,2,FALSE),"Not found"), "Low")) and this formula is copied down to B5 (so the reference to A1 changes relatively while the table range remains absolute). What values appear in cells B4 and B5 after the copy? List the two results separated by a comma.

Correct A. Not found, 200

B. Not found, Not found

C. Low, Not found

D. Low, 200

Correct Answer: A

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

Question 9 View Details

Consider the following two tables. Employees(EmpID, DeptID, Salary) \[\begin{array}{c|c|c} \text{EmpID} & \text{DeptID} & \text{Salary} \\hline 1 & 10 & 50000 \\ 2 & 10 & 60000 \\ 3 & 20 & 55000 \\ 4 & 20 & 65000 \\ 5 & 30 & 70000 \end{array}\] Departments(DeptID, DeptName) \[\begin{array}{c|c} \text{DeptID} & \text{DeptName} \\hline 10 & \text{Sales} \\ 20 & \text{Marketing} \\ 30 & \text{HR} \end{array}\] Write an SQL query that lists each department name together with the average salary of its employees, but only for departments where the average salary exceeds 58 000. Based on the data above, which department name(s) will be returned by the query? List the names separated by a comma.

Correct A. Marketing, HR

B. Marketing, Sales

C. HR, Sales

D. Sales, Marketing

Correct Answer: A

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

Question 10 View Details

A 7‑bit data word $1011001$ is to be transmitted using even parity. Determine the parity bit that must be appended, give the final 8‑bit transmitted code, and then state whether an error is detected if the received code is $10110011$. Provide the parity bit, the transmitted code, and "Error detected" or "No error".

A. Parity bit: 1; Transmitted code: 10110010; Error detected

Correct B. Parity bit: 0; Transmitted code: 10110010; Error detected

C. Parity bit: 0; Transmitted code: 10110010; No error

D. Parity bit: 1; Transmitted code: 10110011; No error

Correct Answer: B

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

Question 11 View Details

Consider the following Python program: ```python total = 0 for i in range(1, 6): for j in range(i, 6): if (i + j) % 3 == 0: total += i * j else: total -= i + j print(total) ``` What integer value is printed when the program is executed?

A. 0

B. -18

C. -14

Correct D. -16

Correct Answer: D

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

Question 12 View Details

A small shop records sales in a spreadsheet. Cells A1‑A5 contain the quantities sold: 12, 7, 5, 9, 3. Cells B1‑B5 contain the unit prices (in naira): 250, 480, 150, 320, 210. Column C uses the formula `=A1*B1` (filled down) to calculate line totals. Column D uses the formula `=IF(C1>2000,0.10*C1,IF(C1>1000,0.05*C1,0))` (filled down) to calculate a discount for each line. Column E contains the net amount with the formula `=C1-D1` (filled down). Cell E6 contains `=SUM(E1:E5)`. What numeric value will appear in E6?

A. 9676

Correct B. 9696

C. 9600

D. 9796

Correct Answer: B

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

Question 13 View Details

A school network uses the address block $192.168.40.0/24$. The administrator must create sub‑networks, each capable of supporting at least 30 usable host addresses. Determine: 1. The subnet mask in dotted‑decimal notation. 2. The total number of sub‑nets that can be created. 3. The first usable IP address of the third subnet (counting from the lowest‑numbered subnet).

Correct A. 255.255.255.224, 8, 192.168.40.65

B. 255.255.255.240, 16, 192.168.40.33

C. 255.255.255.192, 4, 192.168.40.129

D. 255.255.255.224, 6, 192.168.40.97

Correct Answer: A

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

Question 14 View Details

The following HTML and CSS are used on a web page: ```html <ul class="menu"> <li>Home</li> <li>Products <ul> <li>Software</li> <li>Hardware</li> <li>Accessories</li> </ul> </li> <li>About</li> <li>Contact</li> </ul> ``` ```css .menu li:nth-child(odd) { display: none; } .menu ul li { color: red; } ``` When the page is rendered in a browser, how many `<li>` elements are visible to the user?

Correct A. 5

B. 6

C. 7

D. 4

Correct Answer: A

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

Question 15 View Details

A text file contains 2,560,000 characters, each stored as one byte in UTF‑8. After compression the file size is reduced by 35 % of the original size. The compressed file is saved on a disk that allocates space in blocks of 4,096 bytes, and a file always occupies a whole number of blocks. How many disk blocks are required to store the compressed file?

A. 406

B. 400

C. 408

Correct D. 407

Correct Answer: D

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

Question 16 View Details

A PC contains a CPU with a TDP of $95$ W, a GPU that consumes $250$ W, a hard‑disk drive using $5$ W, a solid‑state drive using $3$ W, and four RAM modules each using $2$ W. The power‑supply unit (PSU) operates at $80$% efficiency. To allow a $20$% safety headroom above the actual power draw, what is the minimum standard PSU rating (in watts) that should be selected? (Round up to the nearest 50 W.)

Correct A. 550

B. 500

C. 525

D. 600

Correct Answer: A

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

Question 17 View Details

Place the following computers in chronological order of their introduction: ENIAC, IBM PC, Apple Macintosh.

A. Apple Macintosh, ENIAC, IBM PC

B. ENIAC, Apple Macintosh, IBM PC

C. IBM PC, ENIAC, Apple Macintosh

Correct D. ENIAC, IBM PC, Apple Macintosh

Correct Answer: D

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

Question 18 View Details

Consider a relation $R(A,B,C,D,E)$ with the functional dependencies: $A \rightarrow B C$, $C \rightarrow D$, $B D \rightarrow E$, $E \rightarrow A$.\n(a) State the highest normal form that $R$ satisfies.\n(b) Decompose $R$ into BCNF and give the number of resulting relations.

Correct A. 2NF, 3

B. 1NF, 3

C. 2NF, 2

D. 3NF, 4

Correct Answer: A

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

Question 19 View Details

Algorithm A runs in time $T_A(n) = 30n + 1000$ milliseconds and Algorithm B runs in time $T_B(n) = 8n\log_2 n + 200$ milliseconds. What is the smallest integer input size $n$ for which Algorithm A becomes faster than Algorithm B?

A. 38

B. 35

C. 40

Correct D. 37

Correct Answer: D

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

Question 20 View Details

An organisation values a critical data asset at $\$50{,}000$. The annual likelihood of a relevant threat is $0.02$ and the vulnerability factor (probability the threat succeeds) is $0.4$. Two mitigation options are considered:\n- Option X reduces the vulnerability factor to $0.1$ and costs $\$5{,}000$.\n- Option Y reduces the threat likelihood to $0.01$ and costs $\$8{,}000$.\nCalculate the residual risk for each option, the absolute risk reduction, and the risk‑reduction‑per‑dollar for each. Which option provides the better cost‑effectiveness?

A. Neither option reduces risk

B. Both options are equally cost-effective

C. Option Y

Correct D. Option X

Correct Answer: D

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

Question 21 View Details

Given a relation R(A,B,C,D,E) with functional dependencies: A\rightarrow B, BC\rightarrow D, D\rightarrow E, A\rightarrow C. (a) Find a minimal cover of the set of functional dependencies. (b) The relation is decomposed into R1(A,B,C), R2(B,D) and R3(D,E). State whether this decomposition is lossless‑join and whether it preserves all functional dependencies.

A. Minimal cover: {A→B, A→C, BC→D, D→E}. Lossless‑join: No. Dependency preserving: No.

B. Minimal cover: {A→B, BC→D, D→E}. Lossless‑join: Yes. Dependency preserving: Yes.

C. Minimal cover: {A→B, A→C, B→D, D→E}. Lossless‑join: Yes. Dependency preserving: No.

Correct D. Minimal cover: {A→B, A→C, BC→D, D→E}. Lossless‑join: Yes. Dependency preserving: No.

Correct Answer: D

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

Question 22 View Details

An ASCII text file is 2.5 MB in size (1 MB = 1 048 576 bytes). The file contains 1 200 occurrences of the word "data" (4 letters) and 300 occurrences of the word "information" (11 letters). A compression scheme replaces each occurrence of "data" with a single 8‑bit token and each occurrence of "information" with a 16‑bit token; all other characters remain unchanged. Calculate (i) the size of the compressed file in megabytes (to three decimal places) and (ii) the percentage reduction in size (to two decimal places).

A. Compressed size ≈ 2.498 MB; reduction ≈ 0.12 %.

B. Compressed size ≈ 2.500 MB; reduction ≈ 0.00 %.

C. Compressed size ≈ 2.492 MB; reduction ≈ 0.31 %.

Correct D. Compressed size ≈ 2.495 MB; reduction ≈ 0.24 %.

Correct Answer: D

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

Question 23 View Details

A computer has a 16‑bit address bus and the memory is word‑addressable, where each word consists of 2 bytes. What is the maximum amount of memory that can be addressed, expressed in kilobytes (KB)?

A. 64 KB

B. 512 KB

C. 256 KB

Correct D. 128 KB

Correct Answer: D

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

Question 24 View Details

A data bus is 64 bits wide and operates at a frequency of 100 MHz. Assuming the bus can transfer one full word per clock cycle, what is the maximum theoretical data transfer rate in megabytes per second (MB/s)?

A. 1 600 MB/s

B. 400 MB/s

C. 100 MB/s

Correct D. 800 MB/s

Correct Answer: D

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

Question 25 View Details

In a spreadsheet the quarterly sales (units sold) of three products are recorded as follows: | Product | Q1 | Q2 | Q3 | Q4 | |---------|----|----|----|----| | A | 1200 | 1500 | 1300 | 1600 | | B | 800 | 950 | 1100 | 1050 | | C | 500 | 600 | 550 | 650 | The unit prices are: Product A = ₦20, Product B = ₦35, Product C = ₦50. Using this data, determine which product contributed the greatest proportion of the total revenue for the year, and state that proportion as a percentage rounded to the nearest whole percent.

A. Product A, 34 %

B. Product B, 45 %

Correct C. Product B, 38 %

D. Product C, 41 %

Correct Answer: C

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

gce model questions vol1 2019 computer_studies | Objective

Master the Exam!

Help others prepare! Share this practice hub: