Week 1 Relational Model: Manipulation Quiz

Multiplies the tuples in two relations together.

Combines two relations to produce a set of tuples belonging to both.

Combines two relations to produce a set of tuples belonging to one but not the other. (correct)

Intersects the tuples in two relations.

A combination of the attribute names from both input relations.

A relation containing a set of tuples belonging to both input relations. (correct)

A union of the tuples in both input relations.

A relation containing a set of distinct tuples from both input relations.

Both instances are considered separately in the join.

One instance of the common attribute is randomly chosen for the join.

The common attribute is ignored during the join.

The common attribute is duplicated in the resulting relation. (correct)

<p>It includes all rows from one table and only matching rows from the other table.</p> Signup and view all the answers

<p>'Theta' join</p> Signup and view all the answers