SQL questions
10 job-exam questions on SQL from 10 papers — BPSC, BUET, BCC and more — with answers and discussion.
Papers
- November 2026 – Preliminary (BSCS) — SPCBL · Assistant Manager (General)
- October 2026 – Written (BPSC) — BPSC · Assistant Programmer (CSE)
- October 2026 – Written (BIBM) — Combined Bank · Assistant Programmer (CSE)
- October 2026 – Written (BUET) — BUET · MSC (CSE)
- October 2026 – Written (BUET) — BPDB · Assistant Engineer (CSE)
- October 2025 – Written (BCC) — BCC · Assistant Programmer (CSE)
- June 2025 – Written (BUET) — BUET · Assistant Programmer (CSE)
- June 2025 – Written (BUET) — DPDC · Assistant Manager (ICT)
- May 2025 – Written (BPSC) — BPSC · Assistant Director (ICT)
- February 2025 – Written (BUET) — BCIC · Assistant Programer (CSE)
Questions
- Consider the following database schema. Find the employees whose manager's region is the same as that of the employee working under him…
- (a) Design an ER diagram for a library management system where: (i) A library has multiple books. (ii) Each book can have multiple copies…
- SQL output problem: Find the salary of employees from a table where the salary is more than 5000.
- Which SQL command removes a table along with its structure?
- Given two tables: Students(studentid, name, ...) Enrollment(studentid, course, grade) a) Write an SQL query to retrieve all student names…