98-364

98-364 practice questions, page 7 of 10, with answer review and explanations.

Question 31

You need to populate a table named EmployeeCopy with data from an existing table named Employee. Which statement should you use?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Question 32

You execute the following statement: This statement is an example of a/an:

  1. Subquery
  2. Union
  3. Outer join
  4. Cartesian product

Question 33

Which keyword would you use in a select statement to return rows that meet a specific condition?

  1. WHERE
  2. UNION
  3. ORDER BY
  4. FROM

Question 34

You have a table named Employee that includes the following columns: EmployeeID - Smp1oyeeName - Which statement should you use to return the number of rows in the table?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Question 35

The Product table contains the following data. You execute the following statement: SELECT COUNT(*) FROM Product WHERE Quantity > 18 What is the value returned by this statement?

  1. 1
  2. 2
  3. 3
  4. 4