Exam 70-433 : SQL Server 2008 Part – 2

Question: Assuming Emp,EmpCompress 2 tables with same schema: EmpId(Int), Name(varchar(50)), DeptId(Int). If a company wants to move all rows for Employees working in IT Department, from the Employees table to the EmployeesArchive table. Which of the following queries can be used?

  1. None of the above.

Correct Answer: 1


Question: Which of the following is true?

  1. NULL values are ignored for all the aggregate functions.
  2. NULL values are included for all the aggregate functions.
  3. When an aggregate function is included in the SELECT clause, all other expressions in the SELECT clause must either be aggregate functions or included in a GROUP BY clause.
  4. Both 1 and 3.
  5. Both 2 and 3.

Correct Answer: 4


Question: Which of the following queries returns the users whose username starts with any of the character between v to z?

  1. None of the above.

Correct Answer: 1


Question: BEGIN TRANSACTION INSERT INTO DemoTable VALUES(5,’XYZ’,’DEMO’); BEGIN TRANSACTION UPDATE DemoTable SET Col3 = ‘Test’ WHERE TestID = 5; COMMIT TRANSACTION; ROLLBACK; What is the result of the above code execution?

  1. The data is rolled back to the transaction starting on line1.
  2. The inserted row does not exist in the table.
  3. All of the above.
  4. None of the above.

Correct Answer: 3


Question: Which of the following is a best practice to reduce deadlock situations?

  1. Access resources in the same order whenever possible within transactions
  2. Collect and verify input data from users before opening a transaction
  3. Keep transactions log.
  4. All 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.