BPSC Assistant Programmer (CSE) December 2021 – Written question & solution

Questions from the BPSC Assistant Programmer (CSE) recruitment exam, December 2021 – Written, shared by the candidates who sat it. The paper: 5 written questions. So far 25 written questions have been shared. Topics include Computer Networks, Coding, DBMS, Algorithm and English.

Written (25)

  1. (a) Write down a function in C Programming language, that will take an n×n matrix as parameter and the dimension n as another parameter…
  2. (a) What is the subnet mask of 10.2.1.3/26 and What is the usable number of IP address on network that has a 26 mask? (b) Distinguish…
  3. (a) What is the purpose of database trigger? Explain with an example. (b) Explain the different type of database keys with examples. (c)…
  4. (a) What are the differences between linked list and array data structure? (b) What is the difference between supervised and unsupervised…
  5. (a) Distinguish between Frequency Division Multiplexing (FDM) and Time Division Multiplexing (TDM). (b) Differentiate between vector…
  6. (i) Object Oriented Programming এর যেকোন দুটি বৈশিষ্ট্য উদাহরণসহ ব্যাখ্যা করুন। (ii) নিচের C প্রোগ্রামটির ভুলগুলো সঠিক করুন এবং…
  7. (i) Bubble sort Algorithm লিখুন। এ অ্যালগরিদমটির Time Complexity বের করুন। (ii) C Programming Language এ Array and Structure এর মধ্যে…
  8. (i) Black Box testing and White Box testing এর মধ্যে পার্থক্য লিখুন। (ii) Software development এর Agile Method সম্পর্কে আলোচনা করুন।
  9. (i) নিচের Table টি তৈরি করার SQL কমান্ড লিখুন। student_info (std_id, name, department, phone_number) (a) Table তে ২টি record (insert)…
  10. (i) Operating System এর Process State Transition Diagram আঁকুন ও ব্যাখ্যা করুন। (ii) Virtual Memory এর প্রয়োজনীয়তা কি ব্যাখ্যা করুন।
  11. (i) Network Address Translation (NAT) ছবি সহ ব্যাখ্যা করুন। (ii) CIDR কী? 192.168.100.9/26 IP address থেকে (a) Total subnets (b) Block…
  12. (i) Object Oriented Programming এ Static binding and Dynamic binding কি ব্যাখ্যা করুন। (ii) Symmetric Key Encryption and Asymmetric Key…
  13. Briefly describe Unit testing, Smoke testing and Stress testing in software engineering.
  14. What do you mean by DHCP server? Explain the benefits of using dedicated DHCP server. Briefly describe the main benefits of using IPv6…
  15. Analyze and compare the Quick-sort and Merge-sort algorithms in terms of their time and space complexity.
  16. How can you Implement AND, OR and NOT gates using only NAND and NOR gates? What is the main difference between Latch and Flip-flop?
  17. Write a program in C/Java to find out the factorial of a number using recursion also write its iterative program.
  18. Solve the recurrence relation: T(n) = 3T(n-1) + 2, T(1) = 1.
  19. Consider a magnetic disk consisting of 16 heads and 400 cylinders. This disk has four 100-cylinder zones with the cylinders in different…
  20. What is the domain in a relational database? Explain with an example. Show how you would use Alter table SQL command to add a domain on a…
  21. Core i7 জেনারেশন এর প্রসেসর এর উদাহরণ লিখ?
  22. DHCP uses UDP port _____ for sending data to the server.
  23. Which one is collective noun? (a) Boy (b) Wood (c) Herd (d) Infancy
  24. Fill in the Gap: (a) I am sorry _____ the mistake. (b) _____ his being innocent of the crime, the judge sentenced him to one year imprison.
  25. Fill in the Gap with appropriate articles: (a) Football is _____ popular game in our country. (b) Money cannot buy _____ happiness.

Other papers for this post