Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
A) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE

Question

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
A) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE <'1558-QW1';
B) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = [1558-QW1]
C) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = (1558-QW1)
D) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = {1558-QW1}

Quizplus · Accepted Answer

The query in option A uses the < (less than) operator to compare the value of P_CODE with the given string '1558-QW1'. This will return all rows where the P_CODE value is alphabetically less than '1558-QW1'. Option B uses the = (equal to) operator, which will only return rows where P_CODE is exactly equal to '[1558-QW1]'. Options C and D use incorrect syntax with parentheses and curly braces around the string value.

Which Query Will Output the Table Contents When the Value