98-364

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

Question 46

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?

  1. A cursor
  2. A subquery
  3. A trigger
  4. An index

Question 47

You have a table named Product that contains the following data. The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement: INSERT INTO Product - VALUES (3296, 'Table', 4444) What is the result?

  1. a foreign key constraint violation
  2. a syntax error
  3. a new row in the Product table
  4. a primary key constraint violation
  5. a new row in the Category table