Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 61:

  Which two keys establish a relationship between two tables? (Choose two.)

  A. candidate

  B. foreign

  C. superkey

  D. local

  E. primary

  Correct Answer: BE

• Question 62:

  One difference between a function and a stored procedure is that a function:

  A. Must be called from a trigger.

  B. Must return a value.

  C. Cannot contain a transaction.

  D. Cannot accept parameters.

  Correct Answer: B

• Question 63:

  Which keyword must be included in a create view statement?

  A. WHERE

  B. ORDER BY

  C. UPDATE

  D. SELECT

  Correct Answer: D

• Question 64:

  You have a table named Customer. You need to add a new column named District. Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 65:

  You need to remove a view named EmployeeView from your database. Which statement should you use?

  A. DELETE VIEW EmployeeView

  B. DELETE EmployeeView

  C. DROP EmployeeView

  D. DROP VIEW EmployeeView

  Correct Answer: D

• Question 66:

  A named group of SQL statements that can be executed in a database is called a:

  A. Subroutine

  B. Formula

  C. Stored procedure

  D. Method

  Correct Answer: C

• Question 67:

  A view can be used to:

  A. Save an extra copy of data stored in a separate table.

  B. Limit access to specific rows or columns of data in a table.

  C. Ensure referential integrity.

  D. Save historical data before deleting it from the base table.

  Correct Answer: B

• Question 68:

  On which database structure does an update statement operate?

  A. Table

  B. User

  C. Trigger

  D. Role

  Correct Answer: A

• Question 69:

  You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 70:

  You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

  A. Inherited delete

  B. Cascade delete

  C. Functional delete

  D. Waterfall delete

  E. Domino delete

  Correct Answer: B