An inequality condition is also known as a natural join and an equality condition is also called a theta
join. - False
When using a(n) _____ join, only rows that meet the given criteria are returned. - inner
The statement SELECT * FROM T1, T2 produces a(n) _____ join. - cross
A(n) _____ join wi...
An inequality condition is also known as a natural join and an equality condition is also called a theta
join. - ✔✔False
When using a(n) _____ join, only rows that meet the given criteria are returned. - ✔✔inner
The statement SELECT * FROM T1, T2 produces a(n) _____ join. - ✔✔cross
A(n) _____ join will select only the rows with matching values in the common attribute(s). -
✔✔natural
If a designer wishes to create an inner join, but the two tables do not have a commonly named
attribute, he can use a(n) _____ clause. - ✔✔JOIN ON
The ANSI standard defines _____ type(s) of outer join(s). - ✔✔three
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching
values in the common columns) but also the rows with unmatched values. - ✔✔outer
The syntax for a left outer join is _____. - ✔✔SELECT column-list
FROM table1 LEFT OUTER JOIN table2
ON join-condition
A _____ join returns rows with matching values and includes all rows from both tables (T1 and T2)
with unmatched values.
This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this
task are A to H and alt+1 to alt+9. - ✔✔full outer
All join conditions are connected through a(n) _____ logical operator. - ✔✔AND
, An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 _____________
(common-column). - ✔✔USING
The _____________ determines the common attribute or attributes by looking for identically named
attributes and compatible data types. - ✔✔natural join
How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B
contains 18? - ✔✔144
A _____ is a query inside a query. - ✔✔subquery
In subquery terminology, the first query in the SQL statement is known as the _____ query. -
✔✔outer
Which of the following is a feature of a correlated subquery? - ✔✔The outer subquery initiates the
process of execution in a subquery.
In a subquery, the _____ query is executed first. - ✔✔inner
When using a subquery, the output of a(n) ________ query is used as the input for the outer query. -
✔✔inner
The __________ clause is used to restrict the output of a GROUP BY query by applying a conditional
criteria to the grouped rows. - ✔✔HAVING
The IN subquery uses a(n) _____________ operator. - ✔✔equality
The use of the ________ operator allows you to compare a single value with a list of values returned
by the first subquery (sqA) using a comparison operator other than EQUALS. - ✔✔ALL
A(n) ____________ subquery is a subquery that executes once for each row in the outer query. -
✔✔correlated
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Layer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
