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:

Tessitura

The range within which most notes of a vocal part or piece of music fall, often used to determine the most comfortable range for a singer or instrument.

Customer Profiles

Detailed descriptions of a company’s ideal customers, based on their demographics, interests, and buying habits.

Relationship Marketing

A marketing strategy aimed at fostering long-term, engaging relationships with customers to build brand loyalty and repeat business.

Publix Supermarkets

A large American supermarket chain headquartered in Florida, known for its wide selection of groceries and superior customer service.