SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Is Sql non procedural query language?

Verifone,

1 1475

Write a SQL command to insert and update only a particular field?

ADITI,

1056

How efficient you are in oracle and SQL server?

CGI,

1096

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

1004

What do you understand by SQL*Net?

Tech Mahindra,

973

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

1093

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

940

When to use Inner join & when to use subquery?

IBM,

1100

how many type of indexing in database?

IBM,

943

Difference between rowid and rownum in SQL?

Virtusa,

1 1774

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 2619

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

888

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1096

What Is Rdbms?

Accenture,

1094

How can you tell if a database object is invalid?

MCN Solutions,

1030

Un-Answered Questions { SQL Server }

What is sql server english query?

1058

What is the purpose of indexing?

1006

What is xdr?

941

What is outer join in sql server joins?

1058

What is openrowset sql server?

1080

What is a recursive stored procedure in sql server?

1102

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1172

What is the purpose of the master database?

1066

What do you understand by coalesce in sql server?

1014

What is the Main Difference between ACCESS and SQL SERVER?

1082

What are different types of table joins?

968

What are ddl triggers and types of ddl trigger?

985

How to provide values to stored procedure parameters in ms sql server?

986

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1860

What are the difference between clustered and a non-clustered index?

984

For More Un-Answered { SQL Server } Questions Click Here