Loading...
Bangladesh Public Service Commission

Post: Assistant Maintenance Engineer ; Date: 09 February, 2024
Exam taker: BPSC; Written
1.(a) Write a short comparative note on “Static web page” and “Dynamic web page”.
Static Web PageDynamic Web Page
Content is fixed and does not changeContent is dynamic and can change
Written using HTML, CSSUses server-side languages (PHP, Node.js, etc.)
No interaction with userSupports user interaction
Loads fasterSlower due to processing
No database requiredOften connected with database
Example: Simple portfolio pageExample: Facebook, YouTube
Static Web PageDynamic Web Page
Content fixed থাকে, পরিবর্তন হয় নাContent dynamic এবং পরিবর্তনশীল
HTML, CSS ব্যবহার করা হয়server-side language (PHP, Node.js) ব্যবহার করা হয়
User interaction নেইUser interaction সম্ভব
দ্রুত load হয়Processing-এর কারণে ধীর
Database লাগে নাসাধারণত database ব্যবহার করে
উদাহরণ: Simple websiteউদাহরণ: Facebook, YouTube
1.(b) An organization is planning to deploy a wireless network. Explain the security considerations for setting up a secure Wi-Fi network including the authentication methods, encryption protocols and best practices to prevent unauthorized access.

Security Considerations for Secure Wi-Fi Network

Authentication Methods:

  • WPA2/WPA3-Personal: Uses password (pre-shared key)
  • WPA2/WPA3-Enterprise: Uses RADIUS server for user authentication

Encryption Protocols:

  • WPA3: Most secure (uses strong encryption)
  • WPA2 (AES): Common and secure
  • Avoid WEP (insecure)

Strong Password: Use complex and long Wi-Fi passwords

SSID Management: Change default SSID and disable SSID broadcast if needed

Firewall & Updates: Enable router firewall and keep firmware updated

MAC Address Filtering: Allow only specific devices

Network Segmentation: Use guest network for visitors

Disable Unused Services: Turn off WPS and remote access

Using strong authentication, modern encryption, and proper configuration helps prevent unauthorized access and ensures secure Wi-Fi communication.

Authentication Methods:

  • WPA2/WPA3-Personal: password ভিত্তিক authentication
  • WPA2/WPA3-Enterprise: RADIUS server ব্যবহার করে user authentication

Encryption Protocols:

  • WPA3: সবচেয়ে নিরাপদ encryption
  • WPA2 (AES): সাধারণ ও নিরাপদ
  • WEP ব্যবহার করা উচিত নয় (insecure)

Strong Password: জটিল ও দীর্ঘ Wi-Fi password ব্যবহার করা উচিত

SSID Management: default SSID পরিবর্তন করা এবং প্রয়োজনে SSID broadcast বন্ধ রাখা

Firewall & Updates: router firewall চালু রাখা এবং firmware update করা

MAC Address Filtering: নির্দিষ্ট device-কে access দেওয়া

Network Segmentation: guest network ব্যবহার করা

Disable Unused Services: WPS ও remote access বন্ধ রাখা

1(c) What is penetration testing for a network service?

Penetration Testing (Pen Testing) is a security testing method where ethical hackers simulate real-world attacks on a network service to identify vulnerabilities.

Purpose:

  • To find security weaknesses in the network
  • To evaluate system security
  • To prevent unauthorized access and attacks

Process:

  • Scanning: Identify open ports and services
  • Exploitation: Try to access the system using vulnerabilities
  • Reporting: Document findings and suggest fixes

Penetration testing helps organizations improve network security by detecting and fixing vulnerabilities before attackers exploit them.

Penetration Testing (Pen Testing) হলো একটি security testing পদ্ধতি যেখানে ethical hacker বাস্তব attack-এর মতো চেষ্টা করে network service-এর দুর্বলতা খুঁজে বের করে।

উদ্দেশ্য:

  • Network-এর security দুর্বলতা শনাক্ত করা
  • System-এর নিরাপত্তা মূল্যায়ন করা
  • Unauthorized access প্রতিরোধ করা

Process:

  • Scanning: open port এবং service শনাক্ত করা
  • Exploitation: vulnerability ব্যবহার করে system access করার চেষ্টা
  • Reporting: সমস্যা শনাক্ত করে সমাধানের পরামর্শ দেওয়া

Penetration testing system-এর দুর্বলতা আগে থেকেই খুঁজে বের করে security উন্নত করতে সাহায্য করে।

1(d) What are the main security vulnerabilities commonly found in web applications? How would you address them?

Common Security Vulnerabilities in Web Applications & Their Solutions

1. SQL Injection:

  • Attackers insert malicious SQL queries
  • Solution: Use prepared statements and input validation

