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 the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

974

can an automatic recovery be initiated by a user? : Sql server administration

958

how can a database be repaired? : Sql server administration

981

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

988

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1220

what does the automatic recovery do? : Sql server administration

1025

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1071

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

987

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

950

how can you check the level of fragmentation on a table? : Sql server administration

988

what stored procedure would you use to view lock information? : Sql server administration

978

if no size is defined while creating the database, what size will the database have? : Sql server administration

1012

what stored procedure can you use to display the current processes? : Sql server administration

1016

what information is maintained within the msdb database? : Sql server administration

981

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

979

Un-Answered Questions { SQL Server }

What is database replication?

1152

What is the boxing and unboxing concept in .net?

919

How much space does sql server 2016 take?

988

Do you know what is sql injection?

1004

What is the osql utility?

978

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1150

Do you know what are the ways available in sql server to execute sql statements?

1041

Explain the difference between clustered and non-clustered index?

928

what changed between the previous version of sql server and the current version? : Sql server database administration

1016

Does sql server use java?

1078

Define Unique Key?

1023

Explain syntax for viewing trigger?

930

What are the differences between clustered and non-clustered index?

1033

How to check table values in sql server?

959

How to find the source of a table in sql server?

1000

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