WGU D191 - Advanced Data Management (SQL) || Questions & Answers (Rated A+)

WGU D191 - Advanced Data Management (SQL) || Questions & Answers (Rated A+) WGU D191 - Advanced Data Management (SQL) || Questions & Answers (Rated A+) to combine Rows from tables based on a match condition - ANSWER - primary purpose of a JOIN is: returns a single value (scalar) or Row set that is immediately available for use in the Outer query - ANSWER - A subquery: Returns a distinct list of Rows from both tables. like a Logical OR would do... - ANSWER - UNION operator Returns ALL Rows from Both tables (including duplicate Rows) - ANSWER - UNION ALL operator Returns a distinct (non repeating) list (of Rows) of 2 or more sets where the result appears in both tables/queries/sets. Like a logical AND would do... - ANSWER - INTERSECT operator returns ALL rows (including duplicates) from 2 or more tables only where records/Rows appear in both tables/queries/sets - ANSWER - INTERSECT ALL operator Returns a distinct (non repeating) list of Rows that Only appear in the Left Query/Table/Top result set. works like the Oracle MINUS set operator - ANSWER - EXCEPT operator Returns a list of Rows and duplicate Rows that Only appear in the Left Table/Query - ANSWER - EXCEPT ALL operator keyword that includes/shows duplicate rows - ANSWER - ALL Eliminates all duplicate records and fetches only unique records.... keyword used after set operator to specify duplicate Rows should Not be included - which is also the default behavior - ANSWER - DISTINCT establish temporary tables by using the WITH clause - ANSWER - Common Table Expressions Returns every possible combination of rows from the first table and the second table - ANSWER - cross join Returns only the records that have matching values in the joined field of two tables - ANSWER - inner join Returns all the records from the first table and only matching records from the second table - ANSWER - left outer join Returns all the records from the second table and only matching records from the first table - ANSWER - right outer join allows you to list any number of columns and scalar values - if first value in list is NULL it will try and fill it in with the next value