Practice gce model questions vol1 computer_studies 2022 Past Questions

Question 1 View Details

An image has a resolution of (1920 \times 1080) pixels and each pixel is stored using (24\)-bit colour. The image is first saved in an uncompressed format, then a loss‑less compression reduces the file size by (45\%\) of the original size. After compression, the file is transmitted over a network that adds a protocol overhead equal to (2\%\) of the compressed size plus a fixed header of (150\) bytes. What is the total number of bytes transmitted? Give your answer as an integer number of bytes.

A. 3500019

B. 3421440

C. 3490010

Correct D. 3490019

Correct Answer: D

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

Question 2 View Details

Consider the following pseudocode:\n\n``\ncount = 0\nfor i = 1 to n\n for j = i to n\n if (j \bmod i = 0)\n count = count + 1\n```\n\nIf $n = 12$, what is the final value of $count$?

A. 30

B. 34

Correct C. 35

D. 36

Correct Answer: C

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

Question 3 View Details

A computer has two RAM modules installed: one of 4 GB and another of 6 GB. The system uses a dual‑channel memory architecture, which achieves dual‑channel operation only when the paired modules are of equal size. What is the maximum amount of RAM that can operate in dual‑channel mode? Express your answer in gigabytes.

A. 10

Correct B. 8

C. 6

D. 4

Correct Answer: B

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

Question 4 View Details

A table in a student‑course database has the attributes: StudentID, StudentName, CourseCode, CourseName, Instructor, InstructorPhone, Grade. The functional dependencies are: StudentID $\rightarrow$ StudentName; CourseCode $\rightarrow$ CourseName, Instructor, InstructorPhone; StudentID, CourseCode $\rightarrow$ Grade. Assuming all attributes are atomic, what is the highest normal form (1NF, 2NF, 3NF, or BCNF) that this table satisfies?

A. 2NF

B. BCNF

C. 3NF

Correct D. 1NF

Correct Answer: D

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

Question 5 View Details

A binary‑search routine first compares the target value with the middle element of a sorted list, then discards the half that cannot contain the target and repeats the process. After the loop terminates, the algorithm performs one additional comparison to confirm that the target is absent. For a sorted list containing $1024$ distinct numbers, what is the maximum number of element comparisons performed when searching for a value that is not present?

A. 12

Correct B. 11

C. 10

D. 9

Correct Answer: B

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

Question 6 View Details

Eight computers are to be linked in a LAN arranged in a rectangular grid of 4 columns and 2 rows. Adjacent computers are 5 m apart horizontally and 6 m apart vertically. (a) If a star topology is used with a hub placed at the geometric centre of the rectangle, calculate the total length of cable required (to the nearest metre). (b) If a bus topology is used with a single backbone running the length of the rectangle and each computer connected to the backbone by the shortest perpendicular segment, calculate the total cable length (to the nearest metre). Which topology uses less cable?

A. Star topology (total cable ≈ 39 m, bus ≈ 48 m)

B. Bus topology (total cable ≈ 39 m, star ≈ 45 m)

Correct C. Bus topology (total cable ≈ 39 m, star ≈ 48 m)

D. Bus topology (total cable ≈ 42 m, star ≈ 48 m)

Correct Answer: C

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

Question 7 View Details

A company has been allocated the address block 192.168.64.0/22. It needs subnets for three departments: HR requires at least 50 hosts, Finance at least 30 hosts, and IT at least 100 hosts. Determine the smallest common subnet mask that can accommodate all three departments and list the network address (in CIDR notation) assigned to each department, using the mask you found. Assume subnets are allocated sequentially from the start of the address block.

A. Mask \/24; IT → 192.168.64.0\/24, HR → 192.168.65.0\/24, Finance → 192.168.66.0\/24

B. Mask \/25; IT → 192.168.64.0\/25, HR → 192.168.64.0\/25, Finance → 192.168.64.128\/25

C. Mask \/26; IT → 192.168.64.0\/26, HR → 192.168.64.64\/26, Finance → 192.168.64.128\/26

Correct D. Mask /25; IT → 192.168.64.0/25, HR → 192.168.64.128/25, Finance → 192.168.65.0/25

Correct Answer: D

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

Question 8 View Details

Consider the following Python function: ```python def append_square(x, lst=[]): lst.append(x*x) return lst a = append_square(2) b = append_square(3) c = append_square(4, []) d = append_square(5) print(len(a), len(b), len(c), len(d)) ``` What is the output printed by the program?

A. 3 2 1 3

Correct B. 3 3 1 3

C. 3 3 2 3

D. 2 2 1 2

Correct Answer: B

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

Question 9 View Details

A text file contains 1500 characters. Each character is stored using 8 bits. The file is first compressed using a run‑length encoding scheme that reduces its size to 60 % of the original. The compressed file is then stored on a disk that allocates space in blocks of 512 bytes, and a file always occupies a whole number of blocks. Determine (a) the number of disk blocks required to store the original file, and (b) the number of blocks required to store the compressed file.

Correct A. Original: 3 blocks; Compressed: 2 blocks

B. Original: 4 blocks; Compressed: 2 blocks

C. Original: 2 blocks; Compressed: 2 blocks

D. Original: 3 blocks; Compressed: 1 blocks

Correct Answer: A

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

Question 10 View Details

An attacker can test $10^{9}$ keys per second in a brute‑force attack on a symmetric cipher. What is the minimum key length (in bits) required so that an exhaustive search would take at least 100 years? Give the smallest integer number of bits that satisfies the condition.

A. 70 bits

B. 64 bits

Correct C. 62 bits

D. 58 bits

Correct Answer: C

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

Question 11 View Details

The first commercially successful microprocessor, the Intel 4004, was released a certain number of years before the first 8‑bit microprocessor, which came out in 1974. If the Intel 4004 was released 2 years earlier than the first 8‑bit microprocessor, in which year was the Intel 4004 released?

A. 1974

B. 1970

C. 1973

Correct D. 1972

Correct Answer: D

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

Question 12 View Details

A small office has 6 computers that must be interconnected so that each computer has at least two independent paths to any other computer (i.e., the network must remain connected after the removal of any single cable). The office can use any combination of star and ring topologies, and the connection to the internet service provider requires a separate cable from a central hub. What is the minimum total number of cables required to satisfy the redundancy requirement and the ISP connection?

A. 6

Correct B. 7

C. 8

D. 9

Correct Answer: B

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

Question 13 View Details

Consider the following HTML element and CSS rules: HTML: <p id="intro" class="highlight important">Sample text</p> CSS: 1. p { color: blue; } 2. .highlight { color: green; } 3. #intro { color: red; } 4. p.important { color: orange; } 5. .highlight.important { color: purple; } 6. #intro.highlight { color: teal; } Using the cascade and specificity rules, what colour will be rendered for the paragraph?

Correct A. teal

B. purple

C. red

D. green

Correct Answer: A

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

Question 14 View Details

Relation R(A,B,C,D,E) has the following functional dependencies: A → B, B → C, C → D, D → E, A → E. (a) State the highest normal form that R satisfies before any decomposition. (b) Decompose R into a set of relations that are in Boyce‑Codd Normal Form (BCNF) and give the number of resulting BCNF relations.

A. 3NF, 5

B. 1NF, 3

C. BCNF, 2

Correct D. 2NF, 4

Correct Answer: D

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

Question 15 View Details

A file of size $2^{20}$ bytes must be transmitted over a network using a protocol that adds a 64‑byte header to each packet. The maximum packet size (including header) is 1500 bytes. Determine the minimum number of packets required and the total number of overhead bytes added by the headers.

A. 731 packets, 46,720 bytes

B. 732 packets, 46,848 bytes

Correct C. 731 packets, 46,784 bytes

D. 730 packets, 46,720 bytes

Correct Answer: C

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

Question 16 View Details

Consider the following pseudo‑code where n and m are positive integers: ``` count = 0 for i = 1 to n for j = i to n if (i + j) mod 3 = 0 for k = 1 to m step 2 count = count + 1 ``` How many times is the statement `count = count + 1` executed? Express your answer in terms of $n$ and $m$.

A. \left\lfloor\frac{m}{2}\right\rfloor\left(\frac{\lfloor n/3\rfloor\bigl(\lfloor n/3\rfloor+1\bigr)}{2}+\,\lfloor\frac{n+2}{3}\rfloor\cdot\lfloor\frac{n+1}{3}\rfloor\right)

B. \left\lceil\frac{m}{2}\right\rceil\left(\frac{\lfloor n/3\rfloor\bigl(\lfloor n/3\rfloor-1\bigr)}{2}+\,\lfloor\frac{n+2}{3}\rfloor\cdot\lfloor\frac{n+1}{3}\rfloor\right)

Correct C. \left\lceil\frac{m}{2}\right\rceil\left(\frac{\lfloor n/3\rfloor\bigl(\lfloor n/3\rfloor+1\bigr)}{2}+\,\lfloor\frac{n+2}{3}\rfloor\cdot\lfloor\frac{n+1}{3}\rfloor\right)

D. \left\lceil\frac{m}{2}\right\rceil\left(\frac{\lfloor n/3\rfloor\bigl(\lfloor n/3\rfloor+1\bigr)}{2}+\,\lfloor\frac{n}{3}\rfloor\cdot\lfloor\frac{n+2}{3}\rfloor\right)

Correct Answer: C

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

Question 17 View Details

An information system stores records of exactly 150 bytes each. The file system allocates space in blocks of 512 bytes, and each block contains a 24‑byte header. Records cannot be split across blocks; if a record does not fit in the remaining space of a block it is placed in the next block. What is the minimum number of blocks required to store 1 200 records, and what is the storage efficiency (percentage of the allocated space that is used for actual record data, rounded to one decimal place)?

A. 450 blocks, 84.4%

B. 300 blocks, 93.8%

Correct C. 400 blocks, 87.9%

D. 400 blocks, 75.0%

Correct Answer: C

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

Question 18 View Details

Relation $R(A,B,C,D,E)$ is defined by the functional dependencies: $A \rightarrow B$ $BC \rightarrow D$ $D \rightarrow E$ (a) State the highest normal form that $R$ satisfies. (b) Decompose $R$ into a collection of relations that are in Boyce‑Codd Normal Form (BCNF). How many relations are in the resulting BCNF decomposition?

A. 2NF; 2 relations

Correct B. 1NF; 3 relations

C. 3NF; 4 relations

D. BCNF; 3 relations

Correct Answer: B

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

Question 19 View Details

In a web page the following HTML and CSS are used. HTML: ```html <div class="container"> <p id="para1" class="text">Sample text</p> </div> ``` CSS: ```css p { color: blue; } .text { color: green; } #para1 { color: red; } div.container p { color: orange; } .container .text { color: purple !important; } body { color: black; } ``` What is the computed text colour of the paragraph element when the page is rendered?

