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

Question

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

Quizplus · Accepted Answer

All the options provided (A, B, and C) are valid ways to retrieve all books published in 2001 from the BOOKS table, assuming the 'pubdate' column is stored in a format that is compatible with these queries. Option A uses the BETWEEN operator to select dates within the year 2001. Option B uses the LIKE operator to match dates ending with '01', which assumes the year is at the end of the date format and could potentially include incorrect matches if not careful with the data format. Option C explicitly checks for dates greater than or equal to the start of 2001 and less than or equal to the end of 2001.

Contents of BOOKS Table