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:

IQ Test

A standardized assessment designed to measure human intelligence and cognitive abilities.

Biological Mother

A woman who has contributed half of a child's genetic makeup and carried the child in her womb until birth.

Schizophrenia

A long-term mental disorder involving a breakdown in the relation between thought, emotion, and behavior, leading to faulty perception, inappropriate actions and feelings, and a withdrawal from reality.

Genetic Component

The aspect of any trait or characteristic that is determined by genes or heredity.