98-364

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

Question 16

One reason to create a stored procedure is to:

  1. Improve performance.
  2. Minimize storage space.
  3. Bypass case sensitivity requirements.
  4. Give the user control of the query logic.

Question 17

Which permission does a user need in order to run a stored procedure?

  1. EXECUTE
  2. ALLOW
  3. CALL
  4. RUN

Question 18

You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category. After you execute the statement, the result set of the view is:

  1. Empty
  2. Deleted
  3. Unchanged
  4. Archived

Question 19

In SQL, an insert statement is used to add a:

  1. User to a database.
  2. Row of data to a table.
  3. Table to a database.
  4. Column to a table definition.

Question 20

You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?

  1. 0
  2. 3
  3. 6
  4. 9