Previous (2020-2026) Officer (IT) QnS
Combined Bank, Officer IT, 2026 (Based year 2024)
- ☆1Non Technical Question
1. Focus Writing in Bangla: “বাংলাদেশের ব্যাংকিং খাতে খেলাপি ঋণ: কারণ, প্রভাব ও উত্তরণের উপায়”
2. Focus Writing in Englsih: "The Role of Sustainable Banking in Achieving the UN Sustainable Development Goals (SDGs) in Bangladesh."
3.Translate the following passage into English
“এক ক্ষুধার্ত শিয়াল একটি আঙুর ক্ষেতের পাশ দিয়ে যাচ্ছিল। উঁচুতে ঝোলানো আঙুর দেখে সে তা খাওয়ার চেষ্টা করল, কিন্তু বারবার লাফিয়েও ব্যর্থ হলো । অবশেষে সে হতাশ হয়ে চলে গেল । যাওয়ার সময় বলল, আঙুরগুলো আসলে টক।”
4.Translate the following passage into Bangla
"The boy found a lost wallet on his way to school. Instead of keeping it, he looked for the owner and returned it. The owner, impressed by his honesty, offered him a reward. The boy politely refused, saying that honesty is its own reward."
5.General Knowledge
5.1 Which river is known as the "Lifeline of Bangladesh"?
5.2 What is the name of the international organization that monitors global health standards and coordinates the response to pandemics?
5.3 What is the name of Bangladesh's first deep-sea port?
5.4 Where is the headquarters of the International Monetary Fund (IMF) located?
5.5 Which country has the world's longest coastline? - ☆2MiscellaneousDifferentiate between a Fuse and a Miniature Circuit Breaker (MCB). Which one is more suitable for modern office electrical installations and why?
Difference Between Fuse and Miniature Circuit Breaker (MCB)
Fuse Miniature Circuit Breaker (MCB) A Fuse protects an electrical circuit by melting its metal wire when excessive current flows. An MCB protects an electrical circuit by automatically switching off (tripping) when an overload or short circuit occurs. Works only once; it must be replaced after it blows. Can be reset and reused after the fault is cleared. Slower and less convenient to restore power. Provides faster and more reliable protection. Maintenance cost is higher because the fuse needs replacement. Lower maintenance cost since it is reusable. Provides only basic overcurrent protection. Provides better protection against Overload and Short Circuit. Which is More Suitable for Modern Office Installations?
Miniature Circuit Breaker (MCB) is more suitable for modern office electrical installations because it provides fast and reliable protection, can be reset without replacement, reduces maintenance cost, improves safety, and minimizes downtime after electrical faults.
Fuse এবং Miniature Circuit Breaker (MCB)-এর মধ্যে পার্থক্য
Fuse Miniature Circuit Breaker (MCB) Fuse অতিরিক্ত Current প্রবাহিত হলে ভিতরের ধাতব তার গলে Circuit বিচ্ছিন্ন করে। MCB Overload বা Short Circuit হলে স্বয়ংক্রিয়ভাবে Trip করে Circuit বিচ্ছিন্ন করে। একবার নষ্ট হলে নতুন Fuse লাগাতে হয়। Fault দূর করার পরে পুনরায় Reset করে ব্যবহার করা যায়। Power পুনরুদ্ধারে তুলনামূলক বেশি সময় লাগে। দ্রুত এবং নির্ভরযোগ্যভাবে Circuit সুরক্ষা দেয়। বারবার পরিবর্তন করতে হওয়ায় Maintenance Cost বেশি। পুনর্ব্যবহারযোগ্য হওয়ায় Maintenance Cost কম। শুধুমাত্র মৌলিক Overcurrent Protection প্রদান করে। Overload এবং Short Circuit উভয়ের বিরুদ্ধে উন্নত সুরক্ষা প্রদান করে। আধুনিক Office Electrical Installation-এর জন্য কোনটি উপযুক্ত?
আধুনিক Office Electrical Installation-এর জন্য Miniature Circuit Breaker (MCB) বেশি উপযুক্ত। কারণ এটি দ্রুত Trip করে Circuit সুরক্ষা দেয়, পুনরায় Reset করে ব্যবহার করা যায়, Maintenance Cost কম, নিরাপত্তা বেশি এবং Electrical Fault-এর পর দ্রুত বিদ্যুৎ সরবরাহ পুনরুদ্ধার করা সম্ভব।
- ☆3MiscellaneousExplain the working principle of a PN junction diode. Draw its symbol and describe the difference between forward bias and reverse bias.
PN Junction Diode
Working Principle
A PN Junction Diode is a semiconductor device formed by joining P-type and N-type semiconductor materials. At the junction, a Depletion Region is formed, creating a potential barrier that controls the flow of current.
When the diode is Forward Biased, the potential barrier decreases, allowing current to flow easily. When it is Reverse Biased, the potential barrier increases, preventing the flow of current except for a very small leakage current.
Symbol of PN Junction Diode
Difference Between Forward Bias and Reverse Bias
Forward Bias Reverse Bias P-side is connected to the positive (+) terminal and N-side to the negative (−) terminal. P-side is connected to the negative (−) terminal and N-side to the positive (+) terminal. The Depletion Region becomes thinner. The Depletion Region becomes wider. Current flows easily through the diode. Current is blocked except for a small leakage current. The diode acts as a closed switch (ON). The diode acts as an open switch (OFF). Conclusion
A PN Junction Diode allows current to flow in only one direction. Therefore, it is widely used in Rectifiers, Voltage Regulators, Signal Processing, and Protection Circuits.
PN Junction Diode
কার্যপ্রণালী (Working Principle)
PN Junction Diode হলো একটি Semiconductor Device, যা P-type এবং N-type Semiconductor যুক্ত করে তৈরি করা হয়। সংযোগস্থলে একটি Depletion Region সৃষ্টি হয়, যা একটি Potential Barrier তৈরি করে এবং Current-এর প্রবাহ নিয়ন্ত্রণ করে।
যখন Diode-কে Forward Bias করা হয়, তখন Potential Barrier কমে যায় এবং সহজে Current প্রবাহিত হয়। আর Reverse Bias করলে Potential Barrier বৃদ্ধি পায়, ফলে খুব সামান্য Leakage Current ছাড়া প্রায় কোনো Current প্রবাহিত হয় না।
PN Junction Diode-এর Symbol
Forward Bias এবং Reverse Bias-এর পার্থক্য
Forward Bias Reverse Bias P-side Positive (+) Terminal এবং N-side Negative (−) Terminal-এর সাথে সংযুক্ত থাকে। P-side Negative (−) Terminal এবং N-side Positive (+) Terminal-এর সাথে সংযুক্ত থাকে। Depletion Region পাতলা হয়ে যায়। Depletion Region প্রশস্ত হয়ে যায়। সহজে Current প্রবাহিত হয়। অতি সামান্য Leakage Current ছাড়া Current প্রবাহিত হয় না। Diode একটি Closed Switch (ON) হিসেবে কাজ করে। Diode একটি Open Switch (OFF) হিসেবে কাজ করে। উপসংহার
PN Junction Diode শুধুমাত্র একদিকে Current প্রবাহিত হতে দেয়। তাই এটি Rectifier, Voltage Regulator, Signal Processing এবং Protection Circuit-এ ব্যাপকভাবে ব্যবহৃত হয়।
- ☆4Object Oriented ProgrammingExplain the concepts of Inheritance and Polymorphism in Java. Write a Java program to demonstrate method overriding.
Inheritance
Inheritance is an Object-Oriented Programming (OOP) feature in which one class (child/subclass) acquires the properties and methods of another class (parent/superclass). It promotes Code Reusability, Extensibility, and easier maintenance.
Polymorphism
Polymorphism means "many forms." It allows the same method to perform different behaviors depending on the object that invokes it. In Java, Method Overriding is an example of Runtime Polymorphism.
Java Program: Demonstration of Method Overriding
class Animal { void sound() { System.out.println("Animal makes a sound"); } } class Dog extends Animal { @Override void sound() { System.out.println("Dog barks"); } } public class Main { public static void main(String[] args) { Animal obj = new Dog(); obj.sound(); } }Output
Dog barks
Explanation
The Dog class inherits the Animal class and overrides the sound() method. At runtime, the overridden method of the Dog class is executed, demonstrating Method Overriding and Runtime Polymorphism.
- ☆5Web TechnologyDescribe any two key differences between the HTTP GET and HTTP POST methods used for communication between a web browser and a web server.
Difference Between HTTP GET and HTTP POST Methods
HTTP GET HTTP POST GET sends data as part of the URL (Query String). POST sends data inside the HTTP Request Body. Suitable for retrieving data from the server. Suitable for submitting, creating, or updating data on the server. Data is visible in the browser URL and has length limitations. Data is not visible in the URL and can send large amounts of data. Can be cached and bookmarked. Cannot normally be cached or bookmarked. Example
GET: Searching products on an e-commerce website.
POST: Submitting a registration form or logging into a website.Conclusion
GET is mainly used to retrieve data, whereas POST is used to send data securely to the server for processing.
HTTP GET এবং HTTP POST Method-এর মধ্যে পার্থক্য
HTTP GET HTTP POST GET Method Data-কে URL-এর Query String হিসেবে পাঠায়। POST Method Data-কে HTTP Request Body-এর মাধ্যমে পাঠায়। Server থেকে Data Retrieve করার জন্য ব্যবহৃত হয়। Server-এ Data Submit, Create অথবা Update করার জন্য ব্যবহৃত হয়। Data Browser-এর URL-এ দৃশ্যমান থাকে এবং Data Size সীমিত। Data URL-এ দৃশ্যমান থাকে না এবং বড় আকারের Data পাঠানো যায়। Bookmark এবং Cache করা যায়। সাধারণত Bookmark বা Cache করা যায় না। উদাহরণ
GET: E-commerce Website-এ Product Search করা।
POST: Registration Form Submit করা বা Website-এ Login করা।উপসংহার
GET মূলত Server থেকে Data আনার জন্য ব্যবহৃত হয়, আর POST Server-এ Data নিরাপদভাবে পাঠিয়ে Process করার জন্য ব্যবহৃত হয়।
- ☆6Data Center & VirtualizationA physical server has 32 CPU cores, 96 GB RAM, and 4 TB storage. Each virtual machine (VM) requires 4 CPU cores, 16 GB RAM, and 500 GB storage. Calculate the maximum number of VMs that can be hosted on the server without overcommitting resources. Identify which hardware resource limits the number of VMs.
Maximum Number of Virtual Machines (VMs)
Given:
Physical Server Resources:
• CPU Cores = 32
• RAM = 96 GB
• Storage = 4 TB = 4000 GB (approximately)Each VM Requires:
• CPU = 4 Cores
• RAM = 16 GB
• Storage = 500 GBStep 1: Calculate VMs Supported by Each Resource
CPU: 32 ÷ 4 = 8 VMs
RAM: 96 ÷ 16 = 6 VMs
Storage: 4000 ÷ 500 = 8 VMsStep 2: Determine the Maximum Number of VMs
Maximum VMs = Minimum of (8, 6, 8)
Maximum Number of VMs = 6
Limiting Hardware Resource
The RAM (96 GB) is the limiting resource because it supports only 6 VMs, whereas the CPU and Storage can each support 8 VMs.
Final Answer
Maximum VMs = 6
Limiting Resource = RAM (Memory)
- ☆7Structure Query LanguageAn institute wants to create a database table named STUDENT to store student information. The table should include the columns Roll Number, Name, Department, Email, and Admission Date. Specify the most appropriate SQL data type for each column and identify which column should be defined as the Primary Key, giving a brief justification for your choice.
Table Structure with Appropriate SQL Data Types
Column Name SQL Data Type Reason RollNumber INT Stores numeric roll numbers efficiently. Name VARCHAR(100) Stores student names of variable length. Department VARCHAR(50) Stores department names such as CSE, EEE, BBA, etc. Email VARCHAR(100) Stores email addresses of varying lengths. AdmissionDate DATE Stores only the admission date in YYYY-MM-DD format. Primary Key
RollNumber should be defined as the Primary Key because it uniquely identifies each student record, does not allow duplicate values, and cannot contain NULL values.
Sample SQL Statement
CREATE TABLE STUDENT ( RollNumber INT PRIMARY KEY, Name VARCHAR(100), Department VARCHAR(50), Email VARCHAR(100), AdmissionDate DATE );
- ☆8Computer NetworkSubnettingAn organization has been assigned the IPv4 network address 192.168.1.0/24. As part of the network deployment, the network administrator is required to divide the address space into four equal-sized subnets to support different departments. Determine the Network Address, Subnet Mask (both CIDR and dotted-decimal notation)
Subnetting of 192.168.1.0/24 into Four Equal-Sized Subnets
To divide the network 192.168.1.0/24 into 4 equal-sized subnets:
• Original Prefix = /24
• Number of Required Subnets = 4 = 2²
• Borrowed Bits = 2
• New Prefix = /26
• Subnet Mask = 255.255.255.192Subnet Details
Subnet Network Address CIDR Subnet Mask Broadcast Address Usable Host Range Subnet 1 192.168.1.0 /26 255.255.255.192 192.168.1.63 192.168.1.1 – 192.168.1.62 Subnet 2 192.168.1.64 /26 255.255.255.192 192.168.1.127 192.168.1.65 – 192.168.1.126 Subnet 3 192.168.1.128 /26 255.255.255.192 192.168.1.191 192.168.1.129 – 192.168.1.190 Subnet 4 192.168.1.192 /26 255.255.255.192 192.168.1.255 192.168.1.193 – 192.168.1.254 Final Answer
Network Addresses: 192.168.1.0, 192.168.1.64, 192.168.1.128, 192.168.1.192
Subnet Mask (CIDR): /26
Subnet Mask (Dotted Decimal): 255.255.255.192
- ☆9Computer SecurityDifferent AttacksDifferentiate between a Computer Virus and a Computer Worm based on how they spread and replicate across host networks.
Difference Between a Computer Virus and a Computer Worm
Computer Virus Computer Worm A Computer Virus is a malicious program that attaches itself to a host file or program. A Computer Worm is a standalone malicious program that does not require a host file. It spreads when the infected file or program is executed by the user. It spreads automatically across networks without any user action. Requires user interaction to replicate. Replicates automatically by exploiting network or system vulnerabilities. Usually spreads through infected files, email attachments, USB drives, or software downloads. Usually spreads through network connections and security vulnerabilities. Generally spreads more slowly. Spreads very rapidly across host networks. May corrupt or modify files and programs. Consumes network bandwidth and system resources, and may install other malware. Conclusion
The main difference is that a Computer Virus requires a host file and user action to spread, whereas a Computer Worm is a standalone program that replicates automatically across networks without user intervention.
Computer Virus এবং Computer Worm-এর মধ্যে পার্থক্য
Computer Virus Computer Worm Computer Virus হলো একটি Malicious Program, যা কোনো Host File বা Program-এর সাথে যুক্ত থাকে। Computer Worm হলো একটি Standalone Malicious Program, যা Host File-এর প্রয়োজন হয় না। Infected File বা Program Execute করলে এটি ছড়ায়। User-এর কোনো Action ছাড়াই Network-এর মাধ্যমে স্বয়ংক্রিয়ভাবে ছড়িয়ে পড়ে। Replication-এর জন্য User Interaction প্রয়োজন হয়। Network বা System-এর Vulnerability ব্যবহার করে স্বয়ংক্রিয়ভাবে Replicate করে। সাধারণত Infected File, Email Attachment, USB Drive অথবা Software Download-এর মাধ্যমে ছড়ায়। সাধারণত Network Connection এবং Security Vulnerability-এর মাধ্যমে ছড়ায়। তুলনামূলক ধীরগতিতে ছড়ায়। Host Network জুড়ে খুব দ্রুত ছড়িয়ে পড়ে। File বা Program ক্ষতিগ্রস্ত বা পরিবর্তন করতে পারে। Network Bandwidth এবং System Resource ব্যবহার করে এবং অতিরিক্ত Malware Install করতে পারে। উপসংহার
মূল পার্থক্য হলো, Computer Virus ছড়ানোর জন্য Host File এবং User Action প্রয়োজন হয়, কিন্তু Computer Worm একটি Standalone Program, যা User-এর হস্তক্ষেপ ছাড়াই Host Network-এ স্বয়ংক্রিয়ভাবে Replicate ও ছড়িয়ে পড়ে।
- ☆10Computer SecurityDifferent AttacksDescribe the SQL Injection and Cross-Site Scripting (XSS) web security threats and suggest preventive measures for each.
SQL Injection (SQLi) and Cross-Site Scripting (XSS)
1. SQL Injection (SQLi)
SQL Injection is a web security vulnerability in which an attacker inserts malicious SQL statements into user input fields. If the application does not properly validate the input, the attacker can execute unauthorized database queries to read, modify, or delete data.
Preventive Measures
• Use Prepared Statements (Parameterized Queries).
• Validate and sanitize all user inputs.
• Apply the Principle of Least Privilege for database accounts.
• Avoid constructing SQL queries using string concatenation.2. Cross-Site Scripting (XSS)
Cross-Site Scripting (XSS) is a vulnerability in which an attacker injects malicious JavaScript or other client-side scripts into a trusted web page. When another user visits the page, the malicious script executes in the user's browser.
Preventive Measures
• Validate and sanitize user input.
• Encode HTML output before displaying user-supplied data.
• Use a Content Security Policy (CSP).
• Store sensitive cookies with the HttpOnly and Secure attributes.Conclusion
SQL Injection targets the Database, whereas XSS targets the User's Browser. Proper input validation, output encoding, and secure coding practices are essential to prevent both attacks.
SQL Injection (SQLi) এবং Cross-Site Scripting (XSS)
১. SQL Injection (SQLi)
SQL Injection হলো একটি Web Security Vulnerability, যেখানে আক্রমণকারী User Input-এর মাধ্যমে ক্ষতিকর SQL Query প্রবেশ করায়। যদি Application Input সঠিকভাবে Validate না করে, তাহলে আক্রমণকারী Database-এর Data পড়তে, পরিবর্তন করতে বা মুছে ফেলতে পারে।
প্রতিরোধের উপায়
• Prepared Statement (Parameterized Query) ব্যবহার করতে হবে।
• সকল User Input Validate এবং Sanitize করতে হবে।
• Database Account-এ Least Privilege নীতি অনুসরণ করতে হবে।
• String Concatenation ব্যবহার করে SQL Query তৈরি করা যাবে না।২. Cross-Site Scripting (XSS)
Cross-Site Scripting (XSS) হলো এমন একটি Vulnerability, যেখানে আক্রমণকারী ক্ষতিকর JavaScript বা অন্যান্য Client-side Script Web Page-এ Inject করে। অন্য কোনো User সেই Page Visit করলে Browser-এ ওই Script Execute হয়।
প্রতিরোধের উপায়
• সকল User Input Validate এবং Sanitize করতে হবে।
• User-এর Data প্রদর্শনের আগে HTML Output Encoding করতে হবে।
• Content Security Policy (CSP) ব্যবহার করতে হবে।
• Cookie-তে HttpOnly এবং Secure Attribute ব্যবহার করতে হবে।উপসংহার
SQL Injection মূলত Database-কে লক্ষ্য করে, আর XSS ব্যবহারকারীর Browser-কে লক্ষ্য করে। সঠিক Input Validation, Output Encoding এবং Secure Coding Practice অনুসরণ করলে এই দুই ধরনের আক্রমণ প্রতিরোধ করা যায়।
- ☆11Digital Logic DesignUniversal GateDraw the circuit schematic diagrams to build an Exclusive-OR (XOR) logic function using only universal NAND gates.XOR gate: (Using 4 NAND Gates)[ Previous Buet Pattern Question]


