BUAN Final Exam UPDATED ACTUAL Exam Questions and CORRECT Answers
2 views 0 purchase
Course
BUAN
Institution
BUAN
BUAN Final Exam UPDATED ACTUAL
Exam Questions and CORRECT Answers
What SELECT statement clause cannot be used when embedded in a JOIN? - CORRECT
ANSWER- ORDER BY
What type of JOIN returns all rows from the second table and any matching rows from the
first table? - CORRECT ANSWER- RIGHT OUTE...
BUAN Final Exam UPDATED ACTUAL
Exam Questions and CORRECT Answers
What SELECT statement clause cannot be used when embedded in a JOIN? - CORRECT
ANSWER- ✔✔ORDER BY
What type of JOIN returns all rows from the second table and any matching rows from the
first table? - CORRECT ANSWER- ✔✔RIGHT OUTER JOIN
When deciding whether to use a RIGHT OUTER JOIN or a LEFT OUTER JOIN, which
factor matters the most? - CORRECT ANSWER- ✔✔The order in which the tables are listed
in the FROM clause
What type of JOIN returns all rows from the first table and any matching rows from the
second table? - CORRECT ANSWER- ✔✔LEFT OUTER JOIN
What character is used to embed a SELECT or a JOIN within another JOIN? - CORRECT
ANSWER- ✔✔Parentheses ()
Which process could you use to find Students who have not signed up for any Classes? -
CORRECT ANSWER- ✔✔Include "FROM Students LEFT JOIN Classes" in your query and
then test for NULL values in Classes columns in the WHERE clause.
To complete a LEFT OUTER JOIN, what keyword is optional? - CORRECT ANSWER-
✔✔OUTER
Which FROM clause is the equivalent of the following:
FROM Products LEFT JOIN Categories - CORRECT ANSWER- ✔✔FROM Categories
RIGHT JOIN Products
Which of the following is a request that can be answered using an OUTER JOIN? -
CORRECT ANSWER- ✔✔What products have never been ordered?
, Which is the only element of an INNER JOIN that is required? - CORRECT ANSWER-
✔✔JOIN
Where is the ORDER BY clause placed to sort the results of a UNION? - CORRECT
ANSWER- ✔✔At the end of the last SELECT statement
Which of the following is a requirement for the columns of the SELECT statements in a
UNION? - CORRECT ANSWER- ✔✔Both of these are requirements.
If the ALL keyword is included in the UNION, how many rows will be returned in the result
set? - CORRECT ANSWER- ✔✔Equal to the sum of the number of rows returned by each
SELECT statement.
A UNION combines two of these. - CORRECT ANSWER- ✔✔SELECT statement
The ORDER BY clause can reference columns by their name and what other alternative
method? - CORRECT ANSWER- ✔✔The relative column number starting with 1 as the first
column
What type of subquery is an embedded SELECT expression that returns one or more columns
and zero to many rows? - CORRECT ANSWER- ✔✔Table subquery
In what clause can subqueries be used? - CORRECT ANSWER- ✔✔SELECT
All of these clauses-Correct answer
WHERE
FROM
It is best practice (and usually required) to enclose subqueries within - CORRECT
ANSWER- ✔✔parentheses ( )
What type of subquery is an embedded SELECT expression that returns only one column and
no more than one row? - CORRECT ANSWER- ✔✔Scalar subquery
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
