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 do you mean by COLLATION?

ABC, BirlaSoft,

4 14465

What is a Join in SQL Server?

3 6446

Can you explain the types of Joins that we can have with Sql Server?

2 6652

When do you use SQL Profiler?

Wipro,

3 9730

What is a Linked Server?

1 6154

Can you link only other SQL Servers or any database servers such as Oracle?

1 5133

Which stored procedure will you be running to add a linked server?

1 5314

What are the OS services that the SQL Server installation adds?

3 10079

Can you explain the role of each service?

1 4457

How do you troubleshoot SQL Server if its running very slow?

HP,

2 12406

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 5238

What are the authentication modes in SQL Server?

IBM, iSmart,

4 9720

Where do you think the users names and passwords will be stored in sql server?

BirlaSoft,

4 10733

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2813

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 7021

Un-Answered Questions { SQL Server }

How do I view a trc file?

981

Sql server reporting services vs. Crystal reports.

142

Can we store videos inside the sql server table?

1029

What is a cursor, index in sql?

1130

Name few endpoints exposed by ssrs 2012?

366

What will happen if a column containing char type data is changed to the nchar data type?

1157

What is the difference between for xml raw and for xml auto?

1084

What do you understand by a view?

1053

Which autogrowth database setting is good?

1097

What type of Index will get created after executing the above statement?

1150

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1022

Can you type more than one query in the query editor screen at the same time?

1073

How to use clusters?

1021

Can one drop a column from a table?

1069

Please differentiate between a local and a global temporary table?

1059

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