Combined Bank Assistant Programmer (CSE) 2020 – Preliminary (DU) question & solution

Questions from the Combined Bank Assistant Programmer (CSE) recruitment exam, 2020 – Preliminary (DU), shared by the candidates who sat it. The paper: 39 MCQs. So far 39 MCQs and 8 written questions have been shared. Topics include Coding, Network Security, Algorithm, Software Engineering and DBMS.

MCQ (39)

  1. _______ is a qualitative measure that refers to the number of connections between a 'calling' and a 'called' module and the complexity of…
    1. a) Coupling
    2. b) Cohesion
    3. c) Both A and B
    4. d) None of them
  2. Modified software goes through a phase where it is tested in the user's site or live environment. This is referred to as-
    1. a) Alpha testing
    2. b) Beta testing
    3. c) Gamma testing
    4. d) Delta testing
  3. When an ongoing call or data session can communicate with two base stations at the same time, the phenomenon is known as-
    1. a) Soft Roaming
    2. b) Hard Roaming
    3. c) Soft Handoff
    4. d) Hard Handoff
  4. A relationship is given below in an ER diagram. How many tables can be created (preferred) from below diagram?
    1. a) Two
    2. b) Three
    3. c) Two or Three
    4. d) No definite numbers
  5. In a Vigenere cipher, plaintext is mypassword and key is stream. What is the cipher text?
    1. a) dqedrdnfgf
    2. b) ergeseohih
    3. c) pmgpkpizoz
    4. d) fshftfpiji
  6. What is the advantage of using 'case' while doing the update operation?
    1. a) No proper sequence is required to maintain.
    2. b) It is much easier to write code with 'case' keyword.
    3. c) Update with 'case' provides significant time improvement.
    4. d) None of the above.
  7. What is the name of the RAID shown below?
    1. a) RAID 0+1
    2. b) RAID 1+0
    3. c) RAID 01
    4. d) RAID 10
  8. The table below violates the Normal Form(s). Which normal form does it violate? Tournament Winners Tournament Year Winner Winner Date of…
    1. a) All of normal forms listed here
    2. b) 3NF
    3. c) 2NF
    4. d) 1NF
  9. English scientist _______ invented the World Wide Web in 1989.
    1. a) Vint Cerf
    2. b) Robert Elliot Kahn
    3. c) Alan Turing
    4. d) Tim Berners-Lee
  10. Cyber security Triad means-
    1. a) Confidentiality, Reliability and Availability
    2. b) Confidentiality, Reliability and Accessibility
    3. c) Confidentiality, Integrity and Availability
    4. d) Privacy, Integrity and Approachability
  11. A line coding scheme of digital to digital conversion in given below. What is the name of this line coding technique?
    1. a) NRZ
    2. b) RZ
    3. c) Manchester
    4. d) AMI
  12. _______ is a means of regaining access to a compromised system by installing software or configuring existing software to enable remote…
    1. a) Spyware
    2. b) Ransomware
    3. c) Cross-site scripting
    4. d) Backdoor
  13. _______ is an integration testing that is commonly used when software products are being developed. It is designed as a pacing mechanism…
    1. a) Unit testing
    2. b) Function testing
    3. c) Regression testing
    4. d) Smoke testing
  14. ISO 9126 quality factors consist of –
    1. a) process-ability, consistency, usefulness, adaptability, rationality and transportability
    2. b) functionality, reliability, efficiency, usability, maintainability and portability
    3. c) functionality, consistency, effectiveness, adaptability, maintainability and transportability
    4. d) None of them.
  15. Digital signature is a cryptographic method that ensures-
    1. a) Data confidentiality, integrity, availability
    2. b) Data integrity, authentication, non-repudiation
    3. c) Data privacy, integrity, accessibility
    4. d) Data privacy, integrity, approachability
  16. What will happen if this C program is compiled and executed? #include<stdio.h> int main(){ return 0; }
    1. a) The program will show some garbage output
    2. b) There will be a compile error and the program will not execute
    3. c) No output (Output screen will be empty)
    4. d) There will be a run-time error
  17. Who is known as the first computer programmer?
    1. a) Alan Turing
    2. b) Ada Lovelace
    3. c) Charles Babbage
    4. d) None of the above
  18. Which one is the binary representation of (1234567)₁₀?
    1. a) 100101101011010000000
    2. b) 110101101111010001010
    3. c) 100101101011010000111
    4. d) 111111111011010000110
  19. A prime number is a number that is divisible only by itself and 1. Which of the following is not a prime number?
    1. a) 2
    2. b) 7
    3. c) 99
    4. d) 181
  20. What will be the output of this C program? #include<stdio.h> int main(){ float p=10.5; int a=5*p+5.0; printf("%d\n",a); return 0; }
    1. a) 57.500000
    2. b) 57
    3. c) 57.000000
    4. d) The program has errors and will not run.
  21. Which of the following is a Web Framework built with PHP?
    1. a) Laravel
    2. b) Django
    3. c) MVC
    4. d) Spring
  22. Which of the following is not a data encryption algorithm?
    1. a) MD5
    2. b) SHA1
    3. c) RSA
    4. d) AES
  23. Suppose a Class C network address is 192.168.10.0 and subnet mask is 255.255.255.192. How many valid hosts per subnet can be obtainable?
    1. a) 62
    2. b) 30
    3. c) 14
    4. d) 6
  24. Given a sequence, S = {1, 2, 3, 8, 15, 10}; which of the following algorithms will be the fastest to sort this sequence in ascending order?
    1. a) Bubble sort
    2. b) Merge sort
    3. c) Quick sort
    4. d) Heap sort
  25. It is a necessary requirement that the transaction is guaranteed to complete or the transaction is never started, so that an inconsistent…
    1. a) Atomicity
    2. b) Consistency
    3. c) Isolation
    4. d) Durability
  26. What is the output of this Java program? class Test{ int i=1; } public class main{ public static void main(String args[]){ Test t…
    1. a) The program will cause a runtime exception because the variable 'i' was not initialized
    2. b) The program will cause a compile error because the object 't' was not initialized
    3. c) 0
    4. d) A garbage value
  27. Interfaces in Java are meant to be-
    1. a) Extended
    2. b) Implemented
    3. c) Overridden
    4. d) Used by creating object
  28. Which of the following statements is/are true about Inheritance in Java? i) Private methods are final ii) Protected methods are final iii)…
    1. a) i, iii and iv
    2. b) i and iii only
    3. c) ii, iii and iv
    4. d) ii and iv only
  29. Which of the following is not a standard compiler of the C programming language?
    1. a) Microsoft Visual C/C++ Compiler
    2. b) GNU GCC Compiler
    3. c) CodeBlocks C Compiler
    4. d) Borland C Compiler
  30. What is the maximum value that can be stored in a 32-bit signed integer in the C language?
    1. a) 10³²
    2. b) 2³²
    3. c) 2³² − 1
    4. d) 2³¹-1
  31. Which of the following can be used in a Java Server Page (JSP) page?
    1. a) HTML
    2. b) AJAX
    3. c) JSTL
    4. d) All of the above
  32. Maximum how many nodes can be placed in a binary Tree of N levels?
    1. a) 2ᴺ-1
    2. b) 2ᴺ⁻¹
    3. c) 2ᴺ⁻¹-1
    4. d) N²
  33. Which of the following statements is not true for Java Language?
    1. a) The number 1 can be used instead of the keyword 'true'
    2. b) Trying to store a fraction value in an 'int' datatype causes compile error
    3. c) Static members of a class can be accessed without creating objects of that class
    4. d) If not specified otherwise, the initial value of an integer variable is 0
  34. Which of the following techniques is popular for Data Compression?
    1. a) Alpha-Beta pruning
    2. b) Checksum
    3. c) Huffman Coding
    4. d) Red Black Tree
  35. How many function calls will be performed to execute the following recursive function? void function(int N){ if(N==0) return…
    1. a) N
    2. b) 2*N
    3. c) Infinite
    4. d) The answer can vary depending on the initial value of N
  36. Which algorithm will be the most efficient to find out the shortest path between two given nodes in an undirected weighted graph?
    1. a) Breadth First Search
    2. b) Depth First Search
    3. c) Dijkstra's algorithm
    4. d) Floyd-Warshall algorithm
  37. Which HTML attribute is used to hide characters of an input password?
    1. a) href
    2. b) type
    3. c) style
    4. d) src
  38. Which of the following code syntax shows a valid use of curly braces '{}' in Python?
    1. a) A={'one':1, 'two':2}
    2. b) if(A>5) {print("Hello")}
    3. c) A= {range(6)}
    4. d) B={A=5}
  39. Which of the following is not a built-in HTML tag?
    1. a) <script>
    2. b) <form>
    3. c) <html>
    4. d) All of these are valid built-in HTML tags

Written (8)

  1. Difference between spoofing and sniffing
  2. What is the full meaning of SQL? List the aggregate functions. Write an SQL query on a table and show its output.
  3. What is Agile Methodology? Difference between Agile Model and Waterfall Model.
  4. Linked list, doubly linked list and circular linked list explains with diagram.
  5. X is an integer stream of N numbers. You have to select 2 data P and Q such that A<= (P+Q) <=B. Write an algorithm / pseudo code/ C…
  6. How to Determine the weighted graph has negative cycle?
  7. Write down the functionality of OSI model.
  8. Write a code in C/C++ that will output the 2nd largest number. (If N>=1)

Other papers for this post