Uttara Bank PLC — Senior Officer (CSE/IT) Model Question Written Test 2025

Time: 1 Hour 30 Minutes (1:30 hrs)     Full Marks: 100

UTTARA BANK PLC

Senior Officer (CSE/IT) — Model Written Test

Instructions: Read the questions carefully. Answer exactly as directed. Write neatly. Use allotted time wisely.

SECTION – A: SHORT QUESTIONS (10 × 3 = 30 Marks)

Answer any TEN (10) questions. Each question carries 3 marks.

1. What is SDLC? Explain its phases briefly.
2. Define Operating System. Write any four functions of an OS.
3. What is Cloud Computing? Mention its types.
4. Define IPv4 and IPv6 with examples.
5. What is Subnet Mask? Explain with an example.
6. What is RAID? Why is RAID used in servers?
7. Difference between TCP and UDP.
8. What is DNS? How does it work?
9. Define Firewall and mention its types.
10. What is Database Normalization? Explain 1NF and 2NF.
11. What is Virtualization? Mention two hypervisors.
12. Write short notes on: (a) VLAN (b) NAT

SECTION – B: NETWORK & SECURITY (5 × 6 = 30 Marks)

Answer any FIVE (5) questions. Each question carries 6 marks.

1. Explain the OSI Model with the function of each layer.
2. What is DHCP? Describe how a device obtains an IP address using DHCP (include DHCP message flow).
3. What are ARP and RARP? Explain their purpose and show simple request/response diagrams.
4. Explain Public IP vs Private IP with examples and mention private ranges for classes A, B, and C.
5. What is the difference between a Switch, a Router, and a Hub? Give practical use-cases for each.
6. Explain SSL/TLS. Why is it essential for online banking transactions?
7. List and explain three major cyber security threats that banks commonly face and basic mitigation measures for each.

আরও পড়ুনঃ

SECTION – C: DATABASE & PROGRAMMING (4 × 5 = 20 Marks)

Answer any FOUR (4) questions. Each question carries 5 marks.

1. Define Primary Key and Foreign Key. Provide SQL examples to create two related tables (Employees and Departments) showing keys.
2. Write SQL queries for:
   a) Display all employees whose salary > 40,000.
   b) Count the number of transactions recorded today (assume a table transactions with a date column).
3. What is the ACID property in DBMS? Explain Atomicity, Consistency, Isolation and Durability with short examples.
4. Write a simple program (C or Python) to find the largest number in an integer array. (Show code and brief explanation.)
5. Explain indexing in databases. Why is indexing important in Core Banking Systems (CBS)?

SECTION – D: NETWORKING & SYSTEM DESIGN PROBLEMS (2 × 10 = 20 Marks)

Answer any TWO (2) questions. Each question carries 10 marks.

1. Subnetting Problem (10 Marks)
   Your bank branch network is 192.168.10.0/24. You need 4 equal subnets.
   1. Calculate the new subnet mask (CIDR notation and dotted-decimal).
   2. Calculate the number of usable hosts per subnet.
   3. List the network address, first usable IP, last usable IP and broadcast address for each subnet.
2. Network Design for a Branch (10 Marks)
   Design a simple network for a bank branch with the following resources:
   1. 1 Router, 2 Switches, 40 PCs, 2 Servers (CBS Server & Backup Server), 2 VLANs (HR and General Banking), Internet link plus 4G backup modem.
   2. Draw a labeled network diagram (hand-drawn or described), propose an IP addressing plan (subnet per VLAN), and explain VLAN segmentation and routing between VLANs (mention if router-on-stick or Layer-3 switch is used).
3. Optional System Design (alternative to above) — Online Banking Login System (10 Marks)
   Provide a short system design covering:
   1. Authentication flow (login, OTP, session handling).
   2. Database tables required (users, login_attempts, otp_logs).
   3. Security features: Captcha, rate-limiting, IP blocking, account lockout, encryption at rest and in transit.
   4. Logging and audit requirements.

SECTION – E: BANKING TECHNOLOGY (Any 1 × 10 = 10 Marks)

Answer any ONE (1) question. Each question carries 10 marks.

