Exam 70-433 : SQL Server 2008 Part – 5

Question: Which of the following are T-SQL ranking functions that can be used for ranking data ROW_NUMBER DENSE_RANK RANK NTILE All of the above. Correct Answer: 5 Question: Which of the following options can be used for viewing lock status within your computer running SQL Server? We can use SQL Profiler to capture lock and blocking information. We can use the System Monitor that is part of the performance console to capture statistics on lock wait times, locks per second, and so on. We can use the Activity Monitor in SSMS to see information on blocking processes. We can use … Click here to continue…..

Exam 70-433 : SQL Server 2008 Part – 4

Question: Which of the following are the metrics used to evaluate performance of a query? Query execution time Page reads Query cost All of the above Correct Answer: 4 Question: How many transactions at a time can obtain an update lock on a resource? 1 2 3 128 Correct Answer: 1 Question: What is the output of the below query:

0 1 2 -1 Correct Answer: 1 Question: By default, which type of index is created for a primary key? Clustered Index. Non Clustered Index. None of the above Both 1 and 2. Correct Answer: 1 Question: Assuming Emp … Click here to continue…..

Exam 70-433 : SQL Server 2008 Part – 3

Question: Which of the following commands is used to retrieve information about the information contained in the current transaction log ? DBCC LOGGING statement DBC LOG statement DBCC LOG statement None of the above. Correct Answer: 1 Question: Which of the following options can be used for viewing lock status within your computer running SQL Server? We can use SQL Profiler to capture lock and blocking information. We can use the System Monitor that is part of the performance console to capture statistics on lock wait times, locks per second, and so on. We can use the Activity Monitor in … Click here to continue…..

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?

None of the above. Correct Answer: 1 Question: Which of the following is true? NULL values are ignored for all the aggregate functions. NULL values are included for all the aggregate functions. When an aggregate function is included in the SELECT clause, all other expressions in the SELECT clause must either be aggregate functions or included … Click here to continue…..

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:

Displays Users with Profession as ‘engineer’ with PKUserId > 12 as well as the users with PKUserId of 1. Displays Users with Profession as ‘engineer’ with PKUserId > 12 only. Displays Users with Profession as ‘engineer’ with PKUserId of 1 only. None of the above. Correct Answer: 1 Question: The SELECT statement(Fetching data from table) must include which of the following clause: SELECT clause FROM clause Both 1 and 2. None of the above. Correct Answer: 3 Question: If the … Click here to continue…..