CISC 3140 FINAL TEST 2026 QUESTIONS WITH CORRECT ANSWERS GRADED A+

CISC 3140 FINAL TEST 2026 QUESTIONS
WITH CORRECT ANSWERS GRADED A+

>> SQL
Answer: Structured Query Language


>> SELECT
Answer: Retrieve data


>> FROM
Answer: Specifies table(s)


>> WHERE
Answer: Filtering condition


>> ORDER BY
Answer: Sort results


>> GROUP BY
Answer: Group rows


>> HAVING
Answer: Filter groups


>> JOIN
Answer: Combine tables

, >> INNER JOIN
Answer: Matching rows only


>> LEFT OUTER JOIN
Answer: All from left, matching from right


>> RIGHT OUTER JOIN
Answer: All from right, matching from left


>> FULL OUTER JOIN
Answer: All from both tables


>> CROSS JOIN
Answer: Cartesian product


>> SELF JOIN
Answer: Table joined to itself


>> Subquery
Answer: Query nested inside another


>> Correlated Subquery
Answer: References outer query


>> EXISTS
Answer: Checks for existence


>> IN
Answer: Checks membership in set