The Query Used to List the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE

question 102

Multiple Choice

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .

• A) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
• B) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
• C) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
• D) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;

---

Definitions:

Rights to the Sky

Legal rights related to the use and control of the airspace above a piece of land, often impacting construction and property law.

Trespass

An unauthorized intrusion or infringement on another person's property or rights.

Periodic Tenancy

Automatically renewing tenancy with no specific termination date.

Term Lease

A lease agreement that is set for a specified duration of time, after which it may be renewed or terminated.