Business Technology Analyst

You have been given an integer array/list(ARR) of size 'N'. It only contains 0s, 1s and 2s. Write a solution to sort this array/list.

Note :

Try to solve the problem in 'Single Scan'. ' Single Scan' refers to iterating over the array/list just once or to put it in other words, you will be visiting each element in the array/list just once.

Bank management system was given and some cases were given and using that information we had to write the query and show the output which is required.
Tables and data were given.
Do practice sql query questions for the case study.

Aahad and Harshit always have fun by solving problems. Harshit took a sorted array consisting of distinct integers and rotated it clockwise by an unknown amount. For example, he took a sorted array = [1, 2, 3, 4, 5] and if he rotates it by 2, then the array becomes: [4, 5, 1, 2, 3].

After rotating a sorted array, Aahad needs to answer Q queries asked by Harshit, each of them is described by one integer Q[i]. which Harshit wanted him to search in the array. For each query, if he found it, he had to shout the index of the number, otherwise, he had to shout -1.

For each query, you have to complete the given method where 'key' denotes Q[i]. If the key exists in the array, return the index of the 'key', otherwise, return -1.

Note:

Can you solve each query in O(logN) ?

What is the difference between Sql and no sql databases? 
Write query to find the second largest salary from the employee table

What is Oops? 
What is abstraction, polymorphism? 
Method overloading and overriding

Questions on Resume projects were asked 
Like how you were able to achive the completion of project and what technologies you used while making so

Some hr questions were asked to check the confidence like 
When during your internship you feel difficulty? 
What did you do to overcome that? 
How you manage to work internship and college together.