Practice city guilds model questions vol1 information_technology 2018 Past Questions

Question 1 View Details

In a spreadsheet, cell D1 contains the tax rate 0.05 and cell C2 contains a fixed fee of 30. Column A lists the amounts: A2=50, A3=80, A4=120, A5=200. In cell B2 the formula is =IF(A2>150, A2*$D$1*0.9 + $C$2, A2*$D$1 + $C$2). When this formula is copied down to cell B5, what value appears in B5?

A. 40

B. 38

Correct C. 39

D. 45

Correct Answer: C

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

Question 2 View Details

An organization has the network 192.168.10.0/24. It needs subnets for three departments requiring 50, 30, and 12 usable host addresses respectively. Using variable‑length subnet masking (VLSM), assign subnets to the departments in order of decreasing size. What is the network address and CIDR notation of the subnet allocated to the department that needs 12 hosts?

Correct A. 192.168.10.96/28

B. 192.168.10.96/27

C. 192.168.10.80/28

D. 192.168.10.112/28

Correct Answer: A

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

Question 3 View Details

A document is typed in Times New Roman 12‑pt with 1‑inch margins on all sides and 1.5 line spacing. Each line can hold exactly 78 characters and each page can accommodate 45 lines of text. The document contains 23 400 characters (including spaces) and also has three footnotes, each occupying two lines at the bottom of the page on which they appear. Assuming footnote lines reduce the number of text lines available on that page, how many pages are required to print the whole document?

Correct A. 7

B. 9

C. 6

D. 8

Correct Answer: A

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

Question 4 View Details

Five processes P1-P5 arrive at time 0 with CPU burst times (in ms) P1=10, P2=4, P3=6, P4=8, P5=12. The CPU uses Round‑Robin scheduling with a time quantum of 4 ms and no context‑switch overhead. Calculate the average waiting time of the processes.

A. 22

B. 28

Correct C. 20

D. 16

Correct Answer: C

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

Question 5 View Details

The following algorithm counts pairs of distinct elements whose sum is divisible by 3:\n\n``` count = 0 for i = 1 to n‑1 for j = i+1 to n if (A[i] + A[j]) mod 3 = 0 count = count + 1 ```\nAssume the array A contains the first n positive integers, where n is a multiple of 3.\n\n(a) Derive a formula for count in terms of n.\n(b) Using your formula, find count when n = 12.

A. 24

B. 18

C. 20

Correct D. 22

Correct Answer: D

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

Question 6 View Details

A relation R(A, B, C, D, E) has the set of functional dependencies $A \rightarrow B$, $BC \rightarrow D$, $D \rightarrow E$, and $AB \rightarrow C$.\n\n(a) State whether R is in Boyce‑Codd Normal Form (BCNF).\n(b) If it is not, decompose R into a set of relations that are in BCNF using a lossless‑join decomposition. List the resulting relations and their attributes.

A. R1(A,B), R2(B,C,D), R3(D,E), R4(A,D)

B. R1(A,B), R2(B,C), R3(C,D,E), R4(A,D)

C. R1(A,B), R2(B,C,D), R3(D,E), R4(A,B,C)

Correct D. R1(A,B), R2(B,C,D), R3(D,E), R4(A,C,D)

Correct Answer: D

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

Question 7 View Details

Consider the following pseudo‑code:\n\n``` count = 0 for i = 1 to n: for j = i to n: if (j mod i == 0): count = count + 1 ```\n\n(a) Express the total number of times the statement `count = count + 1` is executed as a summation involving $n$.\n(b) Using that expression, determine the asymptotic order of growth of the algorithm (Big‑O notation).\n(c) Evaluate the exact number of executions when $n = 12$.

A. 30

Correct B. 35

C. 36

D. 28

Correct Answer: B

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

Question 8 View Details

The following grouped data show the scores (out of 100) of 30 students in a mathematics test.\n\n| Score interval | Frequency | |----------------|-----------| | 40 - 49 | 3 | | 50 - 59 | 7 | | 60 - 69 | 10 | | 70 - 79 | 6 | | 80 - 89 | 3 | | 90 - 99 | 1 | \nAssume that each score in a class interval is represented by the class midpoint.\n\n(a) Estimate the mean score.\n(b) Estimate the standard deviation (use the population formula).\n(c) Determine the 75th percentile (P75) using linear interpolation within the appropriate class interval.\n(d) Based on the mean and the median (which you should also estimate), comment on the skewness of the distribution.

Correct A. Mean ≈ 65.17; Standard deviation ≈ 12.36; P75 ≈ 75.4; Distribution is negatively skewed (mean < median).

B. Mean ≈ 62.50; Standard deviation ≈ 13.80; P75 ≈ 73.1; Distribution is symmetric (mean ≈ median).

C. Mean ≈ 70.00; Standard deviation ≈ 10.00; P75 ≈ 80.0; Distribution is negatively skewed (mean > median).

D. Mean ≈ 68.23; Standard deviation ≈ 11.45; P75 ≈ 78.2; Distribution is positively skewed (mean > median).

