With a merge statement a series of actions can occur

This preview shows page 2 - 4 out of 6 pages.

With a MERGE statement, a series of ____ actions can occur with a single SQL statement. A complete query nested inside another
query is called a(n) ____.
line 4 Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error?1 SELECT title, pubid, cost, retail2 FROM books3 WHERE (pubid, cost)4 (SELECT pubid, cost)5 FROM books6 WHERE pubid = 3); none of the above The EXISTS operator must be listed ____. The ____ operator is used to determine
whether a condition is present in a subquery outer The results of a subquery are passed back as input to the ____ query. Which of the following terms refers to a
type of subquery that is processed, or executed, once for each row in the outer query? In Oracle11g, a(n) ____ allows a series of
DML actions to occur
12/21/2014 CSIT156chap12 flashcards | Quizlet ­flash­cards/ 3/6 single­row The following SQL statement contains what type of subqueries?SELECT isbn, title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')AND retail­ cost >(SELECT AVG(retail­cost) FROM books); inline view A temporary table that is created when a multiple­column subquery is used in the FROM clause of an outer query is called a(n) ____. multiple­column The following SQL statement contains which type of subquery?SELECT title, retail, category, cataverage FROM books NATURAL JOIN(SELECT category, AVG(retail) cataverage FROM books GROUP BY category); >ALL

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture