Which of the Following Queries Will List All the Rows

question 10

Multiple Choice

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

• A) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010';
• 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:

Diastole

The period during a heartbeat when the heart muscle is in a state of relaxation, permitting the chambers to be replenished with blood.

Carotid Artery Pulse

A pulse that can be felt on either side of the neck over the carotid arteries, used to assess heart rate and rhythm.

Apical Pulse

The heartbeat as heard with a stethoscope placed on the chest directly over the apex of the heart, used for accurate measurement of heart rate.

Tachycardia

A condition in which the heart beats faster than normal while at rest, typically defined as having a heart rate of over 100 beats per minute.