A. green

Correct B. purple

C. red

D. orange

Correct Answer: B

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

Question 20 View Details

Examine the JavaScript code below: ```javascript for (var i = 1; i <= 3; i++) { setTimeout(function() { console.log(i); }, i * 100); } for (let j = 1; j <= 3; j++) { setTimeout(function() { console.log(j); }, j * 100); } ``` Assuming the code runs in a modern browser, what sequence of numbers is printed to the console, in the order they appear?

A. 4,4,4,1,2,3

Correct B. 4,1,4,2,4,3

C. 4,1,2,3,4,4

D. 1,2,3,4,4,4

Correct Answer: B

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

Question 21 View Details

Consider the following Python function: ```python def mystery(m): total = 0 for i in range(1, m+1): if i % 2 == 0: total += i//2 else: total += (i*3 + 1) % 5 return total n = 7 result = mystery(n) + mystery(n-2) print(result) ``` What number is printed when the program is executed?

Correct A. 21

B. 22

C. 20

D. 24

Correct Answer: A

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

Question 22 View Details

A school needs to store 120 files, each originally sized at $2.5$ MB. Two compression programs are available:\n\n- Program A reduces a file by 30 % of its original size and then adds a $0.2$ MB header.\n- Program B reduces a file by 25 % of its original size and then adds a $0.5$ MB header.\n\nWhich program results in the smaller total storage requirement for the 120 files?