- ☆12Digital Logic DesignMultiplexer/DemultiplexerWhat is the difference between a Multiplexer and a Demultiplexer? Explain one practical application of each in digital systems.
Difference Between Multiplexer (MUX) and Demultiplexer (DEMUX)
Multiplexer (MUX) Demultiplexer (DEMUX) A Multiplexer (MUX) is a digital circuit that selects one input from multiple input lines and forwards it to a single output line. A Demultiplexer (DEMUX) is a digital circuit that receives data from one input line and routes it to one of multiple output lines. Many Inputs → One Output. One Input → Many Outputs. Uses Select Lines to choose one input. Uses Select Lines to choose the destination output. Acts as a Data Selector. Acts as a Data Distributor. Reduces the number of communication lines. Distributes data to different devices or destinations. Practical Applications
Multiplexer (MUX):
Used in Communication Systems to transmit multiple signals over a single communication channel, reducing wiring and transmission cost.Demultiplexer (DEMUX):
Used at the receiving end of Communication Systems to separate the received data and deliver it to the correct output device or destination.Conclusion
A Multiplexer combines multiple input signals into one output, whereas a Demultiplexer distributes one input signal to one of many outputs. They are widely used together in digital communication and data transmission systems.
Multiplexer (MUX) এবং Demultiplexer (DEMUX)-এর মধ্যে পার্থক্য
Multiplexer (MUX) Demultiplexer (DEMUX) Multiplexer (MUX) হলো একটি Digital Circuit, যা একাধিক Input Line থেকে একটি Input নির্বাচন করে একটি Output Line-এ পাঠায়। Demultiplexer (DEMUX) হলো একটি Digital Circuit, যা একটি Input Line-এর Data-কে একাধিক Output Line-এর মধ্যে নির্দিষ্ট একটি Output-এ পাঠায়। অনেক Input → একটি Output। একটি Input → অনেক Output। Select Line ব্যবহার করে Input নির্বাচন করে। Select Line ব্যবহার করে কোন Output-এ Data যাবে তা নির্ধারণ করে। Data Selector হিসেবে কাজ করে। Data Distributor হিসেবে কাজ করে। Communication Line-এর সংখ্যা কমাতে সাহায্য করে। Data বিভিন্ন Device বা Destination-এ বিতরণ করতে ব্যবহৃত হয়। ব্যবহারিক প্রয়োগ
Multiplexer (MUX):
Communication System-এ একাধিক Signal-কে একটি Communication Channel-এর মাধ্যমে প্রেরণের জন্য ব্যবহৃত হয়, ফলে Wiring এবং Transmission Cost কমে।Demultiplexer (DEMUX):
Communication System-এর Receiver Side-এ প্রাপ্ত Data-কে সঠিক Device বা Output Line-এ বিতরণ করার জন্য ব্যবহৃত হয়।উপসংহার
Multiplexer (MUX) একাধিক Input থেকে একটি Output নির্বাচন করে, আর Demultiplexer (DEMUX) একটি Input-কে একাধিক Output-এর মধ্যে নির্দিষ্ট একটিতে বিতরণ করে। Digital Communication এবং Data Transmission System-এ এ দুটি Circuit ব্যাপকভাবে ব্যবহৃত হয়।
- ☆13Structure Query LanguageSQLWhat is JDBC? Explain the steps required to connect a Java application to a MySQL database.
JDBC (Java Database Connectivity)
JDBC (Java Database Connectivity) is a standard Java API that enables Java applications to connect to relational databases such as MySQL, Oracle, SQL Server, and PostgreSQL. It allows applications to execute SQL queries, retrieve data, and update database records.
Steps to Connect a Java Application to a MySQL Database
- Add the MySQL JDBC Driver
Include the MySQL Connector/J library (JAR file) in the Java project. - Import JDBC Packages
Import the required package:import java.sql.*; - Load the JDBC Driver
Load the MySQL JDBC driver.Class.forName("com.mysql.cj.jdbc.Driver"); - Establish the Database Connection
Create a connection using the database URL, username, and password.Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/mydb", "root", "password"); - Create a Statement
Create a Statement or PreparedStatement object.Statement stmt = con.createStatement(); - Execute SQL Queries
Execute SQL commands using the statement object.ResultSet rs = stmt.executeQuery("SELECT * FROM student"); - Process the Result
Read data from the ResultSet.while(rs.next()){ System.out.println(rs.getInt("id") + " " + rs.getString("name")); } - Close Resources
Close the ResultSet, Statement, and Connection objects.rs.close(); stmt.close(); con.close();
Conclusion
JDBC provides a standard way for Java applications to communicate with MySQL databases through the steps: Load Driver → Connect → Create Statement → Execute SQL → Process Result → Close Connection.
- Add the MySQL JDBC Driver
- ☆14Computer NetworkNetwork Topology & DevicesDescribe the functions of a Switch and a Router and explain two key differences between these networking devices.
Switch and Router
Functions of a Switch
A Switch is a networking device that connects multiple devices within the same Local Area Network (LAN). It forwards data frames to the correct destination using MAC Addresses, improving network efficiency and reducing unnecessary traffic.
Functions of a Router
A Router is a networking device that connects two or more different networks, such as a LAN and the Internet. It forwards data packets between networks using IP Addresses and determines the best path for packet delivery.
Key Differences Between Switch and Router
Switch Router Operates mainly at the Data Link Layer (Layer 2) of the OSI model. Operates at the Network Layer (Layer 3) of the OSI model. Uses MAC Addresses to forward data within the same network. Uses IP Addresses to route packets between different networks.
Switch এবং Router
Switch-এর কাজ
Switch হলো একটি Networking Device, যা একই Local Area Network (LAN)-এর একাধিক Device-কে সংযুক্ত করে। এটি MAC Address ব্যবহার করে Data Frame সঠিক Device-এ পাঠায়, ফলে Network Traffic কমে এবং Communication আরও কার্যকর হয়।
Router-এর কাজ
Router হলো একটি Networking Device, যা দুই বা ততোধিক ভিন্ন Network (যেমন LAN এবং Internet) সংযুক্ত করে। এটি IP Address ব্যবহার করে Data Packet-এর সর্বোত্তম পথ নির্ধারণ করে এবং এক Network থেকে অন্য Network-এ পাঠায়।
Switch এবং Router-এর দুটি প্রধান পার্থক্য
Switch Router OSI Model-এর Data Link Layer (Layer 2)-এ কাজ করে। OSI Model-এর Network Layer (Layer 3)-এ কাজ করে। একই Network-এর মধ্যে Data পাঠাতে MAC Address ব্যবহার করে। ভিন্ন Network-এর মধ্যে Packet পাঠাতে IP Address ব্যবহার করে।
- ☆15Operating SystemProcess Scheduling Algorithm
A system has three processes with the following arrival times and CPU burst times:
Process Arrival Time (ms) Burst Time (ms) P1 0 5 P2 1 3 P3 2 2 Using the First-Come, First-Served (FCFS) CPU scheduling algorithm, calculate the average waiting time and the average turnaround time.

