Associate Consultant

Explain normalization with the help of examples,
ACID properties,
Triggers, SQL queries.
One question was -> "What is Pragma".

You are given a string 'exp' which is a valid infix expression.

Convert the given infix expression to postfix expression.

Note:

Infix notation is a method of writing mathematical expressions in which operators are placed between operands. 

For example, "3 + 4" represents the addition of 3 and 4.

Postfix notation is a method of writing mathematical expressions in which operators are placed after the operands. 

For example, "3 4 +" represents the addition of 3 and 4.

Expression contains digits, lower case English letters, ‘(’, ‘)’, ‘+’, ‘-’, ‘*’, ‘/’, ‘^’. 

Example:

Input: exp = ‘3+4*8’

Output: 348*+

Explanation:
Here multiplication is performed first and then the addition operation. Hence postfix expression is  3 4 8 * +.

MCQs on Java .... Collection framework, Multi threading etc.

MCQs on swapping, thrashing, semaphores, paging, scheduling algorithms. 
Some computer network questions were also there.

You have been given an integer array/list 'ARR' of size 'N'. Your task is to return the total number of those subsequences of the array in which all the elements are equal.

A subsequence of a given array is an array generated by deleting some elements of the given array with the order of elements in the subsequence remaining the same as the order of elements in the array.

Note :

As this value might be large, print it modulo 10^9 + 7

Different sorting algorithms and their implementation in real life.
Doubly linked list with real time examples.
Minor project
Difference between UNION and UNION ALL
Difference between UNION and JOIN
Different types of JOIN with examples.

Difference between #include "filename" and #include in C++.

Questions regarding java and project were asked. 
Difference between prepared statement and callable statement were asked. 
Asked to explain different methods for multithreading... (run and start method).
In depth explanation of JDBC... all 4 types of connectivity.

Basic HR questions were asked and one puzzle was asked.

Do you have any serious medical issues? 

Did you ever have a conflict with your current/previous boss or professor?