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 14123

What is a Join in SQL Server?

3 6120

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

2 6413

When do you use SQL Profiler?

Wipro,

3 9474

What is a Linked Server?

1 5946

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

1 4983

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

1 5138

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

3 9774

Can you explain the role of each service?

1 4287

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

HP,

2 12135

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 5075

What are the authentication modes in SQL Server?

IBM, iSmart,

4 9362

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

BirlaSoft,

4 10397

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.

2720

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

2 6786

Un-Answered Questions { SQL Server }

Explain ranking functions?

1000

How do I perform an unattended install of sql server 2000?

1031

Differentiate between SQL and ORACLE joins and write their syntax.

986

What is federation member?

114

What is nonclustered index with included columns ?

919

Why we should not use triggers?

925

Explain what is meant by replication of database?

969

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1026

List out the different types of locks available in sql server?

940

How to create a local temporary stored procedure?

955

What is the difference between seek predicate and predicate?

996

How can you insert values in multiple rows using one Insert statement?

1051

What are parameterized reports?

193

What are unicode character string data types in ms sql server?

1161

Explain database normalization?

1162

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