Tag: Interview questions

Delete duplicate rows from SQL table

Delete duplicate rows from SQL table. How to delete duplicate rows without a primary key? Select only unique rows using CTE.  For the demonstration purpose, I have created a dummy database […]

Exception handling interview questions and answers

Can we use multiple finally blocks inside the method? Yes, you can write the multiple finally block inside the method. For every try block, you can have finally. try { […]

SQL interview questions part 1

What is SQL function? SQL functions are methods which accept parameters and perform the action, such as a complex calculation and return the result of that action as a value.the […]

ASP.NET interview questions and answers

Which is the parent class of the Web server control? The System.Web.Ul.Control class is the parent class for all Web server controls. In which event are the controls fully loaded? […]

Swap two variable without using the third variable

using System; namespace Swap { class Program { private static void Main(string[] args) { int a = 1000; int b = 999; Console.WriteLine(“Before Swap”); Console.WriteLine(“Value of A :{0} “, a); […]

Dot Net Interview questions for Experience

What is connection pooling? When should we use connection pooling? What is strong Dll? What is bucketing in the database? Do we need a certificate in client machine for HTTPS? […]