The following code is an example of a:
SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

A) correlated subquery.
B) subquery.
C) join.
D) FULL OUTER JOIN.

Question

The following code is an example of a: 
SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

A) correlated subquery.
B) subquery.
C) join.
D) FULL OUTER JOIN.

Quizplus · Accepted Answer

The code is an example of a subquery, where a query is nested inside another query. The inner query retrieves the CustomerID from the Order_T table, which is then used by the outer query to select customer details from the Customer_T table.

The Following Code Is an Example of A