Exam 70-433 : SQL Server 2008 Part – 1

Question: Assuming UserProfile is a table with PKUserId int, Profession Varchar(50)columns. What is the result of the below query:

  1. Displays Users with Profession as ‘engineer’ with PKUserId > 12 as well as the users with PKUserId of 1.
  2. Displays Users with Profession as ‘engineer’ with PKUserId > 12 only.
  3. Displays Users with Profession as ‘engineer’ with PKUserId of 1 only.
  4. None of the above.

Correct Answer: 1


Question: The SELECT statement(Fetching data from table) must include which of the following clause:

  1. SELECT clause
  2. FROM clause
  3. Both 1 and 2.
  4. None of the above.

Correct Answer: 3


Question: If the following code was run on 31st Dec 2011, What is the result of the below query:

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

Correct Answer: 1


Question: By default, what type of index is created for a unique constraint?

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

Correct Answer: 2


Question: To rollback a portion of a transaction, We have to define ______.

  1. Savepoints
  2. Checkpoints
  3. Transactions
  4. None of the above.

Correct Answer: 1

Tagged . Bookmark the permalink.

2 Responses to Exam 70-433 : SQL Server 2008 Part – 1

  1. Mahesh Nagar says:

    Dear all

    Second question The SELECT statement must include which of the following clause

    Answer should be 1
    Because we can use direct select without from clause

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.