BTCL Assistant Manager (Technical) 2017 – Written question & solution

Questions from the BTCL Assistant Manager (Technical) recruitment exam, 2017 – Written, shared by the candidates who sat it. The paper: 8 written questions. So far 8 written questions have been shared. Topics include Computer Networks, Coding, DBMS, Digital Logic and Network Security.

Written (8)

  1. Design 4×1 MUX with two selection line & 4 input (A,B,C,D) of the following sum of product (0,3,4,5,6,7) and CD as a selection line.
  2. Given an IP address 10.2.3.20/22, Find out the number of host and subnet mask.
  3. Write a program to find out the minimum number from a series.
  4. Find the output of a program. #include<stdio.h> #define N 7 void main(){ char str[] = "abpqx"; for(int i=0; i<N-2; i++) if(i%2) printf("%d…
  5. Write the disadvantage of manual IP. Name the protocol of dynamic IP assigning. How does DHCP work?
  6. What is MAC Flood in Switch? How attacker gets benefitted from it?
  7. Given a database table with some column a. find out the min salary from table b. find out a matched string
  8. Write SQL queries for the following: (a) Show the branch name with the minimum balance (b) Select all dept_name, roll from Student

Other papers for this post