1. Explain the role of ICT in modern banking. Provide examples of how ICT improves customer service and operational efficiency.
2. What is a Core Banking System (CBS)? Describe a high-level CBS architecture and key components (transaction engine, GL, customer master, teller module).
3. Discuss digital banking risks (fraud, phishing, account takeover, third-party risk) and describe technical and procedural mitigations banks use.

End of Question Paper

Note to candidates: If you would like, I can provide a fully worked answer key for this model test, sample solutions for the subnetting and SQL questions, and a downloadable PDF version formatted for printing. Please tell me which you prefer.

Time: 1 Hour 30 Minutes (1:30 hrs)     Full Marks: 100

UTTARA BANK PLC

Senior Officer (CSE/IT) — Model Written Test (Paper II)

Instructions: Answer as directed. Use clear diagrams where required. Marks are indicated for each section. No extra sheets unless permitted.

SECTION – A: VERY SHORT QUESTIONS (12 × 2 = 24 Marks)

Answer any TWELVE (12) questions. Each question carries 2 marks.

1. Define Virtual Memory.
2. What is a MAC Address? Give its format.
3. What does HTTPS mean and why use it?
4. Define Backup and Recovery in DBMS (brief).
5. What is OAuth (one-line)?
6. Mention two examples of PaaS providers.
7. What is a Load Balancer? (one-line)
8. Write the default gateway purpose in one sentence.
9. What is a CAPTCHA and why is it used?
10. Define 'Hot Standby' in server context.
11. What is JSON? (short)
12. Give one difference between SSD and HDD.

SECTION – B: SHORT ANSWER QUESTIONS (6 × 6 = 36 Marks)

Answer any SIX (6) questions. Each question carries 6 marks.

1. Explain RAID 5: structure, advantages, and a typical use-case in banks.
2. Explain DNS hierarchy and the role of root and authoritative name servers.
3. Describe the differences between symmetric and asymmetric encryption with examples.
4. Explain the concept of Session Management in web applications and common vulnerabilities.
5. What is a Proxy Server? Describe forward and reverse proxy use-cases.
6. Explain the principle of 'Least Privilege' and its importance in bank IT environments.
7. Describe how two-factor authentication (2FA) enhances security; give two 2FA methods.

SECTION – C: PRACTICAL / DATABASE (3 × 8 = 24 Marks)

Answer any THREE (3) questions. Each question carries 8 marks.

1. SQL Task:
   Given a table accounts(account_id INT, customer_id INT, balance DECIMAL, status VARCHAR) write SQL queries for:
   a) List accounts with balance < 1000.00.
   b) Increase balance by 5% for active accounts.
   c) Delete accounts flagged 'closed' older than 365 days (assume a closed_date exists).
2. Programming Task:
   Write a Python function that accepts a list of transaction amounts (positive for credit, negative for debit) and returns the final balance and number of overdrafts (balance < 0). Show example input/output.
3. DB Design:
   Design simple table structures for an ATM transaction log. Include fields for transaction_id, atm_id, account_no (masked), txn_type, amount, timestamp, status, and machine_location. Show SQL CREATE TABLE for the log and mention indexes you would create.

SECTION – D: NETWORK DESIGN & PROBLEMS (2 × 8 = 16 Marks)

Answer any TWO (2) questions. Each question carries 8 marks.

1. Subnetting:
   You have network 10.10.0.0/22. Create 4 subnets with equal size.
   a) Give the new subnet mask and CIDR.
   b) List network address and usable IP range for each subnet.
2. High Availability Design:
   Propose a simple high-availability setup for a core banking application using two application servers, two database servers (primary + replica), a load balancer, and shared storage. Draw/describe components and failover behavior.
3. Alternative (optional):
   Explain how NAT and PAT work in a small branch with 30 hosts sharing a single public IP. Include an example mapping.

SECTION – E: BANKING & IT MANAGEMENT (Any 1 × 10 = 10 Marks)

Answer any ONE (1) question. Each question carries 10 marks.

