> > >

Oracle SQL 9i MCQs

You want to display the titles of books that meet the following criteria:

1. Purchased before Feb 21, 2002
2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book.

Which of the following statements should you use?

SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-FEB-2002' ORDER BY purchase_date;

SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date < '21-FEB-2002' ORDER BY purchase date ASC;

SELECT book_title FROM books WHERE price < 500 OR > 900 AND purchase_date DESC;

SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-FEB-2002' ORDER BY purchase_date DESC;

Answer

Correct Answer: SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-FEB-2002' ORDER BY purchase_date DESC;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it