This was a phone call interview for an HR screen, scheduled for 15-20 minutes. I expected behavioral questions and discussion about my resume. However, they directly asked me SQL and database questions. The questions were very short, sometimes requiring only a 'Yes' or 'No', 'True' or 'False' answer, and other times just the SQL command. I was quite surprised by this format.
The ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending?
Answer: Ascending
When you want to delete or add a column to a table in a database, what command will you use? Answer: ALTER
This question is 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
You want to combine two columns after removing duplicates. Use UNION or UNION ALL?
Answer: UNION
The following metrics were computed from 1 interview experience for the Meta Data Engineer role in Phoenix, Arizona.
Meta's interview process for their Data Engineer roles in Phoenix, Arizona is extremely selective, failing the vast majority of engineers.
Candidates reported having very negative feelings for Meta's Data Engineer interview process in Phoenix, Arizona.