Contents of BOOKS Table

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