Based on the Code Shown, Which Query Lists the Descriptions

question 18

Multiple Choice

Based on the code shown, which query lists the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

• A) SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ;
• B) SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ;
• C) SELECT Description FROM Item WHERE Storehouse='3' ;
• D) SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;

---

Definitions:

Accomplishment

A sense of achievement or completion that comes from having successfully completed a task or objective.

Intrinsic Rewards

In expectancy theory, the internal factors related to the value of work, including the amount of creativity allowed, the degree of responsibility, and the satisfaction of helping others.

Satisfaction

A state of fulfillment or contentment resulting from achieving what one desires or from the successful resolution of needs or challenges.

ERG Theory

A theory in psychology proposed by Clayton Alderfer that categorizes human needs into three groups: existence, relatedness, and growth.