Multiple Choice
The following code would include:
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T RIGHT 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
Q50: The _ operator is used to combine
Q51: A materialized view is/are:<br>A) a virtual table
Q52: The following SQL statement is an example
Q53: The UNION clause is used to combine
Q54: A subquery in which processing the inner
Q56: MULTISET is similar to the table datatype.
Q57: Establishing IF-THEN-ELSE logical processing within an SQL
Q58: In order to find out what customers
Q59: Combining a table with itself results in
Q60: Discuss some of the SQL:2011 and SQL:2016