CIST 1220 LESSON 12 TEST.docx - Course Test Started...

This preview shows page 1 - 3 out of 11 pages.

Course CIST1220: Structured Query Language-SQL (Online) 42264 Test Lesson 12- Test Started 3/28/20 7:34 PM Submitted 3/28/20 8:33 PM Due Date 4/11/20 11:30 PM Status Completed Attempt Score 34 out of 40 points Time Elapsed 59 minutes out of 1 hour Results Displayed All Answers, Submitted Answers, Correct Answers, Incorrectly Answered Questions Question 1 0 out of 2 points Which of the following subqueries returns more than one row of results to the outer query? Selected Answer: d. single-row subquery Answers: a. multiple-row subquery b. multiple-column subquery c. correlated subquery d. single-row subquery
Question 2 2 out of 2 points Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values, rather than as individual values?
EXISTS and IN d. ALL and ANY Question 3 2 out of 2 points With a MERGE statement, a series of ____ actions can occur with a single SQL statement.
Question 4 2 out of 2 points Which of the following can be used in a WHERE clause?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture