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

question 98

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 P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
• FROM PRODUCT, VENDOR
• WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
• ORDER BY P_PRICE;
• B) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
• FROM PRODUCT, VENDOR
• WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
• ORDER BY P_PRICE;
• C) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
• FROM PRODUCT, VENDOR
• WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
• ORDER BY P_PRICE;
• D) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
• FROM PRODUCT, VENDOR
• WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
• ORDER BY P_PRICE;

---

Definitions:

Individual Job

A role or position within a company or organization focused on specific, individual responsibilities rather than team projects or tasks.

Scripted Activities

Tasks or procedures that are followed according to a predetermined or written plan, often with little room for deviation or spontaneous action.

Team Tasks

Assignments or projects designated to be completed by a group working together.

Performance Potential

The capacity or ability of an individual or organization to achieve and maintain high levels of effectiveness and efficiency in their tasks or goals.