Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 101:

  You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?

  A. FIND

  B. BETWEEN

  C. INCLUDES

  D. LIKE

  Correct Answer: D

• Question 102:

  You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.

  Which data type should you use?

  A. VARCHAR (3, 30)

  B. CHAR (3, 30)

  C. VARCHAR (30)

  D. CHAR (30)

  Correct Answer: C

• Question 103:

  One reason to create a stored procedure is to:

  A. Improve performance.

  B. Minimize storage space.

  C. Bypass case sensitivity requirements.

  D. Give the user control of the query logic.

  Correct Answer: A

• Question 104:

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

  A. EXECUTE

  B. ALLOW

  C. CALL

  D. RUN

  Correct Answer: A

• Question 105:

  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:

  A. Empty

  B. Deleted

  C. Unchanged

  D. Archived

  Correct Answer: A

• Question 106:

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

  A. User to a database.

  B. Row of data to a table.

  C. Table to a database.

  D. Column to a table definition.

  Correct Answer: B

• Question 107:

  You have two tables. Each table has three rows.

  How many rows will be included in the Cartesian product of these two tables?

  A. 0

  B. 3

  C. 6

  D. 9

  Correct Answer: D

• Question 108:

  You are writing an SQL statement to retrieve rows from a table.

  Which data manipulation language (DML) command should you use?

  A. READ

  B. SELECT

  C. OUTPUT

  D. GET

  Correct Answer: B

• Question 109:

  Which constraint ensures a unique value in the ID column for each customer?

  A. DISTINCT

  B. FOREIGN KEY

  C. SEQUENTIAL

  D. PRIMARY KEY

  Correct Answer: D

• Question 110:

  The component that holds information for a single entry in a table is called a:

  A. Data type

  B. Row

  C. Column D. View

  Correct Answer: B