The SQL questions were a fairly standard "design a table, give me the SQL queries to do X, Y, and Z". I made sure the table design was 3NF (although I'm not sure he caught that). Then he asked me to do a simple SELECT/JOIN query, and then another that was more complicated. The multithreading question was detailing a solution for "put" and "fetch" methods for a BlockingQueue. The methods had to maintain the order of the threads attempting the operations.
Oops concept
Hibernate Basics
If there are 20 people in a tournament and each match the loser will leave the tournament then how many total matches should be played to decide the winner
Coding: Leetcode-like Medium and Hard problems can be expected as a challenge. System Design: add additional components and explain how they will act in existing ecosystem.
write bubble sort and find completely
Problem on currency conversion Design a microswrvice
Parse logger text file that has date and process activity in every line. print addition of activities concentrated within 5 mins gap in decreasing order of the values
Write code to sum the values contained in two memory slots into a third memory slot, using only 3 instructions: zero <slot> increment <slot> jlt <slot1>,<slot2> <location>, where jlt=jump to <location> if <slot1>is less than <slot2>.
Given two arrays: arr1[0..m-1] and arr2[0..n-1]. Find whether arr2[] is a subset of arr1[] or not. Both the arrays are not in sorted order. It may be assumed that elements in both array are distinct.
Viewing 1091 - 1100 interview questions