NWPGCL Assistant Manager (ICT) Exam 12 January 2024 — Question Solution | নর্থ-ওয়েস্ট পাওয়ার (এনডব্লিউপিজিসিএল) সহকারী ব্যবস্থাপক (আইসিটি) নিয়োগ পরীক্ষা ২০২৪ — প্রশ্ন সমাধান
Page updated
ARBS Academy · itjobs.arbsacademy.com
About this exam paper · প্রশ্নপত্র পরিচিতি
The NWPGCL Assistant Manager (ICT) exam was held on 12 January 2024, conducted by BUET. The paper had 5 written questions. The subjects asked most were Networking (2), Database (1) and Programming (1). This page lists every question, with 2 answered and explained; the rest of the answers open with a free ARBS Academy account, where the paper can also be practised as a timed test.
নর্থ-ওয়েস্ট পাওয়ার (এনডব্লিউপিজিসিএল) সহকারী ব্যবস্থাপক (আইসিটি) নিয়োগ পরীক্ষার (২০২৪) এই প্রশ্নপত্রে ৫টি প্রশ্ন ছিল, বেশিরভাগ নেটওয়ার্কিং ও ডেটাবেজ থেকে। এখানে ২টি প্রশ্নের ব্যাখ্যাসহ উত্তর দেওয়া আছে; বাকিগুলো ফ্রি অ্যাকাউন্টে খোলে।
- Organisation
- NWPGCL
- Post
- Assistant Manager (ICT)
- Exam date
- 12 January 2024
- Conducted by
- BUET
- Questions
- 5 (0 MCQ, 5 written)
- Exam guide
- Government IT officer posts · সরকারি প্রতিষ্ঠানের আইটি পদ
Tax program. Slabs: first 2,50,000 tax-free; next up to 5,00,000 at 10%; next up to 10,00,000 at 20%; above 10,00,000 at 30%. (a) Write a program to compute employees' total tax. (b) Among three employees, find the highest taxpayer.
Product(pname, price, category, maker), Purchase(buyer, seller, store, product), Company(cname, country), Person(name, address, phone); maker → Company.cname, buyer/seller → Person.name, product → Product.pname. Draw the ER diagram, then write the queries.
(a) People who bought products made by American companies.
(b) Total value of products per country of origin (listed, and actually sold).
Sign up free to see the model answers to written questions 1–2 · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন
An IP address 192.168.1.50 with subnet mask 255.255.255.240. Find the network address, broadcast address and valid host range.
Model answer
Given: IP = 192.168.1.50, subnet mask = 255.255.255.240
Step 1: mask in binary and prefix length
255.255.255.240 = 11111111.11111111.11111111.11110000 → 28 network bits → /28, leaving 4 host bits.
Step 2: block size (subnet increment)
Block size = 256 − 240 = 16 (= 2⁴). Subnets in the last octet start at 0, 16, 32, 48, 64, …
Step 3: find the block that holds .50
48 ≤ 50 < 64, so 192.168.1.50 lies in the block 48–63.
| Subnet | Network | Host range | Broadcast |
|---|---|---|---|
| previous | 192.168.1.32 | .33 – .46 | 192.168.1.47 |
| this one | 192.168.1.48 | .49 – .62 | 192.168.1.63 |
| next | 192.168.1.64 | .65 – .78 | 192.168.1.79 |
Step 4: binary check
IP 11000000.10101000.00000001.00110010 192.168.1.50
Mask 11111111.11111111.11111111.11110000 255.255.255.240
AND -> 11000000.10101000.00000001.00110000 192.168.1.48 (network)
Wildcard 00000000.00000000.00000000.00001111 0.0.0.15
Network OR wildcard
-> 11000000.10101000.00000001.00111111 192.168.1.63 (broadcast)
The last octet shows it directly: 50 = 0011 0010; keeping the top 4 bits and zeroing the host bits gives 0011 0000 = 48; setting the host bits to 1 gives 0011 1111 = 63.
Step 5: usable hosts
Usable hosts = 2⁴ − 2 = 14 (the network and broadcast addresses cannot be given to a host).
Answer
| Item | Value |
|---|---|
| Prefix | /28 (block size 16) |
| Network address | 192.168.1.48 |
| Broadcast address | 192.168.1.63 |
| First valid host | 192.168.1.49 |
| Last valid host | 192.168.1.62 |
| Valid host range | 192.168.1.49 – 192.168.1.62 (14 hosts) |
Quick check: 48 + 16 − 1 = 63 for the broadcast, and 62 − 49 + 1 = 14 hosts.
Exam tip: block size = 256 − (mask octet that is not 255); network = the largest multiple of the block size not above the IP's octet; broadcast = next boundary − 1; hosts lie strictly between them.
A company must choose between buying software (Tk 50 lakh), building it (Tk 40 lakh if easy, probability 0.3; Tk 50 lakh if hard, 0.7) or modifying open-source software (Tk 30 lakh for small changes, 0.2; Tk 50 lakh for large changes, 0.8). Which should it choose?
Model answer
This is a decision under risk: each option has possible costs with known probabilities, so we compare the expected cost (expected monetary value, EMV) and choose the lowest, because these are costs, not profits.
Expected cost = Σ (probability × cost)
flowchart LR
D{"Decision: how to get the software?"}
D -->|"Buy"| B["Cost Tk 50 lakh (certain)"]
D -->|"Build"| C1(("Chance node: EV 47"))
D -->|"Modify open-source"| C2(("Chance node: EV 46"))
C1 -->|"Easy, p = 0.3"| E1["Tk 40 lakh"]
C1 -->|"Hard, p = 0.7"| E2["Tk 50 lakh"]
C2 -->|"Small changes, p = 0.2"| E3["Tk 30 lakh"]
C2 -->|"Large changes, p = 0.8"| E4["Tk 50 lakh"]
Each chance node's probabilities add up to 1 (0.3 + 0.7 = 1; 0.2 + 0.8 = 1), so the data are consistent.
Step-by-step (roll back the tree)
| Option | Outcomes | Expected cost |
|---|---|---|
| Buy | 50 with p = 1 | 1 × 50 = 50.0 lakh |
| Build | 40 (p = 0.3), 50 (p = 0.7) | 0.3 × 40 + 0.7 × 50 = 12 + 35 = 47.0 lakh |
| Modify open-source | 30 (p = 0.2), 50 (p = 0.8) | 0.2 × 30 + 0.8 × 50 = 6 + 40 = 46.0 lakh |
Decision: modify the open-source software. Its expected cost (Tk 46 lakh) is the lowest: Tk 1 lakh below building and Tk 4 lakh below buying.
Why this is also safe
- Worst case: every option can end at Tk 50 lakh, so choosing to modify adds no extra downside risk.
- Best case: modifying can cost only Tk 30 lakh, the lowest possible outcome.
Sensitivity (how firm is the choice?)
- Let s = probability of small changes. EV(modify) = 30s + 50(1 − s) = 50 − 20s. Modify beats build (47) when 50 − 20s < 47, i.e. s > 0.15. With s = 0.2 the margin is small.
- Let e = probability that building is easy. EV(build) = 50 − 10e. Build would win only if 50 − 10e < 46, i.e. e > 0.4.
So if the estimate of small changes falls below 0.15, or the chance that building is easy rises above 0.4, the choice flips to building.
Other factors a manager should weigh (not in the numbers): delivery time, licence terms of the open-source code, in-house skills to maintain it, vendor support and security updates.
Exam tip: draw the tree, multiply each outcome by its probability, add them at each chance node, and pick the minimum for costs (maximum for profits).
Draw BER vs SNR curves for BPSK and QPSK.
Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন
Explanations © ARBS Academy
Questions about this paper · সাধারণ প্রশ্ন
- How many questions were in the NWPGCL Assistant Manager (ICT) exam (2024)?
- 5 written questions.
- Which subjects were asked most in the NWPGCL Assistant Manager (ICT) exam (2024)?
- Networking (2), Database (1) and Programming (1), out of 5 questions.
- When was the NWPGCL Assistant Manager (ICT) exam held?
- On 12 January 2024, conducted by BUET.
- Where can I find the NWPGCL Assistant Manager (ICT) exam (2024) question solution?
- On this page: 2 of the 5 questions are shown with worked answers. The rest of the answers open with a free ARBS Academy account, where the paper can also be practised as a timed test.
Question text is from the public recruitment exam; answers and explanations are written by ARBS Academy. All past papers