Correct Answer: A

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

Question 9 View Details

Convert the decimal number 156 to its binary representation and to its hexadecimal representation.

A. Binary: 10011011; Hexadecimal: 9B

Correct B. Binary: 10011100; Hexadecimal: 9C

C. Binary: 11100100; Hexadecimal: E4

D. Binary: 10011100; Hexadecimal: 9D

Correct Answer: B

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

Question 10 View Details

A spreadsheet contains the monthly sales (in thousands of dollars) for a company in cells A2:A13 as follows:\n\n| Month | Sales (A) |\n|-------|-----------|\n| Jan | 1200 |\n| Feb | 1350 |\n| Mar | 1280 |\n| Apr | 1500 |\n| May | 1600 |\n| Jun | 1580 |\n| Jul | 1700 |\n| Aug | 1650 |\n| Sep | 1800 |\n| Oct | 1900 |\n| Nov | 1850 |\n| Dec | 2000 |\n\nIn column B (cells B3:B13) you are to calculate the month‑over‑month percentage change using the formula in B3 and copying it down.\n\n(a) Write the formula that should be entered in B3 (using relative and absolute references) to compute the percentage change from January to February.\n(b) Using the data above, determine the average of all **positive** percentage changes for the year. Give your answer rounded to two decimal places.

A. 10.12%

B. 8.47%

Correct C. 9.53%

D. 7.95%

Correct Answer: C

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

Question 11 View Details

A spreadsheet contains the following data (columns A to E): - Row 2: Item = Pen, Quantity = 8, Unit Price = 120, Discount % = (determined by rule), Total = ? - Row 3: Item = Notebook, Quantity = 15, Unit Price = 250, Discount % = (determined by rule), Total = ? - Row 4: Item = Eraser, Quantity = 12, Unit Price = 50, Discount % = (determined by rule), Total = ? - Row 5: Item = Marker, Quantity = 5, Unit Price = 300, Discount % = (determined by rule), Total = ? The discount rule is: if the Quantity is greater than 10, a discount of 5 % is applied; otherwise no discount is given. The Total for each row is calculated as (\text{Total}=\text{Quantity}\times\text{Unit Price}\times(1-\text{Discount})\). What is the sum of the Total values for rows 2 to 5?

Correct A. 6592.5

B. 6375

C. 6780

D. 6441.0

Correct Answer: A

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

Question 12 View Details

Add the binary numbers $101101$ and $11011$. Express the sum in decimal notation.

A. 68

B. 70

Correct C. 72

D. 74

Correct Answer: C

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

Question 13 View Details

An IP address is given as $172.20.45.10$. Determine its class (A, B, or C) and state the default subnet mask for that class.

Correct A. Class B, 255.255.0.0

B. Class A, 255.0.0.0

C. Class B, 255.255.255.0

D. Class C, 255.255.255.0

Correct Answer: A

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

Question 14 View Details

A word‑processing document contains a title page (which is not numbered), a table of contents that occupies 3 pages, a main text of 120 pages, and a bibliography of 5 pages. Automatic page numbering starts at 1 on the first numbered page (the first page of the table of contents). What page number will appear on the last page of the main text?

A. 128

B. 124

Correct C. 123

D. 122

Correct Answer: C

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

Question 15 View Details

In a small office network, five PCs (PC1-PC5) are connected to an 8‑port Ethernet switch, which in turn is linked to a router that provides Internet access. All PCs use static IPv4 addresses in the 192.168.1.0/24 network with gateway 192.168.1.1 (the router). The observed behaviour is: - PC1 can ping the router and access the Internet. - PC2 can ping PC1 but cannot ping the router or reach the Internet. - PC3 can ping the router but cannot reach the Internet. - PC4 cannot ping any other device, including the router. - PC5 can access the Internet but cannot ping PC3. A network administrator discovers that the router's firewall has the following rules: 1. Block all ICMP (ping) traffic from IP addresses ending in .20 and .40. 2. Block all outbound traffic (including HTTP, HTTPS, etc.) from the IP address ending in .30. 3. Allow all other traffic. Assuming the hardware (switch, cables, and PCs) is functioning correctly, identify the single faulty component or configuration that best explains all the symptoms, and justify your answer.

A. The static IP address assignments on the PCs (incorrect subnet masks or gateways) is the faulty component.

B. The switch's port configuration (such as an incorrect VLAN assignment) is the faulty component.

C. The router's routing table (missing default route) is the faulty component.

Correct D. The router's firewall configuration (the rules blocking ICMP from .20 and .40 and blocking all outbound traffic from .30) is the faulty component.

Correct Answer: D

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

Question 16 View Details

Consider the following pseudocode: ``` count = 0 for i = 1 to n for j = i to n if (i + j) mod 3 = 0 count = count + 1 ``` If (n = 12), how many times is the statement `count = count + 1` executed?

A. 30

B. 28

Correct C. 26

D. 24

Correct Answer: C

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

Question 17 View Details

