Senior Analyst

You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to return the list of all pairs of elements such that each sum of elements of each pair equals 'S'.

Note:

Each pair should be sorted i.e the first value should be less than or equals to the second value. 

Return the list of pairs sorted in non-decreasing order of their first value. In case if two pairs have the same first value, the pair with a smaller second value should come first.

You have been given an integer ‘N’. You are supposed to find if the given integer ‘N’ is a perfect square or not. A perfect square is an integer that is the square of an integer.

Raj invested Rs 76000 in a business. After few months Monty joined him and invests Rs 57000. At the end of the year, both of them share the profits at the ratio of 2:1. After how many months Monty joined Raj?

The cost price of 20 articles is the same as the selling price of x articles. If the profit is 25%, find the value of x?

Two taps can separately fill a cistern 10 minutes and 15 minutes respectively and when the waste pipe is open, they can together fill it in 18 minutes. The waste pipe can empty the full cistern in?

When Rajesh was born, his father age was 29 years older than his Brother and his Mother was 25 years older than his Sister. If his Brother is 2 years elder than his Sister. After 6 years the average age of the family is 20. Then what is the age of Mother when Rajesh was born?

Introduce yourself.

Do you have any certification in DBMS and Java?

Will you be able to come for walk in interview tomorrow?

Do you have any other job offer?

Where do you see yourself after 5 years?

You are given an unsorted array/list 'ARR' of 'N' integers. Your task is to return the length of the longest consecutive sequence.

The consecutive sequence is in the form ['NUM', 'NUM' + 1, 'NUM' + 2, ..., 'NUM' + L] where 'NUM' is the starting integer of the sequence and 'L' + 1 is the length of the sequence.

Note:

If there are any duplicates in the given array we will count only one of them in the consecutive sequence.

For example-

For the given 'ARR' [9,5,4,9,10,10,6].

Output = 3
The longest consecutive sequence is [4,5,6].

Follow Up:

Can you solve this in O(N) time and O(N) space complexity?

What are types of Keys?(Learn)

Make a table in which you have to explain all the keys with an example

Write an SQL query in which you have to find students whose age is more than 15 years from a students table consisting of name, roll no, Subjects , DOB

Write a SQL query for finding students who have to pay the school fees.

How will you join 2 tables. What are the types of Joins?

What are acid bases properties in DBMS

What are different frameworks in java

What is SVM and reinforcement technique?(Learn)

What are static variables and what is the difference between final, finally, finalize?(Learn)