Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso Meta (Phoenix, AZ) nel mese di ott 2018
Colloquio
This is a phone call interview for HR screen. It is scheduled for 15-20 minutes. I thought they will ask some behavior questions and ask about my resume. But they didn't, they directly ask me SQL and database questions. They asked very short question, sometimes I just need to answer Yes or no, True or False, sometimes I just need to tell them the SQL command. I was very surprised that it's in this type of format.
Domande di colloquio [1]
Domanda 1
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
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Meta (New York, NY)
Colloquio
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Meta
Colloquio
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
