A relational operator that yields values from all rows found in a table is known as the ____ operator.
difference
product
select
project
A relational operator that yields all values for selected attributes is known as the ____ operator.
difference
product
select
project
The ____________ set operator combines all tuples from two relations excluding duplicates.
union
intersect
difference
divide
The ____________ set operator returns only tuples that are in both relations.
difference
project
intersect
union
What is meant by the following relational algebra statement: STUDENT X COURSE
Compute the natural join between the STUDENT and COURSE relations
Compute the left outer join between the STUDENT and COURSE relations
Compute the cartesian product between the STUDENT and COURSE relations
Compute the outer join between the STUDENT and COURSE relations
What is meant by the term union compatibility?
When two or more tables share the same number of columns and when they share the same domains
When two or more tables share the same number of columns
When two or more tables have the same degree
When two or more tables share the same (or compatible) domains
The ___________ operator returns all tuples in one relation that are not found in the other relation.
intersect
product
select
difference
If relation A has 6 rows and 4 attributes and relation B has 3 rows and 2 attributes and the cartesian product operation was carried out on relation A and relation B, What would be the cardinaility of the new relation C where C = A X B?
18
6
24
12
If relation A has 6 rows and 4 attributes and relation B has 3 rows and 2 attributes and the cartesian product operation was carried out on relation A and relation B, What would be the degree of the new relation C where C = A X B?
12
24
6
18
A(n) ____________________ is where tuples from one relation that do not have matching values in the common attributes of the second relation are also included in the result of perfroming the join and any missing values in the second relation are set to null.
theta-join
equi-join
natural join
outer join
An ______________ is a join where the only comparison operator used in the predicate is =.
theta-join
equi-join
natural join
outer join
An ______________ is a join where the tuples in a cartesian product of two relations satisfying some predicate which uses any of the following comparison signs (= ≠ < > ≤ ≥).
equi-join
natural join
theta-join
outer join
In a(n) _________________, if no match is made between the tuples in the relation, the new relation does not include the unmatched tuple. and the column on which the join was made occurs only once in the new relation.