Multiple Choice
The following code would include:
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T LEFT OUTER JOIN Order_T ON
Customer_T.CustomerID = Order_T.CustomerID;
A) all rows of the Order_T Table regardless of matches with the Customer_T Table.
B) all rows of the Customer_T Table regardless of matches with the Order_T Table.
C) only rows that match both Customer_T and Order_T Tables.
D) only rows that don't match both Customer_T and Order_T Tables.
Correct Answer:

Verified
Correct Answer:
Verified
Q61: Triggers have three parts: the event, the
Q62: What would the following view contain for
Q63: When a user creates a virtual table
Q64: The joining condition of an equi-join is
Q65: The following queries produce the same results.<br>SELECT
Q67: A natural join is the same as
Q68: Discuss the differences between an equi-join, natural
Q69: IF-THEN-ELSE logical processing cannot be accomplished within
Q70: Constraints are a special case of triggers.
Q71: The following code would include: <br>SELECT Customer_T.CustomerID,