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:

Heuristics

Heuristics are mental shortcuts or simple strategies used to make quick and efficient decisions or solve problems, often employed when facing complex issues or incomplete information.

Availability Heuristic

A strategy for judging how frequently something happens—or how common it is—based on how easily examples of it come to mind.

Heuristics

Mental shortcuts or rules of thumb that simplify decision-making processes, often utilized when facing complex problems or incomplete information.

Faulty Distributor

A defective component of an ignition system in an internal combustion engine that can lead to performance issues.