Janata Bank Assistant Network Engineer 2020 – Written question & solution

Questions from the Janata Bank Assistant Network Engineer recruitment exam, 2020 – Written, shared by the candidates who sat it. The paper: 32 written questions. So far 36 MCQs and 32 written questions have been shared. Topics include Computer Networks, DBMS, Coding, Computer Architecture and Algorithm.

MCQ (36)

Which is the correct output? int i = 4; printf ("%d%d", ++i, i++); printf ("%d ", i++);
1. a) 5 4 6
2. b) 5 7 8
3. c) 6 4 6
4. d) 4 5 7
Which is not a feature of Java OOP?
1. a) Multiple Inheritance
2. b) Multi-level inheritance
3. c) Compile time Polymorphism
4. d) Runtime Polymorphism
If you are assigned to remove partial dependency from a database, which technique will you use?
1. a) 1NF
2. b) 2NF
3. c) 3NF
4. d) BCNF
Suppose you have a complete undirected graph with 4 nodes. What is the maximum number of minimum spanning trees (MSTs) you can form?
1. a) 4
2. b) 8
3. c) 16
4. d) 1
Which one of the following is the default port of HTTP?
1. a) 23
2. b) 25
3. c) 80
4. d) 45
What will be the state of a queue after executing the following operations? push(1), push(2), pop(), push(4), push(5), pop()
1. a) 2, 5
2. b) 2, 4
3. c) 4, 5
4. d) 1, 4
Which one is the wrong statement for the BIOS of a computer?
1. a) Connects microprocessor and I/O
2. b) Manages data flow
3. c) Loads the operating system
4. d) Provides storage
DHCP means?
1. a) Dynamic Host Control Protocol
2. b) Domain Host Configuration Protocol
3. c) Distributed Host Configuration Protocol
4. d) Dynamic Host Configuration Protocol
Which one is not a database transaction property?
1. a) Atomicity
2. b) Consistency
3. c) Durability
4. d) Quality
How many bits in IPv6?
1. a) 32
2. b) 64
3. c) 128
4. d) 156
How can we prevent SQL Injection Attack?
1. a) Show the database error to the users
2. b) Do not remove potential malicious code
3. c) Use the user input directly
4. d) Use input validation
A complex bandpass signal has a bandwidth of 300 kHz. What is the minimum sampling rate for this signal?
1. a) 600,000 samples per second
2. b) 600,00 samples per second
3. c) 600 kHz
4. d) None of the above
The human voice normally contains frequencies from 0 to 4000 Hz. If we sample at the Nyquist rate using 8 bits per sample, what is the…
1. a) 8000 samples/second
2. b) 8000 kbps
3. c) 64 kbps
4. d) 64 samples/second
Which one is the loopback address?
1. a) 255.255.255.0
2. b) 127.0.0.1
3. c) 255.0.0.0
4. d) 127.127.127.0
Which one is not the purpose of modulation in a communication system?
1. a) To reduce antenna size
2. b) To save energy to transmit information
3. c) To transmit signals from various sources
4. d) To make the system simpler and cost effective
Five channels, each with a 100-kHz bandwidth, are to be multiplexed together. What is the minimum bandwidth of the link if there is a need…
1. a) 500 kHz
2. b) 520 kHz
3. c) 540 kHz
4. d) 525 kHz
Assume we need to download text documents at the rate of 100 pages per sec. Each page contains an average of 24 lines with 80 characters…
1. a) 1.92 Mbps
2. b) 1.636 Mbps
3. c) 1.82 Mbps
4. d) 1.536 Mbps
Consider an extremely noisy channel in which the value of the signal-to-noise ratio is almost zero. For this channel, if the bandwidth is…
1. a) 0.137B
2. b) 0
3. c) 0.137
4. d) Infinity
A binary counter is being pulsed by a 256 kHz clock signal. The output frequency from the last flip-flop is 2 kHz. Which one of the…
1. a) 0 to 255
2. b) 0 to 128
3. c) 0 to 127
4. d) None of the above
When a web browser interacts with a web server, the following actions take place. A1: The web browser requests a webpage using HTTP. A2…
1. a) A4, A2, A1, A3
2. b) A1, A2, A3, A4
3. c) A4, A1, A2, A3
4. d) A2, A4, A1, A3
Suppose you are using an HTML browser at a client machine C to access a static HTML webpage hosted in an HTTP server S. The page contains…
1. a) C needs to send at least 2 HTTP requests to S using two different TCP connections.
2. b) C needs to send at least 2 HTTP requests to S but a single TCP connection is sufficient.
3. c) A single HTTP request is sufficient without using any TCP connection from C to S.
4. d) A single HTTP request is sufficient using a single TCP connection from C to S.
Which of the following is the Protocol Data Unit (PDU) for the application layer in the Internet stack?
1. a) Segment
2. b) Datagram
3. c) Message
4. d) Frame
Software goes through a phase in which errors are verified and studied on simulated user environments. This is referred to as-
1. a) Alpha testing
2. b) Beta testing
3. c) Gamma testing
4. d) Delta testing
Suppose you are searching student data using student number as the key. Which of the following arrangement of the student data is suited…
1. a) Student data are arranged in the positions indicated by the student numbers' hash values
2. b) Student data are arranged randomly irrespective of the student numbers
3. c) Student data are arranged in ascending order of student numbers
4. d) Student data are arranged in the order of the cell addresses of the student numbers' locations.
A relationship is given below in an ER diagram. How many tables can be created (preferred) from below diagram?
1. a) One
2. b) Two
3. c) Three
4. d) No definite numbers
Which of the following statements about connecting devices between LANs is accurate?
1. a) Gateway converts the protocols of the first to third layers of the OSI basic reference model
2. b) Bridge relays frames based on IP address
3. c) Repeater extends transmission distance by amplifying the signal between segments of the same type
4. d) Router relays frames based on MAC address
Suppose you want to insert n elements into an empty linked list while maintaining the sorted order. What is the worst-case time complexity?
1. a) θ(n)
2. b) θ(n log n)
3. c) θ(1)
4. d) θ(n²)
Consider an Entity-relationship (ER) model where R is defined as a many-to-one relationship from entity set E1 to entity set E2. If E1 and…
1. a) Every entity in E1 is associated with exactly one entity in E2
2. b) Some entity in E1 is associated with more than one entity in E2
3. c) Every entity in E2 is associated with exactly one entity in E1
4. d) Every entity in E2 is associated with at most one entity in E1
After a transaction completes successfully, the changes it has made to the database persist, even if there are system failures. This…
1. a) Atomicity
2. b) Consistency
3. c) Isolation
4. d) Durability
Consider the following Employee Table and the SQL query given: id Date Work_hour 1 2020-10-18 8 1 2020-10-17 8 1 2020-10-16 9 2 2020-10-18…
1. a) 3
2. b) 4
3. c) 2
4. d) 0
Suppose you need to assign IPv4 addresses to two computers of your company so that both computers belong to the subnet 255.255.255.240…
1. a) 172.16.5.14 and 172.16.5.17
2. b) 172.16.5.17 and 172.16.5.29
3. c) 172.16.5.29 and 172.16.5.33
4. d) 172.16.5.33 and 172.16.5.4
Following table shows the delivery record of an online shop. Which of the SQL statements results in the largest value? Product Id Date…
1. a) SELECT AVG(Quantity) FROM Delivery Record WHERE Product id='F101'
2. b) SELECT COUNT (*) FROM Delivery Record
3. c) SELECT SUM (Quantity) FROM Delivery Record WHERE Date = '2020-10-16'
4. d) SELECT MAX (Quantity) FROM Delivery Record
Which one of the following regular expressions represents the set of all binary strings with an odd number of 1's?
1. a) ((0+1)*1(0+1)*1)*10*
2. b) (0*10*10*)*0*1
3. c) 1*+(1*01*0)*1*
4. d) None
_____ is an assault on a service from a single source that floods it with so many requests that it becomes overwhelmed and is either…
1. a) Denial-of-service (DoS) attack
2. b) Spoofing attack
3. c) Cross-site scripting (XSS) attack
4. d) Buffer overflow attack
What is the output power in watts of the following three-stage system?
1. a) 0.431 Watt
2. b) 0.5 Watt
3. c) 18 Watt
4. d) 0.0631 Watt
Suppose the operating clock frequency of a typical CPU is 700 MHz and the number of clocks required for execution of three different…
1. a) 10
2. b) 50
3. c) 70
4. d) 100

Written (32)