Which of the Following Queries Will List All the Rows

question 20

Multiple Choice

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20,2016?

• A)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016';
• B)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$;
• C)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE <= '20-JAN-2010';
• D)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010};

---

Definitions:

Line Organization

A direct and clear structure where authority flows vertically from the top management down to the lower levels.

Chain of Command

The official hierarchy within an organization that dictates the authority, responsibility, and communication flow among its members.

Line Departments

Parts of an organization directly involved in its primary revenue-generating activities, typically involved in the production, sale, or provision of services.

Staff Departments

Staff departments provide specialized administrative support and services to the organization and its management, without being directly involved in production activities.