A. Both programs

Correct B. Program A

C. Neither program

D. Program B

Correct Answer: B

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

Question 23 View Details

The table below shows the sales (in units) of five products (P1-P5) over four quarters (Q1-Q4). All entries are known except the value for product P3 in quarter Q2, which is shown as a blank. The row totals (product totals) and column totals (quarter totals) are also given. | | Q1 | Q2 | Q3 | Q4 | Row total | |------|----|----|----|----|-----------| | P1 | 40 | 20 | 40 | 20 | 120 | | P2 | 50 | 40 | 40 | 20 | 150 | | P3 | 45 | | 35 | 30 | 130 | | P4 | 30 | 25 | 35 | 20 | 110 | | P5 | 25 | 65 | 50 | 0 | 140 | | Column total | 190 | 170 | 200 | 90 | 650 | What is the missing sales figure for P3 in Q2?

A. 15

B. 25

Correct C. 20

D. 30

Correct Answer: C

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

Question 24 View Details

In a spreadsheet, cells $B2:E5$ contain sales figures (in dollars). The company pays a commission of 10 % on any individual sale exceeding $\$500$; otherwise the commission is 5 %. Write a single formula that returns the total commission payable for the whole range $B2:E5$. The formula must use absolute references so it can be copied elsewhere without modification.

A. =SUMPRODUCT(($B$2:$E$5>=500)*0.10*$B$2:$E$5 + ($B$2:$E$5<500)*0.05*$B$2:$E$5)

B. =SUMPRODUCT(($B$2:$E$5>500)*0.10*$B$2:$E$5 + ($B$2:$E$5<500)*0.05*$B$2:$E$5)

Correct C. =SUMPRODUCT(($B$2:$E$5>500)*0.10*$B$2:$E$5 + ($B$2:$E$5<=500)*0.05*$B$2:$E$5)

D. =SUMPRODUCT(($B$2:$E$5>500)*0.10*$B$2:$E$5 + ($B$2:$E$5<=500)*0.06*$B$2:$E$5)

Correct Answer: C

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

Question 25 View Details

A password policy requires passwords of exactly eight characters. Each character can be an uppercase letter (26 choices), a lowercase letter (26 choices), a digit (10 choices) or a symbol (12 choices), giving a total character set of 74 symbols. An attacker can try one million passwords per second. Estimate how many years it would take the attacker to try every possible password, and state whether this exceeds one year.

Correct A. Yes, about 28.5 years

B. No, about 0.9 years

C. Yes, about 15 years

D. No, about 28.5 years

Correct Answer: A

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

gce model questions vol1 2022 computer_studies | Objective

Master the Exam!

Help others prepare! Share this practice hub: