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:

Mary McLeod Bethune

An influential African American educator and civil rights leader who founded the National Council for Negro Women in 1935 and played a key role in founding the Bethune-Cookman University.

Southern Veto

The power exercised by Southern states or politicians to block legislation or actions they oppose, often related to civil rights or other social issues.

"Share Our Wealth" Movement

A program proposed by Senator Huey Long during the 1930s that aimed to reduce the nation's wealth inequality by distributing wealth more evenly amongst the American people.

Court-packing Plan

A controversial proposal by President Franklin D. Roosevelt in 1937 to increase the number of U.S. Supreme Court justices, aiming to obtain favorable rulings for his New Deal legislation.