My technical Interview questions consists primary of three sections:

1. Program/Algorithm

2. Theoretical

3. Sql

**Program/Algorithm Interview Questions**

1. Write a recursive function reverseString(string str) that reverses an input string.

Where 'str' is the string to be reversed.

2. Write a function that will find all numbers which appears only once in an array of duplicates.

3. Recursive function to calculate factorial of an number.

4. Write a program to reverse a doubly linked list with/without using extra memory.

5. Sort an array based on frequency of numbers.

**Theoretical Interview Questions**

1. Which one is quicker and why?

A) Array

B) Link List.

2. How is mutex different from semaphore

3. Complexity of some sorting algos like quick,merge,hash...

**Sql Interview Questions**

1. Queries on joins(self join + left join)

2. Normalization concept and i was asked to normalize a table.

1. Program/Algorithm

2. Theoretical

3. Sql

1. Write a recursive function reverseString(string str) that reverses an input string.

Where 'str' is the string to be reversed.

2. Write a function that will find all numbers which appears only once in an array of duplicates.

3. Recursive function to calculate factorial of an number.

4. Write a program to reverse a doubly linked list with/without using extra memory.

5. Sort an array based on frequency of numbers.

1. Which one is quicker and why?

A) Array

B) Link List.

2. How is mutex different from semaphore

3. Complexity of some sorting algos like quick,merge,hash...

1. Queries on joins(self join + left join)

2. Normalization concept and i was asked to normalize a table.

Thanks Anmol for sharing the details of your interview.

Send more details and your personal experiences

Discussion

Suggestions

A barman is having a 12 liters jug full of beer. He needs to divide or split that beer into two equal parts. All he has is two empty jugs of capacity 8 liters and 5 liters.

How will he do it using them?

How will he do it using them?

In a recreational activity, you are given four different jars of 2 liters, 4 liters, 6 liters and 8 liters respectively with an unlimited water supply. Then you are asked to measure exactly 5 liters of water using them.

How will you do it?

How will you do it?

On a magical-intellectual land of gpuzzles , all the animal are rational(real smart).

There are six leopards and one sheep.

Leopard can eat sheep but since as the land is magical, the leopards who eats the sheep , turns into sheep and then can be eaten by the remaining leopard(s).

If we leave them for some time then how many sheep and leopard will be there , when we come back ?

There are six leopards and one sheep.

Leopard can eat sheep but since as the land is magical, the leopards who eats the sheep , turns into sheep and then can be eaten by the remaining leopard(s).

If we leave them for some time then how many sheep and leopard will be there , when we come back ?

I have two rectangular bars.

They have property such that when you light the fire from one end , it will take exactly 60 seconds to get completely burn.

However they do not burn at consistent speed (i.e it might be possible that 40 percent burn in 55 seconds and next 60 percent can burn in 10 seconds).

Problem is : How do you measure 45 seconds ?

They have property such that when you light the fire from one end , it will take exactly 60 seconds to get completely burn.

However they do not burn at consistent speed (i.e it might be possible that 40 percent burn in 55 seconds and next 60 percent can burn in 10 seconds).

Problem is : How do you measure 45 seconds ?

For my anniversary, I decided to surprise my wife. Since she is a voracious reader, I decided to collect a lot of books for her. On the first day of the month, I bought one book, on the second, I bought two and on the third, I bought three. This process went on till the anniversary and on the day, I had 276 books with me to gift her.

Can you calculate, on which day is our anniversary?

Can you calculate, on which day is our anniversary?

There are two glasses in front of you. One of the glasses is full of coke and the other glass is full of lemonade. You take a spoonful of coke and mix it into the glass of lemonade. Now the lemonade glass has a mixture of coke and lemonade. You take a spoonful of that mixture and mix it inside the coke glass.

Now what do you think? - The glass with coke has more quantity of lemonade or the glass with lemonade have more quantity of coke mixed with it?

Now what do you think? - The glass with coke has more quantity of lemonade or the glass with lemonade have more quantity of coke mixed with it?

There is a box full of fruits,

all but two are grapes,

all but two are apples,

and all but two are oranges.

How many fruits are in the box ?

all but two are grapes,

all but two are apples,

and all but two are oranges.

How many fruits are in the box ?

This one is a bit of tricky river crossing puzzle than you might have solved till now. We have a whole family out on a picnic on one side of the river. The family includes Mother and Father, two sons, two daughters, a maid and a dog. The bridge broke down and all they have is a boat that can take them towards the other side of the river. But there is a condition with the boat. It can hold just two persons at one time (count the dog as one person).

No it does not limit to that and there are other complications. The dog can’t be left without the maid or it will bite the family members. The father can’t be left with daughters without the mother and in the same manner, the mother can’t be left alone with the sons without the father. Also an adult is needed to drive the boat and it can’t drive by itself.

How will all of them reach the other side of the river?

No it does not limit to that and there are other complications. The dog can’t be left without the maid or it will bite the family members. The father can’t be left with daughters without the mother and in the same manner, the mother can’t be left alone with the sons without the father. Also an adult is needed to drive the boat and it can’t drive by itself.

How will all of them reach the other side of the river?

You are trapped with a lion in a cage with 1 unit as its radius. Both you and the lion can run effortlessly at the speed of one unit.

1) The lion is quite hungry and all he wants is to catch you and eat you up. Will he be able to do that?

2) If yes, how long do you have till he does that?
**category** :
LOGIC

1) The lion is quite hungry and all he wants is to catch you and eat you up. Will he be able to do that?

2) If yes, how long do you have till he does that?

I got two jugs of

A) 11 liter

B) 6 liter

How can I measure exactly 9 liters ?

A) 11 liter

B) 6 liter

How can I measure exactly 9 liters ?

21 February

Can you count the number of holes in the...

20 February

You have a glass of water and a glass of...

19 February

20 girls from NewJersey jumps into the e...

18 February

In which month people in Liverpool sleep...

17 February

Which superhero movie is hidden in the r...

16 February

A well-known chemist name from London wa...

15 February

what does below rebus means?...