The Following Code Is an Example of A: SELECT CustomerName

question 72

Multiple Choice

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.

---

Definitions:

Innovation

The process of creating new methods, products, or ideas that bring about significant improvements or changes.

Diffusion

The process by which a new idea, product, or practice spreads through a population or society.

Creative Destruction

The continuous process of annihilating old and outdated business models or products to create new ones that benefit the economy.

Patent

An exclusive right given to inventors to produce and sell a new product or machine for 20 years from the time of patent application.