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

964

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

947

how can a database be repaired? : Sql server administration

967

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

979

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

1207

what does the automatic recovery do? : Sql server administration

1014

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

1061

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

977

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

946

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

970

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

967

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

998

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

1008

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

968

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

970

Un-Answered Questions { SQL Server }

How to download microsoft sql server 2005 express edition?

1040

How to create a view on an existing table in ms sql server?

1125

What do you do in data exploration

984

Explain what are the basic functions for master, msdb, model, tempdb databases?

968

What are the transaction properties?

1009

What are the approximate numeric data types?

923

How to concatenate two character strings together?

1111

What is the difference between composite index and covering index?

948

What is transaction server explicit transaction?

1028

Explain the phases a transaction has to undergo?

1054

whats new about truncate in sql server 2008?

2497

what are user defined datatypes and when you should go for them? : Sql server database administration

1015

When columns are added to existing tables, what do they initially contain?

1027

What is delete query?

937

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1073

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