DESCO Assistant Engineer (CSE) 2016 – Written question & solution

Questions from the DESCO Assistant Engineer (CSE) recruitment exam, 2016 – Written, shared by the candidates who sat it. The paper: 11 written questions. So far 11 written questions have been shared. Topics include DBMS, Coding, Digital Logic and Software Engineering.

Written (11)

  1. Which join should be used when there is no match between two tables?
  2. Which modifier should be used to remove duplicate rows in SQL query?
  3. Write a program in any language to find out maximum among three numbers.
  4. What does the following query do? SELECT * FROM students ORDER BY ID, NAME DESC
  5. What is the purpose of index in database?
  6. How hashtable is used in database?
  7. Trouth table construction for f(A,B,C,D) = (A+B) ⊕ (CD)
  8. Write output: #include<stdio.h> #define max(a,b) (a>b?a:b) int main(){ int i=1,j=2,k=0; k=max(i++,++j); printf("%d",k); return 0; }
  9. Draw a high level use case diagram: Use case diagram for a visitor who wants to log in to a page using a username and password.
  10. Write output: #include <stdio.h> int sum(int i){ static int total=0; total+=i; return total; } int main(){ int i; for(i=1; i<10; i++){…
  11. In java language: write a class named Bicycle having 3 integer variables (speed, gear, cost) and a constructor to initialize the…

Other papers for this post