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 1473

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

ADITI,

1053

How efficient you are in oracle and SQL server?

CGI,

1096

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

Tech Mahindra,

1000

What do you understand by SQL*Net?

Tech Mahindra,

968

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

IBM,

1091

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,

1096

how many type of indexing in database?

IBM,

943

Difference between rowid and rownum in SQL?

Virtusa,

1 1771

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

Tavant Technologies, Virtusa,

1 2614

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,

1093

What Is Rdbms?

Accenture,

1094

How can you tell if a database object is invalid?

MCN Solutions,

1027

Un-Answered Questions { SQL Server }

What is difference between inner join and join?

988

How to get the query of a table in sql server?

858

Explain Geography datatype in SQL Server

1072

What are the main differences between #temp tables and @table variables and which one is preferred?

1021

What are the advantages of sql azure?

140

Explain ranking functions?

1000

How to transfer data from a cursor to variables with a "fetch" statement?

1033

What is cte (common table expression)?

984

Explain the cursor lock types?

992

Why use update_statistics command in sql server?

1009

Can we add an identity column to decimal datatype?

957

What stored by the model? : sql server database administration

914

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

922

What is difference between drop truncate and delete?

1024

what is a check constraint?

1048

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