- ☆16Software EngineeringBasic & SDLCA software company has been hired to develop an Online Library Management System for a university. The librarian wants the system to be delivered in phases so that feedback from users can be incorporated after each release. As a software developer, identify the most suitable Software Development Life Cycle (SDLC) model for this project. Justify your choice by mentioning two advantages of the selected model.
Suitable SDLC Model for the Online Library Management System
The most suitable Software Development Life Cycle (SDLC) model for this project is the Incremental Model.
Justification
The university librarian wants the system to be delivered in phases, allowing users to provide feedback after each release. The Incremental Model develops and delivers the software in multiple increments, enabling improvements based on user feedback before the next release.
Advantages of the Incremental Model
1. Early Delivery of Software:
The system is delivered in small functional releases, allowing users to start using important features earlier.2. Easy Incorporation of User Feedback:
Feedback received after each release can be incorporated into subsequent increments, resulting in a system that better meets user requirements.Conclusion
The Incremental Model is the best choice because it supports phased delivery, continuous user feedback, and gradual enhancement of the Online Library Management System.
Online Library Management System-এর জন্য উপযুক্ত SDLC Model
এই Project-এর জন্য সবচেয়ে উপযুক্ত Software Development Life Cycle (SDLC) Model হলো Incremental Model।
যৌক্তিকতা
University-এর Librarian চান System-টি ধাপে ধাপে (Phases) Deliver করা হোক, যাতে প্রতিটি Release-এর পরে User-এর Feedback নিয়ে পরবর্তী Version-এ উন্নয়ন করা যায়। Incremental Model-এ Software-কে একাধিক Increment-এ Develop ও Release করা হয়, ফলে প্রতিটি ধাপে Feedback অনুযায়ী পরিবর্তন করা সহজ হয়।
Incremental Model-এর দুটি সুবিধা
১. দ্রুত কার্যকর Software সরবরাহ:
সম্পূর্ণ Project শেষ হওয়ার অপেক্ষা না করে গুরুত্বপূর্ণ Feature-গুলো ধাপে ধাপে ব্যবহারকারীর কাছে সরবরাহ করা যায়।২. User Feedback সহজে অন্তর্ভুক্ত করা যায়:
প্রতিটি Release-এর পর প্রাপ্ত Feedback পরবর্তী Increment-এ যুক্ত করা যায়, ফলে System আরও উন্নত ও ব্যবহারকারীর চাহিদা অনুযায়ী তৈরি হয়।উপসংহার
Incremental Model ধাপে ধাপে Software Delivery, ধারাবাহিক User Feedback গ্রহণ এবং পর্যায়ক্রমে System উন্নয়নের সুবিধা প্রদান করে। তাই এটি Online Library Management System-এর জন্য সবচেয়ে উপযুক্ত SDLC Model।
Combined Bank, Officer IT, 2026 (Based year 2023)
Combined Bank, Officer (IT), 2026 (Based year 2022)
Combined Bank , Officer (IT), 2026 (Based year 2022) (MCQ)

