What is the purpose of the following query?SELECT isbn, title FROM books WHERE (pubid, category) IN (SELECT pubid, category FROM books WHERE title LIKE '%ORACLE%'); (refer to the tables in the JustLee Books database.)a. It determines which publisher published a book belonging to the Oracle category andthen lists all other books published by that same publisher.b. It lists all publishers and categories containing the value ORACLE.c. It lists the ISBN and title of all books belonging to the same category and having the same publisher as any book with the phrase ORACLE in its title.d. None of the above. The query contains a multiple-row operator, and because the inner query returns only one value, the SELECT statement will fail and return an error message.
What is the purpose of the following query?
SELECT isbn, title FROM books WHERE (pubid, category) IN (SELECT pubid, category FROM books WHERE title LIKE '%ORACLE%'); (refer to the tables in the JustLee Books
a. It determines which publisher published a book belonging to the Oracle category andthen lists all other books published by that same publisher.
b. It lists all publishers and categories containing the value ORACLE.
c. It lists the ISBN and title of all books belonging to the same category and having the same publisher as any book with the phrase ORACLE in its title.
d. None of the above. The query contains a multiple-row operator, and because the inner query returns only one value, the SELECT statement will fail and return an error message.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps