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

Can multiple columns be used in sql group by clause in ms sql server?

1049

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1025

How to create new databases with "create database" statements?

1017

How to filter out duplications in the returning rows in ms sql server?

1130

How to list all user defined functions in the current database?

1035

How to list all login names on the ms sql server?

1136

How to define output parameters in stored procedures?

1023

How to how to convert numeric expression data types using the convert() function??

1044

What are group functions in query statements in ms sql server?

999

How to configure and test odbc dsn settings?

1155

How to list all user names in a database?

1047

How to create a user name in a database?

1049

What are indexes in ms sql server?

1055

What are unicode character string data types in ms sql server?

1243

What are the mathematical functions supported by sql server 2005?

1063

Un-Answered Questions { SQL Server }

What is RAID? What are the different types of RAID configurations?

1128

explain different levels of normalization? : Sql server database administration

1000

What is store procedure? How do they work?

1008

What is the process of normalising?

993

Which are the third-party tools used in sql server and why would you use them?

895

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

What is nonclustered index with included columns ?

961

How to write a query with a right outer join in ms sql server?

910

Explain about thread and memory management process of SQL?

967

Explain a differential backup?

1001

Explain go command in sql server?

1030

What are the disadvantages of primary key and foreign key in SQL?

1103

What is precedence constraint?

975

Define left outer join in sql server joins?

956

What is a bit datatype?

982

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