In4Velocity Asp.Net interview questions and answers

Check out Best Alternative to InfoPath


Here are some asp.net interview questions and answers. You can also check out: Asp.Net interview questions and answers in Lotex Business Solutions and HCL Asp.Net interview questions.
Here are the questions and answer:
1- There are 2 tables in which one column of one table is foreign key of another table. Count the no of records present in each id of first table.
2-     1   A  200
       2   B  300
       3   C  400
       4   D  500
  WAP to find like below output.
       1 A 200
       2 B 500
       3 C 900
       4 D 1400
3- How many of UDF are there in sql server ?
4- What do you mean by foreign key ?
5- What is a view ?
6- Can we use getdate() in UDF in sql server ?
7- Do you know design pattern ? Any one.
8- What is abstract class ? When you will use this ?
9- What is interface ? When you will use this ?
10- What is polymorphism ? Explain static and dynamic polymorphism ? [Answers]
11- What happens if a abstract class implements an interface ?
12- Is is possible to call a function from ADO.net ?
13- Disadvantage of stored procedure ?
14- What is parametrised view ?
15- How to return a parameter as output in ADO.net ?
16- How to pass parameter to a trigger in sql server ?
17- Can we use getdate() in a UDF in sql server ?
18- What is the purpose of using USING statement in c# ?
19- Difference between Response.Redirect and Server.Transfer ?

You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →