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

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.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

Which of the following is NOT used for getting auto-incremented value of a IDENTITY Column in SQL Server?

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

Which of the following is true about Implicit Transactions?

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

Which of the following is correct about DELETE and TRUNCATE statements?

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

Which of the following are T-SQL ranking functions that can be used for ranking data?

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

Which of the following is true?

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

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

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

What is the result of the below query: SELECT SUBSTRING('DOTNETFUNDA', 4, 3) AS 'Substring'

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

What is the result of the below query: SELECT PATINDEX('%NET%', 'DOTNETFUNDA') AS 'Index'

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

Shared locks are not compatible with exclusive locks. True/False?

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

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?

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

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

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

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

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

Assuming UserProfile is a table with PKUserId int,Profession Varchar(50)columns. What is the result of the below query: SELECT PKUserId,Profession FROM UserProfile WHERE Profession = 'Engineer' AND (PKUserId > 12 OR PKUserId = 1) ?

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

Assuming Emp,EmpHistory 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, and who resigned from company to a new table EMPHistory then which of the following is correct statement?

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

INSERT INTO Emp(Name,HireDate,Designation) OUTPUT getdate(), inserted.EmpId INTO Audit VALUES ('Robot','1/1/2011','Executive'); What is the functionality of above INSERT statement?

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

Find all Employees who is having first letter of their last name as D-G ( i.e. D, E, F or G) ?

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

Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS ON SELECT Profession FROM UserProfile WHERE (Profession <> NULL)

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

Which of the following is true?

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

Which of the following is true about the SERIALIZABLE isolation level

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

Which of the following object is used to retrieve information about all active transactions on an instance?

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

More SQL SERVER Exclusive Interview Questions & Answers here

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

Bookmark It

Interview Questions and Answers Categories

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

MSBI (SSIS, SSRS, SSAS)

Web Services, Remoting