Assistant Network Engineer • Year 2020
Janata Bank
💼Post Name: Assistant Network Engineer
📅Exam Date: 12-Nov-2020
- ☆1Data CommunicationMultiplexingFigure shows synchronous TDM with a data stream for each input and one data stream for the output. The unit of data is 1bit. Find (a) the input bit duration (b) the output bit duration (c) the output bit rate and (d) the output frame rate.

- ☆2Digital Logic DesignKmapSimplify the following Boolean function using k-map and draw the logic circuit. F = A'B'C' + AB'C' + AB'C + A'BC + ABC
- ☆3Database Management SystemAssume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following:
- We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.
- Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DOB, start year, and shirt number that he uses.
- Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.
- For each match we need to keep track of the following: the date on which the game is played, the final result of the match and the players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card.
- ☆4Computer NetworkIn a network, an IP is 172.168.10.0/24, which needs 32 subnets. Now answer the following questions:
(i) What is the subnet mask for the maximum number of hosts?
(ii) How many hosts are available per subnet?
(iii) What are the first and last addresses of subnet 1 and subnet 32? - ☆5Database Management SystemAnswer the following question based on the following table in DBMS:
Employee (emp_id, emp_name, street, emp_city, join_date)
Works (emp_id, comp_name, leaves, salary, dept, man_id)
Company (comp_id, comp_name, comp_city)
Manager (man_id, emp_id, man_name)
(i) Write a SQL query to find employee details from the employee table who's Salary is between 5000 and 8000.
(ii) Find all employees who earn more than the average salary of all employees of that department.
(iii) Calculate the number of leaves taken by an employee.
(iv) List the managers and the number of employees working for those managers. - ☆6Computer SecurityEncrypt the message "THIS IS A" using a shift cipher with a key of 20. Ignore the space between words. Decrypt the message to get the original plaintext.
- ☆7Programming ConceptWrite a C/C++ program to check balanced parenthesis in an Expression
- ☆8Non Technical Questionজলবায়ু পরিবর্তন ও বাংলাদেশে এর প্রভাব
Role of Information Technology (IT) in the Banking Sector.
- ☆9Data StructureBSTAnswer the following question:
In-order: 10, 20, 40, 50, 60, 70, 90, 100
Pre-order: 50, 20, 10, 40, 70, 60, 90, 100
(i) Construct a BST from the following sequence.
(ii) Write pseudocode the sum of all nodes.

