Posts

Showing posts from December, 2016

Difference between SOAP and REST

SOAP ( Simple Object Access Protocol ) SOAP can run on TCP/UDP/SMTP/HTTP. SOAP read and write request response messages in XML format. SOAP is more secure as it has its own security and well defined standards. SOAP uses SOAP-UI as client tools for testing. REST ( Representational State Transfer ) REST uses underlying HTTP protocols. REST can read and write request response messages in JSON/XML/Plain HTML. REST is stateless. REST services are cache able.  REST has light weight client tools or plugins that can easily be integrated inside browser.

Top Sql Server Interview questions for Experienced

1. What are the two authentication modes in SQL Server? There are two authentication modes – Windows Mode Mixed Mode Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page. 2.  What Is SQL Profiler? SQL Profiler is a tool which allows system administrator to monitor events in the SQL server.  This is mainly used to capture and save data about each event of a file or a table for analysis. 3. What is recursive stored procedure? SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively. It can nest up to 32 levels. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 CREATE PROCEDURE [ dbo ] . [ Fact ] ( @ Number Integer , @ RetVal Integer OUTPUT ) AS DECLARE @ In Integer DECLARE @ Out Integer IF @ Number !=...