A Type of Join Implemented in SQL-1999 and by Extension

question 60

Multiple Choice

A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n) :

• A) outer join.
• B) inner join.
• C) union join.
• D) intersect join.

---

Definitions:

Appellate Courts

Courts that review and make rulings on appeals from lower court decisions, primarily focusing on issues of law rather than fact.

Questions of Law

Issues concerning the interpretation or application of laws, typically decided by a judge rather than a jury.

Questions of Fact

Issues regarding the actual events or circumstances of a case that are determined by a jury or judge in a trial.

State Court's Jurisdiction

The scope of authority a state court has to hear and decide cases within a particular geographic area and legal matters.