(Answered) CIST 1220 Final Review: CIST 1220 SQL - Gwinnett Technical College.

(Answered) CIST 1220 Final Review: CIST 1220 SQL - Gwinnett Technical College. WHERE You can join tables by using a condition in the ____ clause. period (.) To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____. IN To retrieve data from multiple tables in a query you can use the ____ operator with a subquery. EXISTS You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed. correlated When a subquery involves a table listed in the outer query, the subquery is called a(n) ____ subquery. SELECT A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group Spacebar You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias. union The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables intersect The ____ of two tables is a table containing all rows that are in both tables. difference The ____ of two tables is the set of all rows that are in the first table but that are not in the second table. union Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths duplicate For an SQL implementation to truly support the union operation, it must remove ____ rows automatically. INTERSECT Oracle and SQL Server support the ____ operator but Microsoft Access does not ALL If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery ANY