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

Verified
Correct Answer:
Verified
Q18: Entity integrity is enforced automatically when the
Q19: The SQL aggregate function that gives the
Q20: Which of the following queries will list
Q22: An example of a command a user
Q24: A(n)is a query that is embedded inside
Q25: The command would be used to delete
Q26: The command is used to restore the
Q27: Mathematical operators cannot be used to place
Q28: When joining three or more tables,you need
Q53: The special operator used to check whether