Probashi Kallyan Bank Assistant Programmer Preliminary Exam: 2018 | প্রশ্ন ও সমাধান

Question 1Networking

Which protocol can cause overload on a CPU of a managed device?

a)NetFlow
b)WCCP
c)IP SLA
d)SNMP

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 2Networking

Which type of cable is used to connect the COM port of a host to the COM port of a router or switch?

a)Crossover
b)Straight-through
c)Rolled
d)Shielded twisted pair

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 3Database

Which of the following is a group of one or more attributes that uniquely identifies a row?

a)Key
b)Determinant
c)Tuple
d)Relation

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 4Database

The SQL statement that retrieves or reads data from the table is-

a)Select (correct answer)
b)Read
c)Query
d)None of the above

Answer and explanation

Correct answer: (a) Select

SELECT is the SQL statement that retrieves rows from one or more tables or views:

SELECT * FROM staff;

In SQLite, SELECT returned the table's rows, while READ staff and QUERY staff were rejected as syntax errors.

Why the other options are wrong

(b) Read: SQL has no READ statement; reading is done with SELECT.
(c) Query: "query" is the general name for any request for data (a SELECT is a query), but QUERY is not an SQL statement.
(d) None of the above: SELECT does exactly what is asked, so this does not apply.

Tip: Reading data = SELECT; changing data = INSERT, UPDATE, DELETE.

Source: PostgreSQL Documentation: SELECT

Question 5Networking

Which of the following protocols uses TCP and UDP ports?

a)FTP
b)SMTP
c)Telnet
d)DNS (correct answer)

Answer and explanation

Correct answer: (d) DNS

DNS uses port 53 over both transports. Ordinary queries and answers are short, so they normally travel as single UDP datagrams, which avoids TCP's connection setup. TCP is used for zone transfers (AXFR) between primary and secondary servers, which need reliable delivery of a large amount of data, and when an answer does not fit in a UDP message (classically 512 bytes): the server sets the TC (truncated) bit and the client repeats the query over TCP.

Why the other options are wrong

(a) FTP: Both the control connection (port 21) and the data connections (port 20 by default) are TCP.
(b) SMTP: Mail transfer runs over TCP connections to port 25 only.
(c) Telnet: A Telnet session is a TCP connection to server port 23.

(IANA also lists UDP numbers for these well-known ports, but the protocols themselves are defined and used only over TCP.)

Tip: DNS is the classic "both" protocol: UDP 53 for normal lookups, TCP 53 for zone transfers and large replies.

Source: RFC 1035: Domain Names - Implementation and Specification; RFC 854: Telnet Protocol Specification; RFC 959: File Transfer Protocol (FTP)

Question 6Data Structures

Two dimensional arrays are also called?

a)table array
b)matrix array
c)both A and B (correct answer)
d)none of the above

Answer and explanation

Correct answer: (c) both A and B

A two-dimensional array stores its elements in rows and columns: A[i][j] is the element in row i, column j. That layout is exactly a mathematical matrix, and it is also a table of rows and columns (for example, a marks sheet with students as rows and subjects as columns). So a 2-D array is commonly called both a matrix array and a table array. Microsoft's C++ documentation describes int i2[5][7] as conceptually a two-dimensional matrix of 5 rows and 7 columns, and Visual Basic documentation also calls it a rectangular array.

Why the other options are wrong

(a) table array: a correct name, but only one of the two; option (c) covers it.
(b) matrix array: also correct, but again only half the answer.
(d) none of the above: wrong, because both names are used for 2-D arrays.

Tip: 1-D array ↔ list/vector; 2-D array ↔ matrix/table (rows × columns).

Source: Arrays (C++) | Microsoft Learn; Array Dimensions — Visual Basic | Microsoft Learn

Question 7Database

Which of the following is an SQL trigger type supported by Oracle?

a)Before
b)Instead of
c)After
d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 8Mathematics

K iteration by Newton-Raphson of a following square root of a number increases accuracy in number of digits?

a)k
b)2k
c)3k
d)4k

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 9Programming

An algorithm that calls itself directly or indirectly is known as?

a)Sub Algorithm
b)Recursion
c)Polish Notation
d)Traversal algorithm

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 10Algorithms

Bubble sort algorithm sorts n data items using?

a)O (n²) Comparisons
b)O (n) Comparisons
c)O (n log n) Comparisons
d)O (log n) Comparisons

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 11Database

For every relationship, how many possible sets of minimum cardinalities are there?

a)Two
b)Three
c)Four
d)Six

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 12Programming

Which control statement can be executed at least once?

a)while
b)for
c)do-while
d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 13Algorithms

Two main measures for the efficiency of an algorithm are?

a)Processor and memory
b)Complexity and capacity
c)Time and space
d)Data and space

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 14Algorithms

The complexity of binary search is-

a)O(n)
b)O (log n) (correct answer)
c)O(n²)
d)O (n log n)

Answer and explanation

Correct answer: (b) O(log n)

