CS6400 ACTUAL EXAM PAPER 2026
QUESTIONS WITH SOLUTIONS GRADED A+
◉ 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
◉ Theta Join. Answer: A construct operator which allows for arbitrary
comparison relationships (such as >=)
QUESTIONS WITH SOLUTIONS GRADED A+
◉ 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
◉ Theta Join. Answer: A construct operator which allows for arbitrary
comparison relationships (such as >=)