2. Cross-Site Scripting (XSS):

  • Malicious scripts are injected into web pages
  • Solution: Use input sanitization and output encoding

3. Cross-Site Request Forgery (CSRF):

  • Unauthorized actions performed on behalf of users
  • Solution: Use CSRF tokens and secure cookies

4. Weak Authentication:

  • Poor password or login system
  • Solution: Use strong passwords, multi-factor authentication (MFA)

5. Broken Access Control:

  • Users access unauthorized data
  • Solution: Implement proper authorization checks

6. Security Misconfiguration:

  • Default settings or improper setup
  • Solution: Regular updates and secure configuration

7. Sensitive Data Exposure:

  • Data not properly protected
  • Solution: Use encryption (HTTPS, SSL/TLS)

By applying secure coding practices, proper validation, and strong authentication, web application vulnerabilities can be minimized.

1. SQL Injection:

  • Malicious SQL query insert করা হয়
  • সমাধান: prepared statement ও input validation ব্যবহার

2. Cross-Site Scripting (XSS):

  • Web page-এ malicious script inject করা হয়
  • সমাধান: input sanitization ও output encoding

3. Cross-Site Request Forgery (CSRF):

  • User-এর অজান্তে unauthorized action হয়
  • সমাধান: CSRF token ও secure cookie ব্যবহার

4. Weak Authentication:

  • দুর্বল password বা login system
  • সমাধান: strong password ও MFA ব্যবহার

5. Broken Access Control:

  • Unauthorized data access
  • সমাধান: সঠিক authorization check implement করা

6. Security Misconfiguration:

  • ভুল configuration বা default setting
  • সমাধান: system update ও secure setup করা

7. Sensitive Data Exposure:

  • Data সঠিকভাবে সুরক্ষিত না থাকা
  • সমাধান: encryption (HTTPS, SSL/TLS) ব্যবহার

Secure coding, validation এবং strong authentication ব্যবহার করলে web application নিরাপদ রাখা যায়।

2.(a) Explain the concept of social engineering. What are the common social engineering techniques? How can you define them?

Social Engineering is a technique where attackers manipulate people into revealing confidential information instead of hacking systems directly.

Common Social Engineering Techniques:

  • Phishing: Fake emails or websites used to steal login credentials or personal data.
  • Pretexting: Attacker creates a false scenario to gain trust and extract information.
  • Baiting: Offering something attractive (e.g., free USB, download) to trick users.
  • Tailgating (Piggybacking): Unauthorized person follows an authorized person into a restricted area.
  • Quid Pro Quo: Offering a service (e.g., tech support) in exchange for sensitive information.
  • Spear Phishing: Targeted phishing attack aimed at a specific individual or organization.

Conclusion:
Social engineering attacks exploit human psychology, so awareness and user training are essential for prevention.

Social Engineering হলো এমন একটি technique যেখানে attacker system hack না করে মানুষকে manipulate করে sensitive information বের করে।

সাধারণ Social Engineering Techniques:

  • Phishing: ভুয়া email বা website ব্যবহার করে login বা personal তথ্য নেওয়া হয়।
  • Pretexting: ভুয়া scenario তৈরি করে বিশ্বাস অর্জন করে তথ্য নেওয়া হয়।
  • Baiting: আকর্ষণীয় কিছু (যেমন free USB) দিয়ে user-কে প্রলুব্ধ করা হয়।
  • Tailgating: অনুমতি ছাড়া authorized ব্যক্তির সাথে restricted area-তে প্রবেশ করা।
  • Quid Pro Quo: কোনো service দেওয়ার বিনিময়ে তথ্য নেওয়া হয়।
  • Spear Phishing: নির্দিষ্ট ব্যক্তি বা organization-কে target করে phishing করা।

উপসংহার:
Social engineering মানুষের মনস্তত্ত্ব ব্যবহার করে, তাই সচেতনতা ও training খুবই গুরুত্বপূর্ণ।

3.(a) Compare Stack and Queue in context with data structure.
StackQueue
Follows LIFO (Last In First Out)Follows FIFO (First In First Out)
Insertion and deletion from same end (top)Insertion at rear and deletion from front
Operations: push, popOperations: enqueue, dequeue
Only one pointer (top) is usedTwo pointers (front and rear) are used
Example: Undo operationExample: Printer queue
StackQueue
LIFO (Last In First Out) অনুসরণ করেFIFO (First In First Out) অনুসরণ করে
Insertion ও deletion একই দিক (top) থেকে হয়Insertion rear থেকে এবং deletion front থেকে হয়
Operation: push, popOperation: enqueue, dequeue
একটি pointer (top) ব্যবহার হয়দুটি pointer (front এবং rear) ব্যবহার হয়
উদাহরণ: Undo operationউদাহরণ: Printer queue
3.(b) What is malware? State in short with some examples?

