Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 51:

  You have a table that contains product IDs and product names.

  You need to write an UPDATE statement to change the name of a specific product to glass.

  What should you include in the update statement?

  A. SET ProduetName = 'glass'

  B. LET ProduetName = 'glass'

  C. EXEC ProduetName = 'glass'

  D. ASSIGN ProduetName = 'glass'

  Correct Answer: A

• Question 52:

  Your database contains a table named Customer.

  You need to delete the record from the Customer table that has a CusromerID of 12345.

  Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 53:

  First normal form requires that a database excludes:

  A. Foreign keys

  B. Composite keys

  C. Duplicate rows

  D. Repeating groups

  Correct Answer: D

• Question 54:

  You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the database?

  A. The table will be corrupted.

  B. Forty (40) rows will be deleted from the table.

  C. The transaction will restart.

  D. No rows will be deleted from the table.

  Correct Answer: D

• Question 55:

  You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

  A. request a log of permission use.

  B. delegate permissions to other users.

  C. create new database users.

  D. view other users' permissions.

  Correct Answer: C

• Question 56:

  Which type of index changes the order in which the data is stored in a table?

  A. non-sequential

  B. sequential

  C. non-clustered

  D. clustered

  Correct Answer: A

• Question 57:

  Which statement should you use to remove a foreign key?

  A. ALTER TABLE

  B. DELETE TABLE

  C. DELETE FOREIGN KEY

  D. ALTER FOREIGN KEY

  Correct Answer: A

• Question 58:

  Denormalization is performed in order to:

  A. Reduce redundancy.

  B. Eliminate repeating groups.

  C. Create smaller tables.

  D. Improve query performance.

  Correct Answer: D

• Question 59:

  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?

  A. A cursor

  B. A subquery

  C. A trigger

  D. An index

  Correct Answer: D

• Question 60:

  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?

  A. a foreign key constraint violation

  B. a syntax error

  C. a new row in the Product table

  D. a primary key constraint violation

  E. a new row in the Category table

  Correct Answer: D