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?

1114

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

1070

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

1067

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

1210

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

1114

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

1181

How to define output parameters in stored procedures?

1081

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

1091

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

1063

How to configure and test odbc dsn settings?

1224

How to list all user names in a database?

1090

How to create a user name in a database?

1101

What are indexes in ms sql server?

1114

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

1339

What are the mathematical functions supported by sql server 2005?

1124

Un-Answered Questions { SQL Server }

What is database isolation in sql server? : sql server database administration

1152

What is sql view?

1117

what is spatial nonclustered index

1035

What is right outer join in sql server joins?

1216

how to trace the traffic hitting a sql server? : Sql server database administration

1948

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1093

What do you mean by 'normalization'?

1121

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

1036

What is a field name?

1017

What is postgresql server?

1057

How can you hide the sql server instances?

1066

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1247

Tell me what is normalization? Explain different forms of normalization?

1071

What are the source of constraints?

977

How to bind a view to the schema of the underlying tables?

1046

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