Sql Server Interview Questions and Answers (1758) - Page 41

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

You want to find out the specific line in a block of T-SQL code that caused an error. You configure an appropriate TRY . . . CATCH construct. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

An error occurs when you execute a T-SQL code. You configure the appropriate TRY . . . CATCH construct. You want to determine the exact message text returned by this error. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

An error occurs when you execute a block of T-SQL code, causing a transaction to roll back. You want to determine the error number associated with this error. You configure the appropriate TRY . . . CATCH construct. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

You are working with some T-SQL code that causes an error. You want to determine the trigger or stored procedure that caused a specific error. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

An error occurs when you execute a block of Transact-SQL code, causing a transaction to roll back. You want to determine the severity of this error. You configure the appropriate TRY . . . CATCH construct, using the code so that you can further diagnose the error. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

You have noticed that a particular block of Transact-SQL code triggers Error 1105. You want to determine the error state number of that particular error. You configure the appropriate TRY . . . CATCH construct. Which of the following system functions can you use to determine this information?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several complex queries. You have determined that you can improve performance by concatenating UNION sets. Which of the following query hints should you use to implement this optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several complex queries. You have determined that you can improve performance by hashing UNION sets. Which of the following query hints should you use to implement this optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several complex queries. You have determined that you can improve performance by always merging UNION sets. Which of the following query hints should you use to implement this optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several T-SQL statements. You have determined that a particular statement will perform more efficiently if rows in a table locked by another transaction are skipped rather than waiting for the locks to be released. Which of the following table hints will you use in your Transact-SQL statements when performing optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several Transact-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the row level rather than at the page or table level. Which of the following table hints will you use in your Transact-SQL statements when performing optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several T-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the table level rather than at the page or row level. Which of the following table hints will you use in your Transact-SQL statements when performing optimization?

NOTE: This is objective type question, Please click question title for correct answer.

You are optimizing several Transact-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the page level rather than at the table or row level. Which of the following table hints will you use in your Transact-SQL statements when performing optimization ?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following Transact-SQL statements do you use if you want to remove a cursor reference?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following Transact-SQL statements do you use if you want to release the current result set from a cursor?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following Transact-SQL statements do you use if you want to retrieve rows from a result set allocated to a cursor?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following Transact-SQL statements do you use to populate a Transact-SQL cursor with the results from the statement used to declare the cursor?

NOTE: This is objective type question, Please click question title for correct answer.

You run the following query against a table in the temp database: SELECT * FROM Sales WHERE orderid = 3802; You get the output shown in the exhibit. The discount on the product with unitid 1 is 12.5%. You want to update this table so that you increase the discount assigned to each item in this order by an additional 5%. Which of the following Transact-SQL statements can you use to accomplish this goal ?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following statements can you use to delete all orders from the Orders table where the productID is 343 and the shipping country is India ?

NOTE: This is objective type question, Please click question title for correct answer.

Your database has two tables related to product models, named ProductModel and NewProductModel. You want to view all products that are listed in both tables but do not want to view duplicate entries. Which of the following Transact-SQL statements can you use to accomplish this goal?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
...
88

More SQL SERVER Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting