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,

1039

What do you understand by SQL*Net?

Tech Mahindra,

1031

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,

1161

how many type of indexing in database?

IBM,

980

Difference between rowid and rownum in SQL?

Virtusa,

1 1858

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 }

When would you use a before or after trigger?

907

How do triggers work?

932

Can coalesce return null?

1013

What is SQL Azure Data sync?

121

Tell me what is log shipping?

977

what is denormalization? : Sql server database administration

923

What do you mean by normalisation?

1041

How to change the system date and time from SQL Plus Terminal ?

1220

What are dml (data manipulation language) statements in ms sql server?

983

How can you append an identity column to a temporary table?

953

What is clustered primary key?

1026

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1026

Tell about MOM Tool(Microsoft Operator Manager)?

1914

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1606

What happens on checkpoint?

1024

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