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 you explain what are commit and rollback in sql?

941

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

Do you know what are pages and extents? : SQL Server Architecture

995

Explain the truncate command? : SQL Server Architecture

1172

What are page splits? : SQL Server Architecture

990

What is tempdb database? : SQL Server Architecture

1198

What is database architecture? : SQL Server Architecture

1045

What are different types of raid configurations? : SQL Server Architecture

1086

What do you know about system database? : SQL Server Architecture

986

What are the database objects? : SQL Server Architecture

1052

What are the restrictions applicable while creating views? : SQL Server Architecture

1024

Explain the microsoft sql server delete command? : SQL Server Architecture

1086

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1048

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1006

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1007

Un-Answered Questions { SQL Server }

How would we use distinct statement? What is its use?

1072

How to verify a login name with sqlcmd tool?

1221

What is report rendering ?

157

How do use Having,Group by,Group function in SQL?

1746

What is transaction server explicit transaction?

1029

What is field with example?

925

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

List the advantages of using stored procedures?

1056

What do mean by xml datatype?

1104

Find first and last day of current month in sql server

1028

What is checkpoint process in the sql server?

1033

Can a database be shrunk with users active?

1133

Explain the concept of recursive stored procedure.

963

Introduction of rollup clause using sum and group by clause?

968

What the different types of Replication and why are they used?

1071

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