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 3nf normalization?

988

What does ss stand for sexually?

1071

Why do we use trigger?

958

Can we write trigger for view?

999

Why we should not use triggers?

961

What does it mean to normalize data?

932

What is delete query?

935

Can we call future method from trigger?

929

What is b tree index?

909

What does truncate do?

934

What is 1nf 2nf and 3nf?

885

What is the difference between a stored procedure and a user defined function?

1016

What is the difference between a view and a stored procedure?

1030

What are the grouping functions?

926

What is triggers and its types?

1005

Un-Answered Questions { SQL Server }

How to enforce security in sql server? : sql server security

1098

Do you know what is user defined datatypes and when you should go for them?

960

How do you troubleshoot errors in a SQL Server Agent Job?

1049

How do I view a procedure in sql server?

985

How to assign new column names in a view?

911

What is an index in a database?

973

What is the use of builtinadministrators group in sql server? : sql server security

1037

How do I get to sql server configuration manager?

1003

What is stored in the mssqlsystemresource database? : sql server database administration

1024

What is row-level compre?

990

Can one drop a column from a table?

1014

why would you use sql agent? : Sql server database administration

1203

What is meant by indexing files?

1033

What is the difference between executequery () and executeupdate ()?

1023

How to read data in a table with "select" statements?

961

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