BUS-S307 Final Exam Questions and Complete Solutions

join - relational operation that causes two or more tables with a common domain to be combined into a single table or view - can use "JOIN" or "INNER JOIN"..."ON" - common columns appear redundantly in the result table - can use "=", "","" ,"" equi-join - join in which the joining condition is based on equality between values in the common columns natural join - equi-join in which one of the duplicate columns is eliminated in the result table outer join join in which rows that do not have matching values in common columns are nonetheless included in the result table union combines the result of two or more SELECT statements inner join - only return rows from each table that have matching rows in the other What do you have to do in joins to ensure referential integrity? each pair of tables requires an equality-check condition in the WHERE clause, matching primary keys against foreign keys self-join - add table twice using aliases - SELECT E.EmployeeID, E.EmployeeName, M.EmployeeName AS Manager FROM Employee_T E, Employee_T M WHERE E.EmployeeSupervisor = M.EmployeeID subquery placing an inner query (SELECT statement) inside an outer query non correlated subquery - do not depend on data from outer query - execute once for entire outer query correlated subquery - execute once for each row returned by the outer query - make use of data from outer query - can use EXISTS operator IN operator - allows you to specify multiple values in a WHERE clause - SELECT * FROM Customers WHERE