Contents of BOOKS Table

question 124

Multiple Choice

Contents of BOOKS table
​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books published in 2001?​

• A) ​SELECT * FROM books WHERE pubdate BETWEEN '01-JAN-01' AND '31-DEC-01';
• B) ​SELECT * FROM books WHERE pubdate LIKE '%01';
• C) ​SELECT * FROM books WHERE pubdate >= '01-JAN-01' AND pubdate <= '31-DEC-01';
• D) ​all of the above

---

Definitions:

Carbon Dioxide

A gas without any color or smell, emanating from the burning of compounds containing carbon and the respiratory process, absorbed by vegetation in the process of converting light into energy.

Carbon Cycle

The series of processes by which carbon compounds are interconverted in the environment, chiefly involving the incorporation of carbon dioxide into living tissue by photosynthesis and its return to the atmosphere through respiration, the decay of dead organisms, and the burning of fossil fuels.

Fossil Fuels

Natural fuels such as coal, oil, and natural gas, derived from the remains of living organisms that were buried millions of years ago.

Hydrological Cycle

The continuous movement of water on, above, and below the surface of the Earth, also known as the water cycle.