Exam 70-433 : SQL Server 2008 Part – 4

Question: Which of the following are the metrics used to evaluate performance of a query?

  1. Query execution time
  2. Page reads
  3. Query cost
  4. All of the above

Correct Answer: 4

Question: How many transactions at a time can obtain an update lock on a resource?

  1. 1
  2. 2
  3. 3
  4. 128

Correct Answer: 1

Question: What is the output of the below query:

  1. 0
  2. 1
  3. 2
  4. -1

Correct Answer: 1

Question: By default, which type of index is created for a primary key?

  1. Clustered Index.
  2. Non Clustered Index.
  3. None of the above
  4. Both 1 and 2.

Correct Answer: 1

Question: Assuming Emp table with EmpId(int), Name(varchar(100)),HireDate(DateTime),Designation(varchar(20)) columns and Audit table with currentDate(DateTime), EmpId columns. What is the result of the following query:

  1. Adds a new row to the Emp table, and also adds a corresponding row with the current date and time and the EmpId for the new employee into the Audit table.
  2. Only inserts a new record into the Emp table.
  3. OUTPUT clause cannot be used in the INSERT command.
  4. None of the above.

Correct Answer: 1

Tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.