SQL Interview Questions

• What is a Key?
• Types of Key?
• What is Primary Key?
• What is Secondary Key?
• What is Unique Key?
• What is Foreign Key?
• What is Composite Key?
• What is Surrogate Key?
• What is Candidate Key?
• What is Alternate Key?
• Difference between Primary & Unique key?
• Difference between Primary & Alternate & Secondary key?
• Difference between Primary & Foreign Key?
• What is the need of Composite key?

Web services interview questions

• Explain WebMethod Attribute in Asp.Net Web Service.
• What is the Web service protocol stack?
• What is SOAP?
• What is WSDL?
• What is XML-RPC?
• What is UDDI?
• What is DISCO?
• What is DISCOMAP?
• What namespaces are imported by default in ASMX files?
• What are the steps to create a web service?
• What is the need to create a web service?
• Can you use User-Defined Types in Web Services?
• Can two different programming languages be mixed in a single ASMX file?
• How to perform authentication in webservices?
• How to handle exceptions in webservices?
• What is SOAP Exception in webservices?

.Net Interview Questions

• What is MVP model?
• What is MVC model?
• Difference between MVC & MVP model?
• Which model is tightly coupled?
• Which model is loosely coupled?
• What is ORM Model?
• What is full form of ORM?
• Why ORM?

.Net Interview Questions

• Difference between string & string builder?
• How we can create fix size string builder object?
• Difference between ref & out variable in c#?
• Difference between server.transfer & response.redirect?
• What kind of exception is generated by server.transfer & response.redirect?
• How we can handle exception generated by  server.transfer & response.redirect?
• Difference between IEnumerable & IEnumerator?

.Net Interview Questions

• What do mean by Architecture?
• What is .net  Architecture?
• What is connection pooling?
• How connection pooling works?
• What is max/min size of pool in .net?
• Can an application work with 0(zero) number of pool?
• Where we can define pool size?
• How we can create pools dynamically?
• What happens with application when max connection pool reach?
• Mention steps which are required while creating connection between .net & sql for data access?