1. Explain Core Banking System (CBS) testing types (unit, integration, UAT, regression) and why each is important before go-live.
2. Discuss Disaster Recovery Planning for a bank: RTO, RPO, alternate site types (cold, warm, hot) and a short runbook for failover.
3. Explain vendor risk management in banking IT: what checks should a bank perform before onboarding a third-party software vendor?

Time: 1 Hour 30 Minutes (1:30 hrs)     Total Marks: 100

UTTARA BANK PLC

Senior Officer (CSE/IT) — Model Written Test (Model Test #3 – IMPORTANT)

Instructions: Attempt all questions as directed. Show diagrams wherever needed. Use clear and concise answers.

SECTION – A: SHORT QUESTIONS (10 × 3 = 30 Marks)

Answer any TEN (10). Each question carries 3 marks.

1. What are the main responsibilities of a Database Administrator (DBA)?
2. Explain the term “Checksum” and its use in networking.
3. What is API? Mention two examples used in banking applications.
4. Write short notes on: (a) Deadlock (b) Semaphore.
5. What is Encryption? Distinguish between AES and RSA.
6. What is Multi-threading? Give one real-life example.
7. Explain the purpose of a Kernel inside an Operating System.
8. What is Docker? Why is containerization popular?
9. Write the difference between Static and Dynamic Routing.
10. What is “Failover”? Explain with a banking example.
11. Define Big Data. Mention any two Big Data technologies.
12. What is a Log File? Why are logs important in banking servers?

SECTION – B: NETWORKING & SECURITY (5 × 6 = 30 Marks)

Answer any FIVE (5). Each question carries 6 marks.

1. Explain Firewall architecture and write differences between stateful and stateless firewalls.
2. Describe how HTTPS works. Include SSL handshake steps.
3. Explain VLAN Trunking. How does 802.1Q tagging work?
4. What is Man-in-the-Middle (MITM) attack? Explain two methods to prevent it.
5. Describe DMZ (Demilitarized Zone) and its importance in bank network security.
6. Explain how a Router uses Routing Table with an example.
7. Describe IPsec. Mention its modes and uses in banking VPN.

SECTION – C: DATABASE & SYSTEM DESIGN (3 × 8 = 24 Marks)

Answer any THREE (3). Each question carries 8 marks.

1. SQL Task:
   Given tables:
   customers(customer_id, name, phone)
transactions(txn_id, customer_id, amount, txn_date, type)
   
   Write SQL for:
   a) List total transaction amount per customer.
   b) Find customers who made no transactions this month.
   c) Display highest transaction amount of each type.
2. System Design Task:
   Design a small-scale **Loan Management System** including:
   a) Key modules (Loan processing, Approval workflow, EMI generator).
   b) Required database tables.
   c) Security controls (audit logs, data validation, access roles).
   
3. Programming Task:
   Write a C or Python program to validate a user login by checking:
   - Username length (min 4 chars)
   - Password must contain a number
   - Print "Login Valid" or "Invalid Credentials"
   Include sample input & output.

SECTION – D: NETWORKING PROBLEMS (2 × 8 = 16 Marks)

Answer any TWO (2). Each carries 8 marks.

1. Subnetting Task:
   Your network is 172.16.0.0/20.
   Create **8 subnets** and provide:
   a) New subnet mask.
   b) Network address of each subnet.
   c) Usable range & broadcast of first two subnets.
2. Branch Network Diagram:
   Design a network for a branch containing:
   - 1 Router
   - 3 Switches
   - 60 Staff PCs
   - 3 VLANs (IT, Teller, General Banking)
   - UTM Firewall
   - Internet + MPLS link to Head Office
   Include IP plan and inter-VLAN routing concept.
3. Alternate Task:
   Write how a Load Balancer works. Compare L4 vs L7 load balancing. Give an example relevant to banking applications.

SECTION – E: BANKING & IT GOVERNANCE (Any 1 × 10 = 10 Marks)

Answer any ONE (1).

1. What is ICT Governance? Explain COBIT Framework and its relevance in banking.
2. Explain Business Continuity Plan (BCP) steps for a bank during a major system outage.
3. Discuss Cybersecurity Operation Center (SOC) activities and why a bank needs SOC monitoring 24/7.