BPSC Assistant Database Administrator (CSE) 2022 – Written question & solution

Questions from the BPSC Assistant Database Administrator (CSE) recruitment exam, 2022 – Written, shared by the candidates who sat it. The paper: 18 written questions. So far 18 written questions have been shared. Topics include Digital Logic, Algorithm, English, DBMS and Computer Networks.

Written (18)

  1. Name and define the components of a computer system. Mention two optical input devices.
  2. Express the following statement as a logical expression, "If someone is female and is a parent, then this person is someone's mother".
  3. Give classification of memory. Differentiate between RAM and ROM.
  4. Explain Binary digits, logical levels and digital waveforms using timing diagram.
  5. Write down the Algorithm for determining Fibonacci number through dynamic programming.
  6. What will be the time and space complexity of the dynamic programming algorithm for determining the Fibonacci number?
  7. Why Normalization is used in database? Explain 1st Normal form using an example.
  8. How can you Revoke permissions from a database table? Give SQL command for it.
  9. Why network need packet fragmentation? Define different types of packet fragmentation with necessary diagram.
  10. Write down the pseudocode of quick sort algorithm through recursive algorithm. Express the arrange complexity off this algorithm.
  11. What do you understand by DoS attack and Man-in-the-middle attack? Please explain how they can occur.
  12. What are the differences between call by value and call by Reference?
  13. Simplify F(A, B, C, D) = ACD + AB + D̄ + ACD̄ using K-map and draw the logic circuits.
  14. Define basic logical operations with examples. (AND, OR, NOT)
  15. Suppose a 22-byte packet is to be transmitted through a network of MTU = 3 byte. The elementary fragment size is 1 byte. Show the segment…
  16. Write an essay on any one of the following using the hints given below: a) Technical Education. [Hints: Introduction — What technical…
  17. (a) Write a letter to your friend condoling the death of his/her mother. Or, (b) Write an application to the Upazila Nirbahi Officer for…
  18. Read the followiing passage and then answer the questions given below: War is the worst of all evils of human civilisation. It is an…