Got an interview call through a consultancy.

The first round was a coding test and followed by a technical discussion on the solution you have provided.

The second round was a general technical discussion which I felt very unorganised. No where in my resume i have mentioned that i worked on stored procedure and interview was keeping asking questions on that. Later he was not in a mood to listen to my solutions.

Given an integer array with some of the duplicate values in it.

input = [12, -9, 0, 1, 5, 12, 5, 9, 5, 8, 5]

output = [12, -9, 0, 1,5, 8]

Remove all the duplicate values. (Output order doesn't matter)

One shouldn't use java.util classes.

Write a function to validate Binary search tree?

Create a custom TreeSet so that it does case insensitive matching of records.

for ex input: abc, Abc

it shouldn't allow Abc as there is a exact string (case insensitive) already present.

Explain Left outer join with the case and query

Given table of employer with column ename as employer name. Print all the duplicate records in it.