Data Interview Questions

133,156 data interview questions shared by candidates

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
avatar

Data Engineer

Interviewed at Meta

3.5
Oct 26, 2018

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION

Two tables: User actions: date|sessio_id|userid|event session details: date|Sessionid|timespent_Sec|userid 1. Identify avg time spent per user per day 2. Create a histogram of duration on x axis, no of users on y axis which is populated by volume in each bucket Product questions: 1. Wants to add a new banner on FB Market place which suggests to sell something on facebook , should they do it, what should be done to evaluate it ? 2. Market place transactions happen through messages - these messages went down by 10% in a month, should they be worried ? How would you go about analyzing it?
avatar

Data Scientist

Interviewed at Meta

3.5
Apr 15, 2019

Two tables: User actions: date|sessio_id|userid|event session details: date|Sessionid|timespent_Sec|userid 1. Identify avg time spent per user per day 2. Create a histogram of duration on x axis, no of users on y axis which is populated by volume in each bucket Product questions: 1. Wants to add a new banner on FB Market place which suggests to sell something on facebook , should they do it, what should be done to evaluate it ? 2. Market place transactions happen through messages - these messages went down by 10% in a month, should they be worried ? How would you go about analyzing it?

Viewing 981 - 990 interview questions

Glassdoor has 133,156 interview questions and reports from Data interviews. Prepare for your interview. Get hired. Love your job.