Combined Bank Assistant Database Administrator May 2026 – Written question & solution

Questions from the Combined Bank Assistant Database Administrator recruitment exam, May 2026 – Written, shared by the candidates who sat it. The paper: 14 written questions. So far 14 written questions have been shared. Topics include DBMS, Computer Architecture, Computer Networks, Software Engineering and Computer Basics.

Written (14)

  1. A bank plans to upgrade its storage system for transaction processing. The system must continue operating even if a single hard drive…
  2. A data center supporting 24/7 online banking services experiences occasional hardware failures and service interruptions. Explain how…
  3. An ISP has been assigned the networks 192.168.0.0/24, 192.168.1.0/24, 192.168.2.0/24, and 192.168.3.0/24. To reduce routing table entries…
  4. A database contains a table named Hospital(HospitalID, HospitalName, Specialization, PatientCount). Write an SQL query to display the…
  5. A developer writes the SQL statement SELECT EmployeeName, Salary FROM Employees WHERE Salary > AVG(Salary);, but the query generates an…
  6. Given the relation Employee(EmployeeID, NationalID, Email, Name, Department), where EmployeeID, NationalID, and Email are unique, identify…
  7. A mobile banking application successfully connects to a server and attempts to upload a customer document, but the server rejects the…
  8. A bank is considering replacing its relational database system with MongoDB for its core banking application. Discuss whether this is an…
  9. A relation R(A, B, C) is decomposed into R1(A, B) and R2(B, C). Explain whether the decomposition is lossless and describe the conditions…
  10. A bank hosts its online banking platform on a public cloud infrastructure. Due to a cloud service outage, customers are unable to access…
  11. A network administrator is replacing a hub-based LAN with a switch-based LAN. Explain the differences between half-duplex and full-duplex…
  12. A bank is migrating from a monolithic application to a microservices architecture and plans to deploy an API Gateway. Explain the role of…
  13. A cloud service provider must choose between ARM-based processors and x86 processors for a new data center deployment. Compare the RISC…
  14. A government mobile application receives frequent user feedback that requires weekly feature updates, while strict regulatory policies…