Тест по SQL JOIN (en)

1 / 10

What is the correct Syntax of JOIN?

Не верно!

Верно!

Не верно!

Не верно!

True or false: EQUI JOIN is also called as INNER JOIN.

Верно!

Не верно!

Which of following is not OUTER JOIN?

Не верно!

Не верно!

Не верно!

Верно!

Which JOIN is a join operation that creates an implicit join clause for you based on the common columns in the two tables being joined?

Не верно!

Не верно!

Верно!

Не верно!

True or False: CROSS JOIN fetches the common values from multiple tables

Не верно!

Верно!

What is not type of JOIN?

Не верно!

Не верно!

Верно!

Не верно!

True or False: The output of CROSS JOIN and FULL OUTER JOIN is same.

Не верно!

Верно!

True or false: LEFT OUTER JOIN output and RIGHT OUTER JOIN output is different

Верно!

Не верно!

True or false: UNION statement = INNER JOIN

Не верно!

Верно!

Which statement is used to rename table?

Верно!

Не верно!

Не верно!

Не верно!

Далее
0 из 10

Поздравляем с прохождением теста! Для улучшения знаний по SQL – перейдите в наш канал “Задачи по SQL” по кнопке ниже

Интересно, хочу попробовать