1.5 What does the following query do? Select isbn, title from BOOKS where (pubid, category) IN (select pubid, category from BOOKS where title like '\%ORACLE\%') a. It determines which publisher published a book belonging to the Oracle category and then lists all other books published by that same publisher. b. It lists all publishers and categories containing the value of 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. 1.6 Refer to the table given below to answer the following questions. Which of the following SQL statements will display the profit generated by each book stored in the BOOKS tables? A. Select title, retail, cost From books B. Select title, retail-cost From books C. Select pubid, cost, retail from books D. All of the above 1.7 Which type of a join is used in the following statement? select title, order\#, quantity from BOOKS full join ORDERITEMS on BOOKS.ISBN = ORDERITEMS.ISBN a. equality b. self-join c. non-equality d. outer join 4 1.8 Which of the following displays a list of all system privileges available in Oracle? a. SESSION_PRIVS b. SYS-PRIVILEGE_MAP c. V\$SYSTEM_PRIVILEGES d. SYSTEM_PRIVILEGE_MAP