Top 10 interview questions for dot net developer

In this blog I am not going to write a big epic on how to crack interviews but just briefing on it in “write less, guess more, and understand most” manner...

Basic SQL: 

1.What kind of function can be written in SQL? How a function is differ from Stored procedure?

2.What is trigger? Can you write the syntax for AFTER trigger?

3. Have you ever used Magic tables? What are they? And where/how can be used?

4. What is the difference between Temp table and Table variable?(a) Difference between local temp table and Gloabal temp table.

5. What is Identity column type? Can we reset the value of column of this type? What will be the next value, (a) if we delete all the records from this table and insert a fresh new record? (b) if we delete the table (c) if we truncate the table

6. What is the difference between Joins and Subqueries? Which one is better? Can you write the syntax for CROSS JOIN. (a) difference between Left join and Right join.

7. How many types of Indexes can be done inSQL? What is the difference between them? Which one is the default type? Which one is better to use? (a) Can we have a table without any type of Indexes? (b) can you have a primary key on a table with non-clustered index?

8. What is the difference in Primary key constraint and Unique key constraint? Is”Default” a constraint in SQL? (a) difference between varchar datatype and char datatype.

9. When and How to use cursor with syntax.

10. How to do SQL query optimization?

T-SQL: 

There may be few questions related to syntaxes and queries like “write a query to get the 5th highest paying salary” etc. So be prepare about this.

P.S.: 

Wherever differences is asked, try to give atleast 3 differences. For example if you say” table variable doesn't maitain the transaction scope while temp table do” would be not enough to satisfy interviewer.

Share on Google Plus

About Unknown

A social executive and programmer by passion. He contributes in technical forums along with Career Advice on many websites. Read More ...

---

Join him on : Google+ | Facebook | Twitter