CS6400 ELITE REVIEW 2026 WITH ACTUAL
QUESTIONS AND CORRECT VERIFIED
ANSWERS GRADED A PLUS
◉Left Outer Join . Answer: 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.
◉Insert . Answer: A basic SQL operation in which new records are
added to a table.
◉Delete . Answer: A basic SQL operation in which existing records are
removed from a table.
◉Update . Answer: A basic SQL operation in which existing records are
changed in a table.
◉Select * . Answer: A basic SQL operation in which existing records are
chosen from a table.
, ◉Select Distinct . Answer: A basic SQL operation in which only unique
existing records are chosen from a table.
◉Intersect . Answer: Set operator which includes all tuples that are in
both R and S.
◉Union . Answer: Set operator which includes all tuples that are either
in R or in S or in both R and S. Duplicates are removed.
◉Union All . Answer: set operator which includes all tuples that are
either in R or in S or in both R and S. Duplicates are not removed.
◉Count(*) . Answer: SQL function which returns the number of rows
that matches the specified criteria.
◉Group By . Answer: SQL operator which rolls up the result set by one
or more columns.
◉Equijoin . Answer: A theta join using the equality operator
◉Difference / Minus . Answer: Set operator which includes all tuples
that are in R but not in S
QUESTIONS AND CORRECT VERIFIED
ANSWERS GRADED A PLUS
◉Left Outer Join . Answer: 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.
◉Insert . Answer: A basic SQL operation in which new records are
added to a table.
◉Delete . Answer: A basic SQL operation in which existing records are
removed from a table.
◉Update . Answer: A basic SQL operation in which existing records are
changed in a table.
◉Select * . Answer: A basic SQL operation in which existing records are
chosen from a table.
, ◉Select Distinct . Answer: A basic SQL operation in which only unique
existing records are chosen from a table.
◉Intersect . Answer: Set operator which includes all tuples that are in
both R and S.
◉Union . Answer: Set operator which includes all tuples that are either
in R or in S or in both R and S. Duplicates are removed.
◉Union All . Answer: set operator which includes all tuples that are
either in R or in S or in both R and S. Duplicates are not removed.
◉Count(*) . Answer: SQL function which returns the number of rows
that matches the specified criteria.
◉Group By . Answer: SQL operator which rolls up the result set by one
or more columns.
◉Equijoin . Answer: A theta join using the equality operator
◉Difference / Minus . Answer: Set operator which includes all tuples
that are in R but not in S
