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

What is the use of toad or sqldbx.?

MCN Solutions,

1146

Write SQL queries on Self Join and Inner Join.

Aspiring Minds,

1150

Write a SQL queries on Self Join and Inner Join.

Aspiring Minds,

1038

Write a SQL query in order to merge two different columns into single column?

QuestPond,

1030

Write a program using SQL queries to find a unique entry in a table.

Tech Mahindra,

988

Write the SQL query to drop, truncate and delete table.

HPCL, Hughes Systique Corporation, Ittiam Systems,

965

Can we linked SharePoint to a SQL database?

Sans Pareil IT Services,

1021

Define ACID properties in a Database?

iNautix,

1051

How do I change my passwords (database, LDAP, and so on) without causing an outage?

IBM,

1063

How many types of the database links?

MCN Solutions,

1066

How to connect a database with sql express.?

MCN Solutions,

1056

Write a code to select distinct records without using the DISTINCT keyword.

Aspiring Minds,

1111

What is the difference between system objects and user objects?

HCL,

1157

How to manipulate data from one table to another table ?

MCN Solutions,

965

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

995

Un-Answered Questions { SQL Server }

What is the current limitation of the size of SQL Azure DB?

124

What do you mean by an execution plan? Why is it used? How would you view it?

925

How to create sub reports?

242

What are the restrictions that views have to follow?

961

How can I track the changes or identify the latest insert-update-delete from a table?

948

Explain the various types of concurrency problem?

1174

What is the library index called?

1053

What are the Advantages of using CTE in sql server?

1110

Explain the steps to use transact-sql cursor?

1052

Define Wed Edition in SQL Azure?

100

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1134

How do I start sql server agent automatically?

964

What happens if null values are involved in boolean operations?

985

How many types of the database links?

1066

Define outer join?

985

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