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 sql collation?

1200

Tell me what do you understand by a view? What does the with check option clause for a view do?

1017

Tell me what is the significance of null value and why should we avoid permitting null values?

979

What is use of dbcc commands?

1063

What is analysis service repository?

1023

What is snapshot replication?

1047

What is the purpose of sql profiler in sql server?

1015

Explain the concepts and capabilities of sql server?

968

What do you understand by a view?

993

Tell me what is the difference between locking and multi-versioning?

1022

What is user defined datatypes and when you should go for them?

1014

What is normalization? Explain different forms of normalization?

1151

Explain candidate key, alternate key, and composite key?

997

Please explain go command in sql server?

1045

Tell me what is log shipping?

973

Un-Answered Questions { SQL Server }

What is bit data type?

1034

What is trace flag in sql server?

1016

what's the difference between a primary key and a unique key? : Sql server database administration

943

What is meant by referential integrity?

1006

How can windows applications connect to sql servers via odbc?

1117

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

How do you run a trace?

894

Why should one not prefix user stored procedures with ‘sp_’?

1038

Why are you getting errors when creating a new odbc dsn?

1213

Which are ddl commands?

1038

How to execute a sql statement using odbc_exec()?

1135

What is data modification?

968

What is sqlcmd?

1043

What do you understand by check constraint in sql server?

943

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

1244

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