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 1477

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

ADITI,

1056

How efficient you are in oracle and SQL server?

CGI,

1097

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

Tech Mahindra,

1005

What do you understand by SQL*Net?

Tech Mahindra,

975

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,

1103

how many type of indexing in database?

IBM,

943

Difference between rowid and rownum in SQL?

Virtusa,

1 1776

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

Tavant Technologies, Virtusa,

1 2622

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,

1032

Un-Answered Questions { SQL Server }

How to maintain a fill factor in existing indexes?

957

Do you know what is a with(nolock)?

1013

How to display a past time in days, hours and minutes?

978

Explain intellisense for query editing

988

Explain syntax for viewing trigger?

892

Can sql servers link to other servers?

1034

Explain in details security in SQL azure?

121

Explain different types of lock modes in sql server 2000?

895

What is the data tier application?

169

Explain system functions or built-in functions? What are different types of system functions?

929

How to use “drop” keyword in sql server and give an example?

1101

What is mean by candidate key?

958

How can a database be repaired?

934

What are the types of dml?

942

What is the difference between rank and dense_rank?

1012

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