Malware (Malicious Software) is software designed to harm, damage, or gain unauthorized access to a computer system.

Examples of Malware:

  • Virus: Attaches to files and spreads when executed
  • Worm: Spreads automatically through networks
  • Trojan Horse: Disguised as legitimate software
  • Ransomware: Locks data and demands payment
  • Spyware: Monitors user activity secretly

Conclusion:
Malware can damage systems and steal data, so using antivirus and security practices is important

Malware (Malicious Software) হলো এমন software যা computer system ক্ষতি করা বা unauthorized access নেওয়ার জন্য তৈরি করা হয়।

Malware-এর উদাহরণ:

  • Virus: file-এর সাথে যুক্ত হয়ে ছড়ায়
  • Worm: network-এর মাধ্যমে নিজে নিজে ছড়ায়
  • Trojan Horse: আসল software-এর মতো ভান করে
  • Ransomware: data lock করে টাকা দাবি করে
  • Spyware: গোপনে user activity নজরদারি করে

উপসংহার:
Malware system ক্ষতি করতে পারে, তাই antivirus ও security ব্যবস্থা ব্যবহার করা জরুরি।

3.(c) What are the main components of flowchart?

Flowchart Symbols and Functions

3.(d) What are the purpose of Primary Key and Foreign Key in context with ‘Relational Database’? Write in short with examples.

A Primary Key is a field that uniquely identifies each record in a table. It cannot have duplicate or NULL values.
Example: Student(ID, Name) → ID is Primary Key.
Purpose:
  • Ensures uniqueness of records
  • Prevents duplicate entries

A Foreign Key is a field in one table that refers to the Primary Key of another table.
Example: Student(ID, Name), Course(CourseID, StudentID) → StudentID is Foreign Key.
Purpose:

  • Maintains relationship between tables
  • Ensures referential integrity
Primary Key uniquely identifies records, while Foreign Key connects tables in a relational database
Primary Key হলো এমন একটি field যা table-এর প্রতিটি record-কে uniquely identify করে। এতে duplicate বা NULL থাকতে পারে না।
উদাহরণ: Student(ID, Name) → ID হলো Primary Key।

উদ্দেশ্য:

  • Record-এর uniqueness নিশ্চিত করা
  • Duplicate data প্রতিরোধ করা

Foreign Key হলো একটি table-এর field যা অন্য table-এর Primary Key-কে নির্দেশ করে।
উদাহরণ: Student(ID, Name), Course(CourseID, StudentID) → StudentID হলো Foreign Key।

উদ্দেশ্য:

  • Table-এর মধ্যে relationship তৈরি করা
  • Referential integrity বজায় রাখা

Primary Key record uniquely identify করে, আর Foreign Key table-গুলোর মধ্যে সম্পর্ক তৈরি করে।

4. A device in a network has an IP Address 172.16.128.120/25. Based on this information answer the following:
(i) What is the network address for this network?
(ii) What is the maximum number of devices can be connected with this network?

Given:
IP address = 172.16.128.120/25

(i) Network address:
/25 ⇒ Subnet mask = 255.255.255.128
Block size = 128
Subnets: 0–127, 128–255

120 falls in 0–127
So, Network address = 172.16.128.0

(ii) Maximum number of devices:
Host bits = 32 − 25 = 7
Total IPs = 27 = 128
Usable hosts = 128 − 2 = 126

Final Answer:
Network address = 172.16.128.0
Maximum devices = 126

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.

Leave a Comment

Latest Post
Field Based Job Question & Solution
Bank IT Job Solution

MCQ + Written from Bangladesh Bank, Sonali, Combined Bank IT recruitment.

BPSC IT Job Solution

BPSC Computer/IT cadre & non-cadre post Question papers with full solutions.

Gas Field IT Job Solution

Gas field like TGTDCL, BGDCL, JGTDSL, KGDCL, SGCL, RPGCL, GTCL etc. question solution

Power Sector IT Job Solution

Power sector such as NESCO, DESCO, DPDC, WZPDCL, BPDB, PGCB, BREB etc

Other IT Job Solution

Other Govt. Semi govt. organization like BCC, BTCL, CAAB, NSI etc.

NTRCA IT Job Solution (upcoming)

NTRCA ICT-related posts such as Assistant Teacher, Demonstrator, Lecturer.

IT MCQ Job Solution

Collected MCQ Job solution of BANK, BPSC, POWER SECTOR, GAS Field and Others.

Topic Based Q&S
WhatsApp Telegram Messenger