Tip 1 : Practice 100+ questions of medium difficulty
Tip 2 : Study SQL and DBMS concepts in depth.
Tip 1 : Showcase only what you know.
Tip 2 : Have a proper format and at least 2 projects.
Interviewer was straight forward, first he asked me "Tell me about yourself".
Then 2 coding questions of medium difficulty.



If the given array is: [0, 0, 1, 0, 1] The largest subarray would be: [0, 1, 0, 1] (last 4 elements) having length 4.
1) First, I provided the brute force solution - only discussion
2) Then, interviewer asked to optimize the solution. I used unordered map to solve it in O(n) time complexity. He was satisfied with this approach.



If two numbers have the same frequency then keep the one that was present before the other in the original given list (array) first.
Input: arr[] = {2, 5, 2, 8, 5, 6, 8, 8}
Output: arr[] = {8, 8, 8, 2, 2, 5, 5, 6}
Explanation :
When you sort the array based on the decreasing order of the frequency of repetition of integers in the original array,
you’ll find that the element ‘8’ is the integer with the most repeated values therefore it would be arranged first after which since both 2 and 5 have the same number of repeated
values in the original array but since the 2 arrived first so we will first arrange 2 and then 5 in our resultant array, while would be the last element after sorting here.
1) I used unordered map to store frequency of elements.
2) Then sorted this map according to the requirement.
In this round, Interviewer asked SQL and DBMS in depth.
ACID properties, Normalization.
SQL JOINS queries. Asked me to write queries.
Tip 1: Revise DBMS concepts as much as possible.
Tip 2: Practice SQL queries, specially JOINS - all types (Inner, outer, left, right, left outer etc ...)
Asked to design system similar to LinkedIn.
LinkedIn System Design.
Tip 1: Start with basic requirement any system design need. ( Components, Features etc...)
Tip 2: Discuss with interviewer about your approach
Tip 3: In system design round, basically, the interviewer is looking for these things -
1) how you are approaching the question.
2) What technologies you want to use.
3) how much knowledge you have regarding the system design concepts like - load balancing, caching, rate limiting, databases etc...
Normal Behavioral questions and some puzzles.
How to make 100 by using four 7s?
Normal behavioral questions like - why do you want to join Oracle, strengths and weakness, last company work and projects.
Tip 1: Solve as many puzzles as you can.
Tip 2: interviewbit site has many puzzles.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
How do you remove whitespace from the start of a string?