The Query to Join the P_DESCRIPT and P_PRICE Fields from the PRODUCT

question 35

Multiple Choice

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE and V_CONTACT fields from the VENDOR table,where the values of V_CODE match and the output is ordered by the price is .

• A)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
• WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
• B)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
• WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
• C)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
• WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
• D)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT, VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
• WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;

---

Definitions:

Indefinite-Lived Asset

An asset that is not anticipated to be consumed or used up and does not have a definable useful life, such as certain trademarks or goodwill.

Amortization

A financial term referring to the gradual reduction of a debt over a period of time by periodic payments of principal and interest.

Acquired Subsidiary

A company that becomes a subsidiary through purchase or takeover by another company.

Consolidated Goodwill

An intangible asset that appears when a parent company acquires a subsidiary and is recorded after consolidation processes.