Binary search runs on a sorted array and halves the remaining range with each comparison. After k comparisons n/2ᵏ elements remain; this reaches 1 when k = log₂ n. So the search needs at most ⌊log₂ n⌋ + 1 comparisons, which is O(log n).

Why the other options are wrong

(a) O(n): that is linear search, which may inspect every element.
(c) O(n²): quadratic time belongs to simple sorts (bubble, selection, insertion), not to searching.
(d) O(n log n): that is the cost of efficient comparison sorting (merge sort, heapsort), not of one search.

Tip: Binary search = O(log n) on sorted data; linear search = O(n).

Source: binary search (NIST Dictionary of Algorithms and Data Structures)

Question 15Data Structures

The smallest element of array index is called its

a)Lower Bound
b)Upper Bound
c)Range
d)Extraction

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 16Programming

Which one of the following is not a valid identifier?

a)_compact
b)compact
c)com-pact
d)com_pact

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 17General ICT

Consider the following code

#include<stdio.h>
int main (int argc, char *argv[]){
    return 0;
}

What is the maximum length of character array argv in the above code?

a)0
b)1
c)Undefined
d)-1

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 18General ICT

Which is the value of "d" after this line of code has been executed?

double d=Math.round(2.5+Math.random());

a)2
b)2.5
c)3
d)4

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 19Programming

Which of the following correctly shows the hierarchy of arithmetic operations in C?

a)/+*-
b)*-/+
c)+-/*
d)/*+-

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 20Networking

Which of the following TCP/IP addresses constitute the loopback address?

a)1.1.1.1
b)255.255.255.255
c)127.0.0.0
d)127.0.0.1

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 21Programming

Which of the following produces an answer that is closest in value to a double, d, while not being greater than d?

a)(int)Math.min(d)
b)(int)Math.max(d)
c)(int)Math.abs(d)
d)(int)Math.floor(d)

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 22Programming

Which keyword must be used to inherit a class in Java?

a)extends
b)super
c)this
d)extend

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 23Programming

Which of the following is the destructor for class "vehicle"?

a)*vehicle()
b)*vehicle (int value)
c)~vehicle()
d)~vehicle (int value)

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 24Programming

A class that is inherited in Java is called a______.

a)sub class
b)super class
c)state class
d)implement class

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 25Programming

Which one of these interfaces is implemented by the Thread class?

a)Set
b)Connections
c)Runnable
d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 26Data Structures

Which one is less costly for insertion at a particular position?

a)Array
b)Queue
c)Linked list
d)Stack

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 27Computer Architecture

Register circuit is not used in-

a)Digital clocks
b)Components
c)RAM
d)Amplifier

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 28Digital Logic

Which one is a universal logic gate?

a)NAND
b)AND
c)OR
d)NOT

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 29Data Structures

Which data structure is required for evaluating a postfix expression?

a)Queue
b)Stack
c)Linked List
d)Array

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 30Programming

Which of the declarations is correct?

a)int length
b)char int
c)int long
d)float double

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 31Programming

In Java, which operator is used to create an object?

a)class
b)scanf
c)print
d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 32Programming

Which operator can be overloaded?

a)++ (correct answer)
b)::
c). (dot)
d)0

Answer and explanation

Correct answer: (a) ++

The increment operator can be overloaded for a class in both forms: prefix as T& operator++() and postfix as T operator++(int) (the dummy int parameter marks the postfix form). In a test, a struct holding v = 3 defined N& operator++() { ++v; return *this; }; after ++n, n.v was 4.

Why the other options are wrong

(b) ::: The scope resolution operator is one of the operators C++ never allows to be overloaded.
(c) . (dot): Member access is also on the cannot-be-overloaded list (with .* and ?:).
(d) 0: This is an integer literal, not an operator, so it cannot be overloaded. (If this option was meant to be the function-call operator (), note that () can be overloaded too, as operator().)

Tip: Cannot overload: :: . .* ?: sizeof; almost everything else, including ++, --, [], () and <<, can be.

Source: operator overloading - cppreference.com

Question 33Programming

How many instances of an abstract class can be created?

a)0
b)1
c)2
d)13

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 34Programming

Which of the following cannot be checked in a switch-case statement?

a)Character
b)Integer
c)Float
d)None of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 35Software Engineering

Which of the following is a design pattern?

a)List
b)Queue
c)Factory
d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 36Cloud & Emerging Tech

The main threat of cloud-based provisioning is-?

a)Cost
b)Security
c)Virtualization
d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 37Data Structures

Linked list can be implemented by using?

a)Array
b)Pointer
c)Both A and B
d)None of above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 38Data Structures

Which of the following data structures is linear type?

a)Strings
b)Lists
c)Queue
d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Question 39Programming

In Java, which one will be used for comparing whether the two String objects str1 and str2 are the same?

a)str1=str2
b)str1.equalsIgnoreCase(str2)
c)str1==str2
d)All of the above

Sign up free to see the answer and explanation · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন