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

Questions from the BPSC Assistant Database Administrator (ICT) recruitment exam, 2022 – Written, shared by the candidates who sat it. The paper: 33 written questions. So far 33 written questions have been shared. Topics include Computer Networks, Coding, Microprocessor, Algorithm and Emerging Technology.

Written (33)

  1. Distinguish between Call by value and Call by reference in C/C++.
  2. What is DHCP Server and why it is needed in a computer network.
  3. What are the components of a Micro computer system?
  4. How is alpha testing performed in software development?
  5. Write the port address of the following applications of data communications. (i) HTTP; (ii) HTTPS; (iii) FTP; (iv) SMTP; (v) POP
  6. Simplify Y=AB̄ + (Ā + B)C in digital logic design.
  7. Write short notes on: (i) RAM (ii) ROM (iii) Primary key (iv) Foreign key (v) Data
  8. Explain the necessary steps to communicate through a programmable peripheral interfacing device (8255 PPI).
  9. How many swaps are needed to sort the number sequence 5, 8, 3, 6, 2 in ascending order using bubble sort?
  10. Distinguish between Compiler and Interpreter with example.
  11. Define networking and Internetworking. What are the different types of network? Explain in details.
  12. What is network topology? Write the names of all the different topologies used in computer networking with example, diagram and their…
  13. What are the various access specifiers in C++? Explain their purpose with an example.
  14. Write a recursive algorithm to find the factorial of a positive integer N.
  15. How does Butterworth High pass Filter works?
  16. What are the basic objectives of canny edge detection method?
  17. Define: (i) Erosion and Dilation; (ii) Opening and Closing.
  18. Briefly mention the main impairmeents in telecommunication channel. Considering these impairments explain which communication is better…
  19. Consider that a signal is transmitted over a channel of bandwidth 200kHz and the total path loss in the channel is found to be 60dB. The…
  20. Compare between (i) AM and ASK and (ii) FM and FSK considering modulation scheme, bandwidth requirement, noise tolerance and circuit…
  21. What are the advantages of PSK and explain why coherent detection is necessary for demodulating the PSK signal?
  22. With appropriate figures, distinguish between homodyne and heterodyne detection processes. Draw the block diagram of a super heterodyne AM…
  23. Define the attenuation and dispersion in an optical fiber. Draw the block diagram of a long-haul optical fiber communication system.
  24. A singla-tone message signal of bandwidth 4KHZ and amplitude 10V is transmitted by Δ- modulation with step size 2V. Determine the data…
  25. Draw the constellation diagram of QPSK, 8-PSK and 32-QAM. Why are these multilevel signals preferred and what are the challenges for…
  26. What are the limitaions of CDMA?
  27. Show that the data rate of T-1 carrier is 1.544 Mbps.
  28. Suppose you are appointed as an Assistant Engineer in a Government organization. The number of telephone connections required for the…
  29. Mention the basic differences between frequency-hopped spread spectrum (FHSS) and direct sequence spread spectrum (DSSS) techniques.
  30. White short notes on: (i) SONET/SDH; (ii) IP telephony; (iii) WDM technology; (iv) ATM network
  31. A single-tone message signal of bandwidth 4 kHz is sampled by using a pulse train of frequency 200% higher than the Nyquist rate of the…
  32. Compare between TDM and TDMA techniques.
  33. Briefly describe the basis structure at a mobile cellular system with a proper figure.