Interviews Questions and Answers (8126) - Page 159

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

8126 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Post

Title Posted by, on, category, views

The following statement gives output with NO errors in which version ? SELECT 'Current Time is & ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3444

Which of the following is NOT a SQL Server 2012 new feature?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3617

Which of the following keyword is used to return output value from stored procedure in SQL Server?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3450

What is the equivalent statement for IF..ELSE in SQL Server queries?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 5428

Which of the following approach is used for Pagination in SQL server 2012?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3167

Assuming UserProfile is a table containing a column Proession which accepts NULL value. What is the ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3311

Which of the following options can be used for viewing lock status within your computer running SQL ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 2822

Which of the following object is used to retrieve information about all active transactions on an in ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3217

Which of the following is true about the SERIALIZABLE isolation level
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 2617

Which of the following is true?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3002

Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3318

Find all Employees who is having first letter of their last name as D-G ( i.e. D, E, F or G) ?
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 2996

INSERT INTO Emp(Name,HireDate,Designation) OUTPUT getdate(), inserted.EmpId INTO Audit VALUES ( ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 3190

Assuming Emp,EmpHistory 2 tables with same schema: EmpId(Int), Name(varchar(50)), DeptId(Int). If a ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 2630

Assuming UserProfile is a table with PKUserId int,Profession Varchar(50)columns. What is the result ...
Posted by Bandi on 9/30/2013 under Sql Server category | Views: 2837

By default, what type of index is created for a unique constraint?
Posted by Bandi on 9/27/2013 under Sql Server category | Views: 3225

Which of the following is a best practice to reduce deadlock situations?
Posted by Bandi on 9/27/2013 under Sql Server category | Views: 3661

BEGIN TRANSACTION INSERT INTO DemoTable VALUES(5,'XYZ','DEMO'); BEGIN TRANSACT ...
Posted by Bandi on 9/27/2013 under Sql Server category | Views: 3782

Shared locks are not compatible with exclusive locks. True/False?
Posted by Bandi on 9/27/2013 under Sql Server category | Views: 3231

What is the result of the below query: SELECT PATINDEX('%NET%', 'DOTNETFUNDA') AS &# ...
Posted by Bandi on 9/26/2013 under Sql Server category | Views: 3506

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