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:
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.