Question: C. SELECT title FROM books UNION ALL SELECT gift FROM promotion; d. all of the above 13. If the CUSTOMERS table contains seven records and
C. SELECT title FROM books UNION ALL SELECT gift FROM promotion; d. all of the above 13. If the CUSTOMERS table contains seven records and the ORDERS table has eight records, how many records does the following query produce? SELECT FROM customers CROSS JOIN ordersi a. 0 b. 8 C.7 d. 15 e. 56 14. Which of the following SQL statements is not valid? a. SELECT b.isbn, p.name FROM books b NATURAL JOIN publisher p SELECT ?sbn, name b. FROM books b, publisher p WHERE b.pubid- p.pubid; C. SELECT isbn, name FROM books b JOIN publisher p ON b. pubid = p, pubid; d. SELECT isbn, name FROM books JOIN publisher USING (pubid) None-all the above are valid SQL statements. e. 15. Which of the following lists all books published by the publisher named Printing Is Us? a. SELECT title FROM books NATURAL JOIN publisher WHERE name'PRINTING IS US Chapter 9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
