BPSC Assistant Director (ICT) May 2025 – Written question & solution

Questions from the BPSC Assistant Director (ICT) recruitment exam, May 2025 – Written, shared by the candidates who sat it. The paper: 9 written questions. So far 9 written questions have been shared. Topics include ERD, SQL, Normalization, Logic Gate and Boolean Algebra.

Written (9)

  1. (a) Design an ER diagram for a library management system where: (i) A library has multiple books. (ii) Each book can have multiple copies…
  2. (a) Consider the following logic circuit with inputs A, B, C and D. (i) Derive the Boolean expressions algebraically for T1 through T4…
  3. (a) Consider a computer system with the following specifications: Physical memory (RAM): 4 GB Page size: 4 KB Virtual address space: 32…
  4. (a) A network has been assigned the IP address 200.1.2.0/24. It has 3 subnets. Determine the following for each subnet: (i) Total number…
  5. (a) Describe the following terms: (i) Supervised learning (ii) Unsupervised learning (iii) Reinforcement learning (b) Given the following…
  6. (a) Write a program in any high-level language to read an integer and display a pattern like the one below. For example, if the given…
  7. (a) Apply Kruskal's algorithm to the following graph to find the cost of the minimum spanning tree (MST). The graph is undirected; the…
  8. (a) What is 2-factor authentication? Describe it with an example. (b) What is a hash table? What are the advantages of using a hash table?…
  9. Rewrite the following sentences using the instruction given in the brackets: (a) She explained me the matter. [Correct the sentence] (b)…