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:

Fixed Assets

Durable physical assets employed in the running of a company, which are not anticipated to be expended or turned into cash within one fiscal year.

Disposal Of A Segment

This refers to the selling, discontinuing, or otherwise getting rid of a portion of a company's operations or divisions.

Earnings Per Share

A financial metric that divides a company's net earnings available to common shareholders by the average outstanding shares, indicating the profitability per share.

Leverage

The use of borrowed capital or debt to fund an investment, aiming to expand asset base and generate returns on risk capital.