A company maintains two tables. - **Employees**(EmpID, DeptID, Salary) contains 8 rows. - **Departments**(DeptID, ManagerID, Budget) contains 5 rows. Each employee belongs to exactly one department. Exactly three departments have a Budget greater than $100{,}000$ naira, and each department can have at most three employees. If we perform a natural join of **Employees** and **Departments** and then select only those rows where Salary $> 50{,}000$ and Budget $> 100{,}000$, what is the maximum possible number of rows in the resulting relation?

Correct A. 8

B. 9

C. 12

D. 6

Correct Answer: A

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

Question 18 View Details

A presentation consists of 20 slides. Each slide is shown for a default of 30 seconds. For every third slide the presenter adds an animation that adds 12 seconds, and for every fifth slide a video clip adds 45 seconds. If a slide is both a multiple of 3 and 5 (i.e., slide 15), both additions apply. The presenter decides to skip the last two slides. What is the total presentation time in minutes and seconds?

A. 12 minutes 57 seconds

Correct B. 12 minutes 27 seconds

C. 12 minutes 15 seconds

D. 13 minutes 42 seconds

Correct Answer: B

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

Question 19 View Details

A system employs three independent security controls in series: a firewall, an intrusion detection system (IDS), and authentication. - The probability that an external attack bypasses the firewall is $0.02$. - Given it bypasses the firewall, the probability that the IDS fails to detect it is $0.05$. - If it passes both, the probability that authentication is compromised is $0.10$. - Independently, there is an insider threat that directly compromises authentication with probability $0.01$. What is the overall probability that an attack results in unauthorized access?

A. 0.000100

Correct B. 0.010099

C. 0.010100

D. 0.010990

Correct Answer: B

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

Question 20 View Details

In a typical operating system a process can be in one of five states: New, Ready, Running, Waiting, or Terminated. The system currently has 12 processes with the following conditions: - The number of processes in the Ready state is twice the number in the Running state. - The number of processes in the Waiting state equals the number in the New state. - Exactly one process is in the Terminated state. - The number of processes in the Ready state is less than the number in the Waiting state. How many processes are in the Running state?

A. 3

B. 4

C. 2

Correct D. 1

Correct Answer: D

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

Question 21 View Details

A system stores passwords using a salted SHA‑256 hash. An attacker can compute $2^{30}$ hash operations per second. The password policy requires passwords of length $12$ characters, each character can be an uppercase letter (26), a lowercase letter (26), a digit (10) or a special character (12). Additionally, each password must contain at least one digit and at least one special character. Assuming the attacker performs an exhaustive search and on average needs to try half of the possible passwords, estimate the expected cracking time in years. Round your answer to the nearest thousand years.

A. 300000

Correct B. 286000

C. 285000

D. 290000

Correct Answer: B

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

Question 22 View Details

A company has been allocated the IPv4 block $192.168.0.0/22$. It needs subnets for three departments requiring at least 120, 50 and 30 usable host addresses respectively. Using variable‑length subnet masking (VLSM), determine:\n1. The broadcast address of the subnet that satisfies the 120‑host requirement.\n2. The total number of usable IP addresses that remain unassigned after all three subnets are created. Provide the broadcast address in dotted‑decimal notation and the number of unused usable addresses as an integer.

A. Broadcast: 192.168.0.143, Unused: 796

B. Broadcast: 192.168.0.255, Unused: 768

C. Broadcast: 192.168.0.191, Unused: 820

Correct D. Broadcast: 192.168.0.127, Unused: 804

Correct Answer: D

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

Question 23 View Details

A word‑processing document is to be printed on A4 paper (210 mm × 297 mm) with 1‑inch margins on all sides. The text uses Times New Roman 12‑pt font, single‑spaced. Assume the average character width is half the font size (i.e., 6 pt ≈ 0.083 in) and that each word averages five letters plus one space (six characters). How many whole pages are required to accommodate a manuscript of 4 500 words? Round up to the next whole page.

Correct A. 7

B. 10

C. 8

D. 6

Correct Answer: A

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

Question 24 View Details

A report contains 3 000 words of plain English text (average six characters per word, each stored as one byte in UTF‑8) and three photographs. Each photograph has a resolution of 1920 × 1080 pixels and a colour depth of 24 bits per pixel. The photographs are saved as JPEG files with a compression ratio of 10 : 1. In addition, the document format adds a formatting overhead equal to 5 % of the combined size of text and images. Estimate the total file size of the report in megabytes (MB), rounded to two decimal places. (1 MB = $2^{20}$ bytes.)

A. 2.10

Correct B. 1.89

C. 1.75

D. 2.05

Correct Answer: B

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

Question 25 View Details

Convert the decimal number 156 to an 8‑bit binary representation, then write that binary number in hexadecimal. Finally, find the one's complement of the 8‑bit binary number and give the resulting value in hexadecimal.

A. 0x64

B. 0x39

Correct C. 0x63

D. 0x9C

Correct Answer: C

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

city guilds model questions vol1 2018 information_technology | Objective

Master the Exam!

Help others prepare! Share this practice hub: