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,

1201

Write SQL queries on Self Join and Inner Join.

Aspiring Minds,

1215

Write a SQL queries on Self Join and Inner Join.

Aspiring Minds,

1077

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

QuestPond,

1086

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

Tech Mahindra,

1043

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

HPCL, Hughes Systique Corporation, Ittiam Systems,

1026

Can we linked SharePoint to a SQL database?

Sans Pareil IT Services,

1073

Define ACID properties in a Database?

iNautix,

1102

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

IBM,

1114

How many types of the database links?

MCN Solutions,

1115

How to connect a database with sql express.?

MCN Solutions,

1115

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

Aspiring Minds,

1183

What is the difference between system objects and user objects?

HCL,

1212

How to manipulate data from one table to another table ?

MCN Solutions,

1019

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

1053

Un-Answered Questions { SQL Server }

Explain datetimeoffset data type in sal server 2008?

972

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1025

How many triggers you can have on a table?

1032

What is an identity?

1076

Do you know what are acid properties of transaction?

1005

How to provide values to user defined function parameters?

1060

What happens if null values are involved in bitwise operations?

1078

Explain cursor as data base object?

1095

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

938

What is a transaction and why is it important?

1162

What happens when the SQL Azure database reaches Max Size?

113

Explain where clause?

1033

What is spatial and temporal data?

1050

What are security principals used in sql server 2005?

1036

Define outer join in sql server joins?

990

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