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

Question

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

Sigiloso · Accepted Answer

The last question answer is wrong. You want to use UNION ALL because it is faster than UNION and the duplicates are already removed. No wonder you did not pass.

Sigiloso · Answer

Hm I’m sorry but op is right, union removes duplicates while union all doesn’t.

Meta

Pergunta de entrevista da empresa Meta

Respostas da entrevista

Empresas seguidas

Buscas de vagas