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 1558

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

ADITI,

1110

How efficient you are in oracle and SQL server?

CGI,

1154

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

Tech Mahindra,

1042

What do you understand by SQL*Net?

Tech Mahindra,

1032

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

IBM,

1137

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

IBM,

993

When to use Inner join & when to use subquery?

IBM,

1162

how many type of indexing in database?

IBM,

981

Difference between rowid and rownum in SQL?

Virtusa,

1 1860

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

Tavant Technologies, Virtusa,

1 2703

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

Amazon,

923

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1147

What Is Rdbms?

Accenture,

1158

How can you tell if a database object is invalid?

MCN Solutions,

1074

Un-Answered Questions { SQL Server }

What do you mean by subquery?

1087

Explain microsoft sql server functions?

1111

What is the difference between primary key and unique constraints?

963

how to overcome kernel isssues

1625

What is database dimension? : sql server analysis services, ssas

1078

How to apply cascading referential integrity in place of triggers?

1034

Is ssrs support other database except ms sql server?

139

How global temporary tables are represented and its scope?

977

What is buffer cash and log cache in sql server?

1122

How can we solve concurrency problems?

1054

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

What is triggers in ms sql server?

1118

Explain a join?

1068

What is a trigger what are the advantages of trigger?

1001

What are the new features in sql server 2016?

967

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