Bangladesh Submarine Cables PLC, AM(Engineering), 2024
Bangladesh Submarine Cables PLC

Post: Assistant Maintenance Engineer
Exam Date: 08/05/2026

1. See the following Table:
Employees(EMP_ID, EMP_Name, Manager_ID, Dept_ID);
Departments(Dept_ID, Salary, Dept_Name, Emp_ID);

1(a) Find out the names of manager of each employee.
SELECT e.EMP_Name AS Employee,
       m.EMP_Name AS Manager
FROM Employees e
LEFT JOIN Employees m
ON e.Manager_ID = m.EMP_ID;
1 b) Sort the employees of each department based on salary in descending order
SELECT e.EMP_Name, d.Dept_Name, d.Salary
FROM Employees e
JOIN Departments d
ON e.EMP_ID = d.Emp_ID
ORDER BY d.Dept_ID, d.Salary DESC;

You must subscribe & Login to view more.

Don’t have an account? Register

Or your subscription is under review by admin. Please message on WhatsApp / Telegram.

Sonali Bank PLC, Assistant Database Administrator, 2026
ADA • Year 2026
Sonali Bank
💼Post Name: Assistant Database Administrator 📅Exam Date: 09-Jan-2026
    • 1
      Computer NetworkSubnetting
      Given IP address 192.168.1.0 and divided four subnets in equal size: A) find the new subnet mask (CIDR) B) find out first usable host address of subnetting
      Given:
      • IP Address = 192.168.1.0
      • Default mask = /24
      • Required subnets = 4
      A) New Subnet Mask (CIDR)
      • Required subnets = 4 = 2²
      • So, borrowed bits = 2
      • New CIDR = /24 + 2 = /26
      • Subnet Mask = 255.255.255.192
      B) First Usable Host Address of Each Subnet
      • Subnet 1: 192.168.1.0/26 → First usable host = 192.168.1.1
      • Subnet 2: 192.168.1.64/26 → First usable host = 192.168.1.65
      • Subnet 3: 192.168.1.128/26 → First usable host = 192.168.1.129
      • Subnet 4: 192.168.1.192/26 → First usable host = 192.168.1.193

    • 2
      Operating System
      You friend device is slow performing so what should you take step in your task manager

      Steps to Fix Slow Device Using Task Manager

      • Open Task Manager: Press Ctrl + Shift + Esc.
      • Check CPU Usage: Identify processes using high CPU.
      • Check Memory (RAM): Find apps consuming too much memory.
      • End Unnecessary Tasks: Select heavy apps → click End Task.
      • Startup Programs: Go to Startup tab → disable unnecessary apps.
      • Disk Usage: Check if disk is 100% → stop heavy processes.
      • Background Apps: Close unused background applications.

    • 3
      Computer SecurityDifferent Attacks
      Suppose your workstation affect ransomware attack so what five step you take to mitigate this problem

      Ransomware Attack

      Ransomware is a type of malware that encrypts or locks a user's data and demands ransom (money) to restore access.

      • It spreads through phishing emails, malicious downloads, or infected websites.

      Steps to Mitigate Ransomware Attack

      • 1. Isolate the System: Immediately disconnect the workstation from network (LAN/Wi-Fi) to stop spreading.
      • 2. Do Not Pay Ransom: Paying does not guarantee data recovery and encourages attackers.
      • 3. Identify & Remove Malware: Use antivirus / anti-malware tools to scan and remove ransomware.
      • 4. Restore Data from Backup: Recover files from secure offline or cloud backup.
      • 5. Report & Recover: Inform IT/security team, update system, patch vulnerabilities, and change all passwords.

    • 4
      Computer SecurityDifferent Attacks
      What is Phishing? Describe different type of phishing attack

      Phishing is a type of cyber attack where attackers trick users into revealing sensitive information like passwords, OTP, or bank details by pretending to be a trusted entity.

      Types of Phishing Attacks

      • Email Phishing: Fake emails that look like banks or companies asking for login details.
      • Spear Phishing: Targeted attack on a specific person or organization using personalized information.
      • Smishing (SMS Phishing): Fraud messages sent via SMS with malicious links.
      • Vishing (Voice Phishing): Attackers call users pretending to be bank officials to collect information.
      • Clone Phishing: A legitimate email is copied and modified with a malicious link.
      • Pharming: Redirects users to a fake website even if they enter the correct URL.

    • 5
      Design Analysis of AlgorithmDynamic Programming
      What is Dynamic Programming? Related Question

      Dynamic Programming

      Dynamic Programming (DP) is a method used to solve problems by breaking them into smaller subproblems and storing their results to avoid repeated computation.

      Key Idea:

      • Solve each subproblem once and store the result.
      • Reuse stored results (called memoization or tabulation).

      Characteristics:

      • Overlapping Subproblems: Same subproblems are solved multiple times.
      • Optimal Substructure: Optimal solution can be built from optimal sub-solutions.

      Example

      • Fibonacci Series
      • Knapsack Problem
      • Shortest Path (e.g., Bellman-Ford)

      Advantages:

      • Reduces time complexity.
      • Improves efficiency by avoiding repeated work.

    • 6
      Object Oriented ProgrammingBasic
      What is programming? Give 4 example. Difference between structured and OOP programming

      Programming

      Programming is the process of writing instructions (code) that a computer follows to perform specific tasks.

      Examples of Programming Languages

      • C
      • Java
      • Python
      • C++

      Difference Between Structured Programming and OOP

      FeatureStructured ProgrammingObject-Oriented Programming (OOP)
      ApproachFunction-basedObject-based
      FocusProcedures/FunctionsObjects & Classes
      Data HandlingData and functions are separateData and methods are combined (Encapsulation)
      ReusabilityLimitedHigh (Inheritance, Polymorphism)
      ExamplesCJava, C++, Python


    • 7
      Computer SecurityFirewall
      What is firewall? Difference between stateful inspection and new technology firewall (NTFW)

      A firewall is a network security system that monitors and controls incoming and outgoing traffic based on predefined security rules.

      Difference Between Stateful Inspection Firewall and NGFW (Next Generation Firewall)

      FeatureStateful Inspection FirewallNGFW (New Technology Firewall)
      WorkingTracks connection state of packetsPerforms deep packet inspection
      Security LevelMedium securityHigh security
      Application AwarenessNot supportedSupported
      Threat DetectionBasic filteringAdvanced (IPS, malware detection)
      User ControlIP-basedUser & application-based
      FeaturesPacket filtering + state trackingWAF, IPS, DPI, SSL inspection

    • 8
      Computer SecurityFirewall
      Firewall rules Rules 1: A source destain B port is 89. Rules 2: A source destain B less than 443; Rules 3: A source destain B port is 443. So when a packet come form 443 is it accept or rejected the procedure “First inspection rules” explain it

      Given Rules:

      • Rule 1: Source A → Destination B, port = 89
      • Rule 2: Source A → Destination B, port < 443
      • Rule 3: Source A → Destination B, port = 443

      First-Match Rule Inspection:

      • Firewall checks rules from top to bottom.
      • As soon as a packet matches a rule, action is taken and no further rules are checked.

      Case: Packet arrives with port = 443

      • Check Rule 1: port 89 → ❌ Not matched
      • Check Rule 2: port < 443 → ❌ 443 is NOT less than 443
      • Check Rule 3: port = 443 → ✅ Matched

      Final Decision:

      • The packet will follow Rule 3.
      • If Rule 3 action = ALLOW → packet accepted ✅
      • If Rule 3 action = DENY → packet rejected ❌


    • 9
      Software EngineeringTesting
      Define software testing level. show that unit, integration, system and user acceptance testing. How these are complemented of each other

      Software Testing Level : Software Testing Levels are the different stages of testing used to verify and validate that software works correctly and meets requirements.

      Types of Testing Levels

      1. Unit Testing

      • Definition: Testing of the smallest individual unit (function/module) of a program.
      • Purpose: To check each part works correctly.
      • Performed by: Developer.

      2. Integration Testing

      • Definition: Testing of combined modules to verify interaction between them.
      • Purpose: To find interface/communication errors.

      3. System Testing

      • Definition: Testing of the complete system as a whole.
      • Purpose: To ensure system meets functional and non-functional requirements.

      4. User Acceptance Testing (UAT)

      • Definition: Final testing performed by end users.
      • Purpose: To confirm system meets business needs and is ready for deployment.

      How They Complement Each Other

      • Unit Testing: Ensures each component is correct.
      • Integration Testing: Ensures components work together.
      • System Testing: Ensures the whole system works properly.
      • UAT: Ensures system satisfies user requirements.
      • These levels work step-by-step from small parts to full system, ensuring complete quality assurance.

    • 10
      Software EngineeringFlowchart
      ATM pin code flow chart (user input define). decision take (successful, failure)


    • 11
      Computer NetworkProtocol
      What is DNS? How DNS work?

      DNS (Domain Name System)

      DNS is a system that translates domain names (like google.com) into IP addresses (like 142.250.190.78). It works like the phonebook of the internet.

      How DNS Works:

      • 1. User Request: User enters a domain name (e.g., www.google.com) in the browser.
      • 2. DNS Resolver: The request goes to a DNS resolver (usually ISP or local cache).
      • 3. Root Server: If not cached, resolver queries the Root DNS server.
      • 4. TLD Server: Root server directs to TLD server (.com, .org).
      • 5. Authoritative Server: TLD server provides the authoritative DNS server for the domain.
      • 6. IP Address Returned: Authoritative server returns the IP address.
      • 7. Connection: Browser uses the IP to connect to the website.

      Example:

      • User types www.facebook.com
      • DNS converts it to an IP (e.g., 157.240.x.x)
      • Browser connects to that IP and loads the website

General PartBangla focus: নারী উদ্যোক্তা উন্নয়নে সামাজিক যোগাযোগ মাধমের ভূমিকা
English focus: Earthquake Risk management and mitigation
Bangla to English Translation
English to Bangla Translation

Leave a Comment

WhatsApp Telegram Messenger