CS6400 Exam 3 QUESTIONS WITH |\ |\ |\ |\ |\
ANSWERS
The result of this is the set of all combinations of tuples in R and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
S that are equal on their common attribute names. A special case
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of an equijoin. - CORRECT ANSWERS ✔✔Natural Join
|\ |\ |\ |\ |\ |\ |\ |\
A construct operator which results in the set of all combinations
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of tuples in R and S that are equal on their common attribute
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
names, in addition (loosely speaking) to tuples in R that have no
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
matching tuples in S. - CORRECT ANSWERS ✔✔Left Outer Join
|\ |\ |\ |\ |\ |\ |\ |\ |\
A basic SQL operation in which new records are added to a table.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Insert
|\ |\ |\ |\
A basic SQL operation in which existing records are removed
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
from a table. - CORRECT ANSWERS ✔✔Delete
|\ |\ |\ |\ |\ |\
A basic SQL operation in which existing records are changed in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
table. - CORRECT ANSWERS ✔✔Update
|\ |\ |\ |\
A basic SQL operation in which existing records are chosen from
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
a table. - CORRECT ANSWERS ✔✔Select *
|\ |\ |\ |\ |\ |\
A basic SQL operation in which only unique existing records are
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
chosen from a table. - CORRECT ANSWERS ✔✔Select Distinct
|\ |\ |\ |\ |\ |\ |\ |\
, Set operator which includes all tuples that are in both R and S. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Intersect |\ |\
Set operator which includes all tuples that are either in R or in S
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
or in both R and S. Duplicates are removed. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Union |\
set operator which includes all tuples that are either in R or in S
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
or in both R and S. Duplicates are not removed. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Union All |\ |\
SQL function which returns the number of rows that matches the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
specified criteria. - CORRECT ANSWERS ✔✔Count(*)
|\ |\ |\ |\ |\
SQL operator which rolls up the result set by one or more
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
columns. - CORRECT ANSWERS ✔✔Group By
|\ |\ |\ |\ |\
A theta join using the equality operator - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Equijoin
Set operator which includes all tuples that are in R but not in S -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Difference / Minus|\ |\ |\ |\
A construct operator which allows for arbitrary comparison
|\ |\ |\ |\ |\ |\ |\ |\
relationships (such as >=) - CORRECT ANSWERS ✔✔Theta Join
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS
The result of this is the set of all combinations of tuples in R and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
S that are equal on their common attribute names. A special case
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of an equijoin. - CORRECT ANSWERS ✔✔Natural Join
|\ |\ |\ |\ |\ |\ |\ |\
A construct operator which results in the set of all combinations
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of tuples in R and S that are equal on their common attribute
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
names, in addition (loosely speaking) to tuples in R that have no
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
matching tuples in S. - CORRECT ANSWERS ✔✔Left Outer Join
|\ |\ |\ |\ |\ |\ |\ |\ |\
A basic SQL operation in which new records are added to a table.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Insert
|\ |\ |\ |\
A basic SQL operation in which existing records are removed
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
from a table. - CORRECT ANSWERS ✔✔Delete
|\ |\ |\ |\ |\ |\
A basic SQL operation in which existing records are changed in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
table. - CORRECT ANSWERS ✔✔Update
|\ |\ |\ |\
A basic SQL operation in which existing records are chosen from
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
a table. - CORRECT ANSWERS ✔✔Select *
|\ |\ |\ |\ |\ |\
A basic SQL operation in which only unique existing records are
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
chosen from a table. - CORRECT ANSWERS ✔✔Select Distinct
|\ |\ |\ |\ |\ |\ |\ |\
, Set operator which includes all tuples that are in both R and S. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Intersect |\ |\
Set operator which includes all tuples that are either in R or in S
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
or in both R and S. Duplicates are removed. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Union |\
set operator which includes all tuples that are either in R or in S
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
or in both R and S. Duplicates are not removed. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Union All |\ |\
SQL function which returns the number of rows that matches the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
specified criteria. - CORRECT ANSWERS ✔✔Count(*)
|\ |\ |\ |\ |\
SQL operator which rolls up the result set by one or more
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
columns. - CORRECT ANSWERS ✔✔Group By
|\ |\ |\ |\ |\
A theta join using the equality operator - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Equijoin
Set operator which includes all tuples that are in R but not in S -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Difference / Minus|\ |\ |\ |\
A construct operator which allows for arbitrary comparison
|\ |\ |\ |\ |\ |\ |\ |\
relationships (such as >=) - CORRECT ANSWERS ✔✔Theta Join
|\ |\ |\ |\ |\ |\ |\ |\
