97. UNION (select all that apply): combines columns from several tables, combines rows from several tables combines the results of several queries into a single result set requires the number and the order of the columns to be the same 98. A Subquery (select all that apply): is a nested query, can be used anywhere an expression is allowed is also called an Inner Query is also called an Inner Select The subquery in this statement: 99. SELECT * FROM Table1 WHERE Column1 = (SELECT MAX(Column2) FROM Table2); : O operates on a list O represents an existence test O returns a single value 100. SELECT * FROM Table1 WHERE Column1 IN (SELECT Column2 FROM Table2); : O operates on a list O represents an existence test O returns a single value 101. SELECT Column1 FROM Table1 WHERE EXISTS (SELECT * FROM Table2 WHERE [Condition]); : O operates on a list O represents an existence test O returns a single value 102. The subqueries in the following statements are correlated (select all that apply): SELECT * FROM employees e WHERE salary (SELECT AVG(salary) FROM employees WHERE department = e. department); SELECT * FROM employees WHERE salary (SELECT AVG(salary) FROM employees WHERE department = 'Quality Assurance'); SELECT Name FROM Product WHERE EXISTS (SELECT * FROM Model WHERE ModelID = Product. ModelID AND Name = 'Wheels') SELECT e. * FROM Employee e WHERE e. EmpID IN (SELECT m. EmpID FROM Manager m WHERE m. EmpID = e. EmpID); 103. A View (select all that apply): O is a virtual table O is a physical table stores data displays data