Time's up
Combined Bank, Officer (IT), 2024
Sonali n Janata Bank, Officer (IT), 2023
Sonali Bank, Officer (IT), 2021
Combined Bank, Officer (IT), 2020
- ☆1Non Technical QuestionNon Techকোভিট -১৯ এর ক্ষতিকর প্রভাব মোকাবেলায় তথ্য প্রযুক্তির প্রয়োগ ও ভূমিকার উপর সংক্ষিপ্ত রচনা লিখুন।
Translate the following passage into English. করোনার টিকা বাজারে এলে দেশের সবার জন্য তা গ্রহণ করতে চায় সরকার ধারণা করা হচ্ছে, সবার জন্য টিকা সংগ্রহে ১৭ হাজার কোটি টিকার প্রয়োজন হবে। এই অর্থ সংগ্রহে উন্নয়ন সহযোগীদের সহায়তা চাওয়ার সিদ্ধান্ত নিয়েছে সরকার। ধারণা করা হচ্ছে জনপ্রতি দুই ডোজ টিকার প্রয়োজন হতে পারে। এর দাম পড়তে পারে ১০ থেকে ২০ ডলার বা কমবেশি এক হাজার। পরিসংখ্যান ব্যুরোর (বিবিএস) তথ্য অনুযায়ী দেশের জনসংখ্যা এখন ১৬ কোটি ৫০ লাখ সে হিসেবে মোট ১৭ হাজার ২০০ কোটি টাকার প্রয়োজন হবে। স্বাস্থ্য মন্ত্রনালয় থেকে প্রাথমিক এই হিসাব করা হয়েছে বলে ইআরডি সূত্র জানিয়েছে। এই অর্থের চাহিদা মাথায় রেখেই উন্নয়ন সহযোগীদের সহায়তা চাওয়া হচ্ছে।
Translate the following passage into Bengali. Honoring three medical scientists with the Nobel Medicine Prize for their homing in on the Hepatitis C has been widely acclaimed as a landmark achievement on the part of the Nobel Assembly at Karolina Instituted. Awards like this will, undoubtedly, help the Nobel Committee regain a remarkable amount of its earlier prestige tainted by a couple of its decisions and internal scandals. The three Medicine award winners for this year are Americans Harvey Alter and Charles Rice along with Briton Michael Houghton. The world's medicinal research community has enough reasons to feel elated over the recognition extended to the trio. Their joint discovery had turned the page on protracted efforts to find a remedy to Hepatitis C. It is probably the deadliest of the blood-borne hepatitis after Hepatitis A and B.
Write a paragraph on"post-corona Green Recovery Plans and Progress in Bangladesh "in English.
- ☆2Software EngineeringTesting & QualityTesting is an activity that is performed to verify correct behavior of a program. Testing should be conducted in all the stages of program development. Describe different types of tests conducted in the implementation stage.
During the Implementation Stage of the Software Development Life Cycle (SDLC), different types of testing are performed to verify that the software functions correctly and meets the specified requirements.
1. Unit Testing
Unit Testing is performed to test individual modules, functions, or classes independently. It is usually conducted by developers to ensure that each unit works correctly.
2. Integration Testing
Integration Testing verifies that multiple modules work together correctly after integration. It checks the interfaces and data flow between modules.
3. System Testing
System Testing evaluates the complete integrated software system to ensure that it meets all functional and non-functional requirements.
4. Acceptance Testing
Acceptance Testing is performed by customers or end users to verify that the software satisfies business requirements and is ready for deployment. It includes User Acceptance Testing (UAT).
These testing types ensure that the software is reliable, error-free, and ready for deployment by identifying defects at different levels of the implementation stage.
Software Development Life Cycle (SDLC)-এর Implementation Stage-এ Software সঠিকভাবে কাজ করছে কিনা এবং নির্ধারিত Requirement পূরণ করছে কিনা তা নিশ্চিত করার জন্য বিভিন্ন ধরনের Testing করা হয়।
১. Unit Testing
Unit Testing-এ Software-এর প্রতিটি Module, Function বা Class আলাদাভাবে পরীক্ষা করা হয়। সাধারণত এটি Developer দ্বারা সম্পন্ন করা হয়।
২. Integration Testing
Integration Testing-এ একাধিক Module একত্রে যুক্ত করার পরে তাদের মধ্যে Interface এবং Data Flow সঠিকভাবে কাজ করছে কিনা তা পরীক্ষা করা হয়।
৩. System Testing
System Testing-এ সম্পূর্ণ Integrated Software System পরীক্ষা করা হয়, যাতে Functional এবং Non-Functional Requirement পূরণ হয়েছে কিনা নিশ্চিত করা যায়।
৪. Acceptance Testing
Acceptance Testing সাধারণত Customer বা End User দ্বারা পরিচালিত হয়, যাতে নিশ্চিত করা যায় যে Software ব্যবসায়িক Requirement পূরণ করছে এবং ব্যবহারের জন্য প্রস্তুত। এর মধ্যে User Acceptance Testing (UAT) অন্তর্ভুক্ত।
Unit Testing, Integration Testing, System Testing এবং Acceptance Testing Implementation Stage-এর গুরুত্বপূর্ণ ধাপ। এগুলোর মাধ্যমে বিভিন্ন স্তরে Defect শনাক্ত করা যায় এবং নির্ভরযোগ্য Software তৈরি নিশ্চিত করা হয়।
- ☆3Object Oriented ProgrammingInheritanceInheritance is one of important issues for any object oriented programming language. The main advantage of Inheritance is the ability to reuse the code.Explain in brief different types of Inheritance.
Inheritance is one of the fundamental concepts of Object-Oriented Programming (OOP). It allows a new class (Derived Class) to inherit the properties and methods of an existing class (Base Class). This promotes Code Reusability, reduces code duplication, and improves maintainability.
Types of Inheritance
1. Single Inheritance
A single Derived Class inherits from one Base Class.Example:
Animal → Dog2. Multiple Inheritance
A single Derived Class inherits from more than one Base Class. This type is supported in C++ but not directly in Java.Example:
Teacher + Researcher → Professor3. Multilevel Inheritance
A class inherits from another derived class, forming a chain of inheritance.Example:
Animal → Mammal → Dog4. Hierarchical Inheritance
Multiple Derived Classes inherit from a single Base Class.Example:
Animal → Dog, Cat, Cow5. Hybrid Inheritance
A combination of two or more inheritance types (such as Multiple and Multilevel Inheritance). It is commonly implemented using virtual inheritance in C++.Example:
Combination of Single + Multiple + Multilevel Inheritance.Inheritance improves Code Reusability, reduces redundancy, simplifies maintenance, and supports efficient software development by allowing classes to reuse existing features.
Object-Oriented Programming (OOP)-এ বিভিন্ন ধরনের Inheritance
উত্তর:
Inheritance হলো Object-Oriented Programming (OOP)-এর একটি মৌলিক বৈশিষ্ট্য। এর মাধ্যমে একটি Derived Class, একটি Base Class-এর Data Member এবং Member Function উত্তরাধিকারসূত্রে গ্রহণ করতে পারে। ফলে Code Reusability বৃদ্ধি পায়, Code Duplication কমে এবং Software Maintain করা সহজ হয়।
Inheritance-এর প্রকারভেদ
১. Single Inheritance
একটি Derived Class শুধুমাত্র একটি Base Class থেকে Inherit করে।উদাহরণ:
Animal → Dog২. Multiple Inheritance
একটি Derived Class একাধিক Base Class থেকে Inherit করে। এটি C++-এ সমর্থিত হলেও Java-তে সরাসরি সমর্থিত নয়।উদাহরণ:
Teacher + Researcher → Professor৩. Multilevel Inheritance
একটি Derived Class থেকে আবার আরেকটি Derived Class তৈরি হয়। অর্থাৎ Inheritance একাধিক স্তরে ঘটে।উদাহরণ:
Animal → Mammal → Dog৪. Hierarchical Inheritance
একটি Base Class থেকে একাধিক Derived Class তৈরি হয়।উদাহরণ:
Animal → Dog, Cat, Cow৫. Hybrid Inheritance
দুই বা ততোধিক ধরনের Inheritance একত্রে ব্যবহৃত হলে তাকে Hybrid Inheritance বলা হয়। C++-এ এটি সাধারণত Virtual Inheritance ব্যবহার করে বাস্তবায়ন করা হয়।উদাহরণ:
Single Inheritance + Multiple Inheritance + Multilevel Inheritance-এর সমন্বয়।Inheritance Code Reusability বৃদ্ধি করে, Code Duplication কমায়, Software Maintain করা সহজ করে এবং দক্ষ Software Development-এ গুরুত্বপূর্ণ ভূমিকা পালন করে।
- ☆4Data StructureQueueQueue is an abstract data structure. A queue is open at both its ends. One end is always used to insert data (enqueue) and the other is used to remove data (dequeue). Write the steps of Enqueue Operation of Queue.
Enqueue is the operation of inserting a new element into a Queue. Since a Queue follows the FIFO (First In, First Out) principle, a new element is always inserted at the Rear end of the Queue.
Steps of Enqueue Operation
Step 1: Check whether the Queue is full.
Step 2: If the Queue is full, display "Queue Overflow" and stop the operation.
Step 3: If the Queue is empty, set Front = Rear = 0.
Step 4: Otherwise, increment the Rear pointer by 1.
Step 5: Insert the new element at Queue[Rear].
Step 6: End the operation.Algorithm (Enqueue)
START
If Rear = MAX − 1
Print "Queue Overflow"
Else
If Front = -1
Front = Rear = 0
Else
Rear = Rear + 1
Queue[Rear] = Item
END
- ☆5Design Analysis of AlgorithmComplexityThere are no well-defined standards for writing algorithms.Efficiency of an algorithm depends on several factors. Similarly, complexity of an algorithm also depends on several factors. Describe the algorithm complexity factors.
Algorithm Complexity measures the amount of Time and Memory required by an algorithm to solve a problem. It helps compare different algorithms and select the most efficient one.
Factors Affecting Algorithm Complexity
1. Time Complexity
Time Complexity measures the amount of time an algorithm takes to execute as the input size increases. It is commonly expressed using Big-O Notation, such as O(1), O(log n), O(n), O(n log n), and O(n²).2. Space Complexity
Space Complexity measures the amount of memory required by an algorithm during execution. It includes memory used for variables, data structures, recursion, and temporary storage.3. Input Size (n)
The execution time and memory usage usually increase as the input size (n) becomes larger.4. Type of Operations
Algorithms performing complex operations such as nested loops, recursion, or repeated computations generally have higher complexity than algorithms using simple operations.5. Data Structure Used
The choice of data structure (such as Array, Linked List, Stack, or Hash Table) significantly affects the algorithm's performance.The efficiency of an algorithm mainly depends on its Time Complexity and Space Complexity. Selecting appropriate algorithms and data structures helps improve overall system performance.
Algorithm Complexity হলো কোনো Algorithm একটি Problem সমাধান করতে কত Time এবং Memory ব্যবহার করে তার পরিমাপ। এর মাধ্যমে বিভিন্ন Algorithm-এর Efficiency তুলনা করা যায় এবং সবচেয়ে উপযুক্ত Algorithm নির্বাচন করা যায়।
Algorithm Complexity-এর প্রধান Factors
১. Time Complexity
Time Complexity নির্দেশ করে Input Size বৃদ্ধি পেলে Algorithm সম্পন্ন হতে কত সময় লাগে। এটি সাধারণত Big-O Notation যেমন O(1), O(log n), O(n), O(n log n) এবং O(n²) দ্বারা প্রকাশ করা হয়।২. Space Complexity
Space Complexity নির্দেশ করে Algorithm Execute করার সময় কত পরিমাণ Memory প্রয়োজন হয়। এতে Variable, Data Structure, Recursion এবং Temporary Storage-এর Memory অন্তর্ভুক্ত থাকে।৩. Input Size (n)
সাধারণত Input Size (n) যত বড় হয়, Algorithm-এর Time এবং Memory-এর প্রয়োজন তত বৃদ্ধি পায়।৪. Operation-এর ধরন
Nested Loop, Recursion বা বারবার Computation করা Algorithm-এর Complexity সাধারণত বেশি হয়।৫. ব্যবহৃত Data Structure
Array, Linked List, Stack, Queue, Tree বা Hash Table-এর মতো উপযুক্ত Data Structure নির্বাচন করলে Algorithm-এর Performance উন্নত হয়।কোনো Algorithm-এর Efficiency প্রধানত Time Complexity এবং Space Complexity-এর উপর নির্ভর করে। সঠিক Algorithm এবং Data Structure নির্বাচন করলে Software-এর Performance উল্লেখযোগ্যভাবে উন্নত হয়।
- ☆6Structure Query LanguageA transaction consists of a sequence of query and/or update statements. SQL statement must be required to end the transaction. List the SQL statements, required to end the transaction and also write their functions.
A Transaction is a sequence of one or more SQL statements executed as a single logical unit of work. A transaction must be terminated using SQL transaction control statements.
SQL Statements to End a Transaction
SQL Statement Function COMMIT Permanently saves all changes made during the current transaction to the database. ROLLBACK Undoes all changes made during the current transaction since the last COMMIT or SAVEPOINT. SAVEPOINT Creates a checkpoint within a transaction so that the transaction can be rolled back to that point if needed. ROLLBACK TO SAVEPOINT Restores the transaction to a previously created SAVEPOINT without cancelling the entire transaction. COMMIT saves the transaction permanently, ROLLBACK cancels the transaction, and SAVEPOINT allows partial rollback within a transaction.
- ☆7Programming ConceptAn employee's total weekly pay is calculated by multiplying the hourly wage and number of regular hours plus any overtime pay which in turn is calculated as total overtime hours multiplied by 1.5 times the hourly wage. Write a program that takes as inputs the hourly wage. Total regular hours,and total overtime hours and prints an employee's total weekly pay.
#include <iostream> using namespace std; int main() { float hourlyWage, regularHours, overtimeHours; float overtimePay, totalPay; cout << "Enter Hourly Wage: "; cin >> hourlyWage; cout << "Enter Regular Hours: "; cin >> regularHours; cout << "Enter Overtime Hours: "; cin >> overtimeHours; overtimePay = overtimeHours * 1.5 * hourlyWage; totalPay = (regularHours * hourlyWage) + overtimePay; cout << "Total Weekly Pay = " << totalPay; return 0; }Example
Hourly Wage = 200
Regular Hours = 40
Overtime Hours = 10
Total Weekly Pay = (40 × 200) + (10 × 1.5 × 200) = 8000 + 3000 = 11000
- ☆8MiscellaneousMake a list of banking software used in Bangladesh. List the essential features for successful Banking Software and Apps.
Common Banking Software Used in Bangladesh
• Temenos T24 (Transact)
• Oracle FLEXCUBE
• Finacle (Infosys)
• Flora Banking Solution
• PC Bank 2000
• Bank Ultimus
• CBS (Core Banking System)
• Ababil Banking SolutionEssential Features of Banking Software and Apps
• Secure User Authentication (Password, OTP, MFA)
• Core Banking Services (Deposit, Withdrawal, Transfer)
• Real-Time Transaction Processing
• Internet and Mobile Banking Support
• Fund Transfer (BEFTN, RTGS, NPSB, Binimoy)
• Account Balance and Transaction History
• Bill Payment and Mobile Recharge
• Loan and Deposit Management
• Customer Management (KYC)
• Data Encryption and Backup
• Audit Log and Transaction Tracking
• High Availability and Disaster Recovery - ☆9MiscellaneousRFID has huge applications in business, especially in supply chain management and toll collection system. Show the basic working principle of RFID in brief.
RFID (Radio Frequency Identification) is a wireless technology that uses Radio Waves to identify and track objects, people, or animals automatically without physical contact. It is widely used in Supply Chain Management, Toll Collection, Inventory Management, and Access Control.
Main Components of RFID
1. RFID Tag: Attached to an object and stores a unique identification number (ID).
2. RFID Reader: Sends and receives radio signals to communicate with the RFID Tag.
3. Antenna: Transmits and receives radio waves between the Reader and the Tag.
4. Computer/Database: Receives the data from the Reader and processes or stores the information.Working Principle of RFID
Step 1: The RFID Reader transmits Radio Waves through its Antenna.
Step 2: When an RFID Tag comes within the Reader's range, it receives the radio signal.
Step 3: The RFID Tag sends its stored ID back to the Reader.
Step 4: The RFID Reader forwards the received data to the Computer/Database.
Step 5: The system verifies, processes, and stores the information for further use.Applications
• Supply Chain Management
• Toll Collection System
• Inventory Management
• Access Control
• Asset TrackingRFID (Radio Frequency Identification) হলো একটি Wireless Technology, যা Radio Wave ব্যবহার করে কোনো বস্তু, ব্যক্তি বা প্রাণীকে Contact ছাড়াই স্বয়ংক্রিয়ভাবে শনাক্ত (Identify) ও Track করে। এটি Supply Chain Management, Toll Collection System, Inventory Management এবং Access Control-এ ব্যাপকভাবে ব্যবহৃত হয়।
RFID-এর প্রধান উপাদান
১. RFID Tag: এটি কোনো বস্তুর সাথে সংযুক্ত থাকে এবং একটি Unique ID সংরক্ষণ করে।
২. RFID Reader: Radio Signal পাঠায় এবং RFID Tag থেকে তথ্য গ্রহণ করে।
৩. Antenna: Reader এবং Tag-এর মধ্যে Radio Wave আদান-প্রদান করে।
৪. Computer/Database: Reader থেকে প্রাপ্ত Data Process ও সংরক্ষণ করে।RFID-এর কার্যপ্রণালী
ধাপ ১: RFID Reader তার Antenna ব্যবহার করে Radio Wave প্রেরণ করে।
ধাপ ২: RFID Tag Reader-এর Range-এর মধ্যে এলে সেই Signal গ্রহণ করে।
ধাপ ৩: RFID Tag তার সংরক্ষিত ID Reader-এর কাছে পাঠিয়ে দেয়।
ধাপ ৪: RFID Reader প্রাপ্ত তথ্য Computer/Database-এ পাঠায়।
ধাপ ৫: Computer System তথ্য যাচাই (Verify), Process এবং সংরক্ষণ করে।ব্যবহার
• Supply Chain Management
• Toll Collection System
• Inventory Management
• Access Control
• Asset Tracking - ☆10Computer NetworkMake a list of LTE Network elements.
LTE (Long Term Evolution) is a 4G wireless communication technology. An LTE network consists of several network elements that work together to provide high-speed voice and data communication.
List of LTE Network Elements
Network Element Function UE (User Equipment) The user's mobile device (smartphone, tablet, modem) used to access the LTE network. eNodeB (Evolved Node B) The LTE base station that provides radio communication between the UE and the core network. MME (Mobility Management Entity) Handles user authentication, mobility management, and session management. S-GW (Serving Gateway) Routes user data packets between the eNodeB and the core network. P-GW (Packet Data Network Gateway) Connects the LTE network to external IP networks such as the Internet. HSS (Home Subscriber Server) Stores subscriber information, authentication data, and user profiles. PCRF (Policy and Charging Rules Function) Manages Quality of Service (QoS) and charging policies. The main LTE network elements are UE, eNodeB, MME, S-GW, P-GW, HSS, and PCRF. Together, they provide reliable, secure, and high-speed mobile communication.
LTE (Long Term Evolution) হলো একটি 4G Wireless Communication Technology। একটি LTE Network একাধিক Network Element নিয়ে গঠিত, যা একসাথে কাজ করে উচ্চগতির (High-Speed) Voice এবং Data Communication নিশ্চিত করে।
LTE Network-এর প্রধান Network Element
Network Element কাজ UE (User Equipment) ব্যবহারকারীর Mobile Device (Smartphone, Tablet, Modem), যা LTE Network ব্যবহার করে। eNodeB (Evolved Node B) LTE-এর Base Station, যা UE এবং Core Network-এর মধ্যে Radio Communication প্রদান করে। MME (Mobility Management Entity) User Authentication, Mobility Management এবং Session Management পরিচালনা করে। S-GW (Serving Gateway) eNodeB এবং Core Network-এর মধ্যে User Data Packet Forward করে। P-GW (Packet Data Network Gateway) LTE Network-কে Internet-এর মতো External IP Network-এর সাথে সংযুক্ত করে। HSS (Home Subscriber Server) Subscriber Information, Authentication Data এবং User Profile সংরক্ষণ করে। PCRF (Policy and Charging Rules Function) Quality of Service (QoS) এবং Charging Policy নিয়ন্ত্রণ করে। LTE Network-এর প্রধান Network Element হলো UE, eNodeB, MME, S-GW, P-GW, HSS এবং PCRF। এরা সম্মিলিতভাবে দ্রুত, নিরাপদ এবং নির্ভরযোগ্য Mobile Communication নিশ্চিত করে।
- ☆11Programming ConceptRecursionUsually, recursion involves a function Write a recursive algorithm to find the factorial of a number.
Recursion is a programming technique in which a Function calls itself repeatedly until a Base Case is reached. It is commonly used to solve problems that can be divided into smaller subproblems.
Recursive Algorithm
Algorithm Factorial(n)
BEGIN
If n = 0 or n = 1 Then
Return 1
Else
Return n × Factorial(n − 1)
ENDExample
Input: n = 5
Factorial(5)
= 5 × Factorial(4)
= 5 × 4 × Factorial(3)
= 5 × 4 × 3 × Factorial(2)
= 5 × 4 × 3 × 2 × Factorial(1)
= 5 × 4 × 3 × 2 × 1
= 120
- ☆12Operating SystemProcess Scheduling AlgorithmOperating System (OS) scheduling is the key concept of multiprogramming. List and briefly define the major types of OS scheduling.
Major Types of Operating System (OS) Scheduling
Answer:
OS Scheduling is the process of selecting which process will execute on the CPU. It is a key concept of Multiprogramming because it improves CPU utilization and system performance.
Major Types of OS Scheduling
Scheduling Type Definition Long-Term Scheduler (Job Scheduler) Selects jobs from secondary storage and loads them into main memory for execution. Short-Term Scheduler (CPU Scheduler) Selects a process from the ready queue and allocates the CPU to it. Medium-Term Scheduler Temporarily removes (swaps out) processes from memory and later brings them back to improve system performance. The Long-Term Scheduler controls the degree of multiprogramming, the Short-Term Scheduler allocates the CPU, and the Medium-Term Scheduler manages memory efficiently through swapping.
- ☆13Structure Query LanguageSQLMain components of SQL are DDL (Data definition Language), DML (Data Manipulation Language) and DCL (Data Control Language). Give some examples of DDL, DML and DCL commands.
SQL (Structured Query Language) is used to create, manage, manipulate, and control databases. Its main components are DDL (Data Definition Language), DML (Data Manipulation Language), and DCL (Data Control Language).
1. DDL (Data Definition Language)
DDL commands are used to create and modify the structure of database objects such as tables, views, and indexes.
Command Function CREATE Creates a new database object such as a table or database. ALTER Modifies the structure of an existing table. DROP Deletes a table or other database object permanently. TRUNCATE Removes all records from a table but keeps the table structure. RENAME Changes the name of a database object. 2. DML (Data Manipulation Language)
DML commands are used to insert, retrieve, update, and delete data stored in database tables.
Command Function INSERT Adds new records into a table. SELECT Retrieves data from a table. UPDATE Modifies existing records. DELETE Removes records from a table. 3. DCL (Data Control Language)
DCL commands are used to control user access and permissions in a database.
Command Function GRANT Gives privileges to users. REVOKE Removes privileges from users.
- ☆14Digital Logic DesignNumber SystemThere are different number systems.
(i) Convert (10010.101)2=(?)10 (ii) Convert (543)10 =(?)16(i) Convert (10010.101)2 to Decimal
Binary Number = (10010.101)2
Integer Part:
= (1 × 24) + (0 × 23) + (0 × 22) + (1 × 21) + (0 × 20)
= 16 + 0 + 0 + 2 + 0
= 18Fractional Part:
= (1 × 2-1) + (0 × 2-2) + (1 × 2-3)
= 0.5 + 0 + 0.125
= 0.625Therefore,
(10010.101)2 = (18.625)10(ii) Convert (543)10 to Hexadecimal
Successive Division by 16:
Division Quotient Remainder 543 ÷ 16 33 15 (F) 33 ÷ 16 2 1 2 ÷ 16 0 2 Read the remainders from bottom to top:
(543)10 = (21F)16
- ☆15Design Analysis of AlgorithmSorting AlgorithmInsertion sort is a simple sorting algorithm. Write a program to sort some given numbers using insertion sort algorithm.
Insertion Sort is a simple sorting algorithm that builds the sorted array one element at a time. It repeatedly takes an element and inserts it into its correct position in the already sorted portion of the array.
#include <iostream> using namespace std; int main() { int n, i, j, key; cout << "Enter number of elements: "; cin >> n; int a[n]; cout << "Enter elements: "; for(i = 0; i < n; i++) cin >> a[i]; for(i = 1; i < n; i++) { key = a[i]; j = i - 1; while(j >= 0 && a[j] > key) { a[j + 1] = a[j]; j--; } a[j + 1] = key; } cout << "Sorted Array: "; for(i = 0; i < n; i++) cout << a[i] << " "; return 0; }Example
Input: 5 4 2 7 1 3
Output: 1 2 3 4 7
- ☆16Computer NetworkTransport Layer ProtocolThe primary function of the Transmission control Protocol (TCP) is to turn an unreliable network into a reliable network that is free from lost and duplicate packets. What are the functions performed by TCP to make a network more reliable?
Transmission Control Protocol (TCP) is a connection-oriented Transport Layer protocol that provides reliable, ordered, and error-free data transmission between devices over an unreliable network such as the Internet.
Functions of TCP
1. Connection Establishment
TCP establishes a reliable connection between the sender and receiver using the Three-Way Handshake before transmitting data.2. Reliable Data Delivery
TCP uses Sequence Numbers and Acknowledgments (ACK) to ensure that all packets are delivered correctly.3. Error Detection and Recovery
TCP uses a Checksum to detect transmission errors. If an error or packet loss occurs, the lost packet is retransmitted.4. Flow Control
TCP uses the Sliding Window mechanism to control the amount of data sent, preventing the receiver from being overwhelmed.5. Congestion Control
TCP controls network congestion using techniques such as Slow Start, Congestion Avoidance, and Fast Recovery.6. Ordered Data Delivery
TCP ensures that data is delivered to the application in the same order in which it was sent.7. Duplicate Packet Elimination
TCP identifies and discards duplicate packets using Sequence Numbers.8. Connection Termination
After communication is complete, TCP gracefully closes the connection using the FIN/ACK process



