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 default fill factor value?

1075

Where do you find the default Index fill factor and how to change it?

1058

What is a system database and what is a user database?

1080

What are the recovery models for a database?

1101

What is the importance of a recovery model?

1041

What is Replication?

1040

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

1067

What the different components of Replication and what is their use?

1064

What are the different Topologies in which Replication can be configured?

1182

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1100

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1081

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1039

What is meant by Active-Passive and Active-Active clustering setup?

1170

List out a number of the wants to setup a SQL Server failover cluster?

1063

What is Transparent Data Encryption?

996

Un-Answered Questions { SQL Server }

What is transact-sql ddl trigger?

1104

What do you mean by the term 'normalization'?

1199

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

964

explain different types of constraints? : Sql server database administration

950

Can we add our custom code in ssis?

981

What samples and sample databases are provided by microsoft?

1033

What are the various editions of sql server 2017 that are available in the market?

889

What is the bookmark lookup and rid lookup?

996

What is save transaction and save point?

1197

What do you do in data exploration

984

What are page splits?

995

Explain how to send email from sql database?

1046

What is difference between index seek vs. Index scan?

1153

What is the name of the Database which IBM mainframe uses?

979

Explain rdbms?

1026

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