Sonali & Janata Bank Officer (IT) 2020 – Written (DU) question & solution

Questions from the Sonali & Janata Bank Officer (IT) recruitment exam, 2020 – Written (DU), shared by the candidates who sat it. The paper: 15 written questions. So far 35 MCQs and 15 written questions have been shared. Topics include Computer Basics, Coding, Computer Networks, DBMS and Operating System.

MCQ (35)

  1. Which one is not a unary operator in relational algebra?
    1. a) Select
    2. b) Project
    3. c) Union
    4. d) Rename
  2. Which one is an entity?
    1. a) Roll No.
    2. b) Student
    3. c) Passport No.
    4. d) Department ID
  3. Which one is not part of learning phase of machine learning?
    1. a) Collect data
    2. b) Training data
    3. c) Algorithm
    4. d) Model
  4. Market basket analysis is part of:
    1. a) Classification
    2. b) Regression
    3. c) Clustering
    4. d) Association
  5. Which one is TRUE for RFID?
    1. b) Uses laser beam
    2. a) Uses electromagnetic signal
    3. c) Uses optical signal
    4. d) Uses infrared
  6. Which factor does not affect the processing speed of a computer system?
    1. a) Cache memory
    2. b) Clock speed
    3. c) Monitor
    4. d) RAM
  7. How many bits are in an IPv6 address?
    1. a) 24
    2. b) 32
    3. c) 64
    4. d) 128
  8. Class C IP address is for ____ bit network.
    1. a) 24
    2. b) 32
    3. c) 64
    4. d) 128
  9. Which one is the modifier key of the keyboard?
    1. a) Shift
    2. b) Enter
    3. c) Esc
    4. d) F4
  10. Where is the Boot strapping program stored?
    1. a) ROM
    2. b) Hard disk
    3. c) CD
    4. d) RAM
  11. Which operation does F1 key perform for all types of application?
    1. a) Windows shut down
    2. b) File open
    3. c) Help
    4. d) Save
  12. Which one is the first high level programming language?
    1. a) C
    2. b) COBOL
    3. c) FORTRAN
    4. d) C++
  13. Which one is the first search engine?
    1. a) Google
    2. b) Archie
    3. c) AltaVista
    4. d) WAIS
  14. Which programming language is used extensively for Artificial Intelligence (AI)?
    1. a) C
    2. b) Java
    3. c) J2EE
    4. d) Prolog
  15. Open System Interconnection (OSI) model has ____ layers.
    1. a) 6
    2. b) 5
    3. c) 9
    4. d) 7
  16. In computers, what is a firewall used for?
    1. a) Securing the computer
    2. b) Data Transmission
    3. c) Authentication
    4. d) Monitoring
  17. Which one is the first 64-bit operating system?
    1. a) Windows Vista
    2. b) Mac
    3. c) Linux
    4. d) Windows XP
  18. In computer systems, what is 'Trojan Horse'?
    1. a) Virus
    2. b) Malware
    3. c) Worm
    4. d) Spyware
  19. Which of the following protocols is used for receiving e-mails?
    1. a) SMTP
    2. b) POP3
    3. c) HTTP
    4. d) FTP
  20. In a computer, folder opening is denied by which of the following names?
    1. a) con
    2. b) com
    3. c) mak
    4. d) make
  21. The newest version of HTML is:
    1. a) WML
    2. b) HTML5
    3. c) XSL
    4. d) HTML3
  22. Programmers rough out the logic they will use in the ____ stage of the SDLC.
    1. a) Design
    2. b) Development
    3. c) Implementation
    4. d) Testing
  23. A ____ translates a file of program source code into machine language.
    1. a) Cluster
    2. b) Datagram
    3. c) Decoding
    4. d) Compiler
  24. The study of the way people work with tools is called:
    1. a) debugging
    2. b) programming
    3. c) ergonomics
    4. d) kinetics
  25. Viruses that take up residence in the computer's memory and make themselves hard to detect are called:
    1. a) Cluster Virus
    2. b) Self-encrypting Virus
    3. c) Stealth Virus
    4. d) Macro Virus
  26. All programming languages require users to follow certain rules of ____.
    1. a) style
    2. b) syntax
    3. c) grammar
    4. d) procedures
  27. The process of making object code from one system work on another type of system is called ____.
    1. a) Porting
    2. b) Designing
    3. c) Developing
    4. d) Coding
  28. The job of ____ is to translate the array of dots into text.
    1. a) MICR
    2. b) VGA
    3. c) OMR
    4. d) OCR
  29. A barcode reader emits ____.
    1. a) sound
    2. b) light
    3. c) beeps
    4. d) smell
  30. In a plasma display, gas is electrified by grid of ____.
    1. a) electronics
    2. b) phosphors
    3. c) electron
    4. d) electrodes
  31. Object code is the ____ language file that tells the CPU what to do.
    1. a) programming
    2. b) binary
    3. c) machine
    4. d) natural
  32. ____ is natural language statements that look like programming code.
    1. a) Source code
    2. b) Object code
    3. c) Pseudo code
    4. d) IPO chart
  33. Which of the following contains configuration information of a window?
    1. a) .exe
    2. b) .ini
    3. c) .dll
    4. d) .chm
  34. In a spreadsheet, ____ can help you make sense of a worksheet's contents.
    1. a) value
    2. b) labels
    3. c) formula
    4. d) macros
  35. Flat file database is most useful for ____.
    1. a) Large scale users
    2. b) Banking
    3. c) Small-group situation
    4. d) Chain stores

Written (15)

  1. Testing is an activity that is performed to verify correct behavior of a program. Testing should be conducted in all the stages of program…
  2. Inheritance is one of the important issues for any object oriented programming language. The main advantage of Inheritance is the ability…
  3. Queue 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…
  4. There are no well-defined standards for writing algorithms. Efficiency of an algorithm depends on several factors. Similarly, complexity…
  5. A transaction consists of a sequence of query and/or update statements. SQL statement must be required to end the transaction. List the…
  6. An employee's total weekly pay is calculated by multiplying the hourly wage and number of regular hours plus any overtime pays which in…
  7. Usually, recursion involves a function calling itself until specified condition is met and it is very useful to find out the factorial…
  8. Operating system (OS) scheduling is the key concept of multiprogramming. List and briefly define the major types of OS scheduling.
  9. Make a list of banking software used in Bangladesh. List the essential features for successful Banking Software and Apps.
  10. RFID has huge applications in business, especially in supply chain management and toll collection system. Show the basic working principle…
  11. Make a list of LTE Network elements.
  12. Main components of SQL are DDL (Data definition Language), DML (Data Manipulation Language) and DCL (Data Control Language). Give some…
  13. There are different number systems. i. Convert (10010.101)₂ = (?)₁₀ ii. (543)₁₀ = (?)₁₆
  14. Insertion sort is a simple sorting algorithm. Write a program to sort some given numbers using insertion sort algorithm.
  15. The primary function of the Transmission Control Protocol (TCP) is to turn an unreliable network into a reliable network that is free from…

Other papers for this post