Question $5$

$2pts$

Which best describes a theta join?

$$ if there is at least one common attribute that exists between two relations and the attributes must have the same name and domain

When Theta join uses only equality comparison operator

includes only those tuples with matching attributes and the rest are discarded in the resulting relation

combines tuples from different relations provided they satisfy the theta condition

Question $6$

$2pts$

What best describes a left outer join?

All the tuples from the Right relation are included in the resulting relation

All the tuples from both participating relations are included in the resulting relation

All the tuples from the Left relation are included in the resulting relation

includes only those tuples with matching attributes and the rest are discarded in the resulting relation