Shared Flashcard Set

Details

SQL 2012
Chapter 4 SQL 2012
30
Computer Science
Undergraduate 2
02/07/2013

Additional Computer Science Flashcards

 


 

Cards

Term
Outer Join
Definition
includes all rows matching join condition, plus unmatched rows in one or both tables
Term
Left Outer Join
Definition
includes all rows from first, or left, table
Term
Right Outer Join
Definition
includes all rows from second, or right, table
Term
Cross Join
Definition
joins each row of first table with each row of second table
Term
Cartesian Product
Definition
result of cross join
Term
Join
Definition
allows the combining of two or more tables into a single result set
Term
Inner Join
Definition
only rows that match join conditino is included in result set
Term
Ad Hoc Relationship
Definition
joins not defined in database; not primary/foreign key
Term
Qualified Column Name
Definition
prefix of table name on column name reference
Term
Explicit Syntax
Definition
INNER join syntax
Term
Implicit Syntax
Definition
Comma Inner joing syntax
Term
Correlation Name
Definition
temporary names assigned in FROM clause
Term
Table Alias
Definition
aka Correlation name
Term
Fully Qualified Object Name
Definition
four parts - Server, DB, Schema, and object
Term
Partially Qualified Object Name
Definition
less than four parts
Term
Linked Server
Definition
virtual server specifiying info to connect to local/remote server
Term
Self-Join
Definition
join that joins a table to itself
Term
Union
Definition
Combines results of 2 or more select statements into one result
Term
Set Operators
Definition
UNION, EXCEPT, INTERSECT
Term
Interim Table
Definition
Contains interim results of joins of more than 2 tables
Term
Theta Syntax
Definition
Same as Implicit Syntax
Term
Correlation Name Example
Definition
[image]
Term
Cross Join Explicit Example
Definition
[image]
Term
Explicit Inner Join Example
Definition
[image]
Term
Fully Qualified Object Example
Definition
[image]
Term
Implicit Syntax Inner Join Example
Definition
[image]
Term
Inner Join Correlation Name Example
Definition
[image]
Term
Left Outer Join Example
Definition
[image]
Term
Partially Qualified Table Names Example
Definition
[image]
Term
Self Join Example
Definition
[image]
Supporting users have an ad free experience!