98-364

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

Question 41

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student - What is the result?

  1. All rows in the table will be deleted.
  2. All rows containing a NULL value in the FirstName column will be deleted.
  3. You will receive an error message.
  4. All rows and the table definition will be deleted.

Question 42

You need to establish a set of permissions that you can routinely assign to new users. What should you create?

  1. Resource
  2. Group
  3. List
  4. Role

Question 43

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

  1. Recover
  2. Restore
  3. Commit
  4. Attach

Question 44

You need to disable User1's access to view the data in the Customer table. Which statement should you use?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Question 45

Denormalization is performed in order to:

  1. Reduce redundancy.
  2. Eliminate repeating groups.
  3. Create smaller tables.
  4. Improve query performance.