Data Analyst

They asked about the internship experiences, technical knowledge(What I was comfortable in), SQL basic questions like order of query etc., some statistics related questions such as mean median mode and their application differences.

Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName.

Write a query to create a new table which consists of data and structure copied from the other table.

Write q query to find all the employees whose salary is between 50000 to 100000.

Four people need to cross a rickety bridge at night. Unfortunately, they have only one torch and the bridge is too dangerous to cross without one. The bridge is only strong enough to support two people at a time. Not all people take the same time to cross the bridge. Times for each person: 1 min, 2 mins, 7 mins and 10 mins. What is the shortest time needed for all four of them to cross the bridge?

You have two jars, 50 red marbles and 50 blue marbles. You need to place all the marbles into the jars such that when you blindly pick one marble out of one jar, you maximize the chances that it will be red. When picking, you’ll first randomly pick a jar, and then randomly pick a marble out of that jar. You can arrange the marbles however you like, but each marble must be in a jar.

Given an array/list 'ARR' of ‘N’ distinct integers, you are supposed to find the third largest element in the given array 'ARR'.

What is an Index? Explain its different types.

What is Data Integrity?

1. Family background.
2. Why should I be hired.
3. Guesstimates (AGAIN!!!)
4. Puzzles (BASIC and INTERMEDIATE levels)
5. Expectations from the company.
6. When I can begin work.
7. Existing offers that I had (I had 2 offers by then so some questions were asked on that)
8. Core values of the company and how am I a suitable fit.