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 are trace flags and mention a few common trace flags used with sql server?

1137

What are subqueries in sql server? Explain its properties.

1068

What do you understand by mirroring?

1044

What are joins in sql and what are the different types of joins?

1059

How can you check the version of sql server?

1158

Write a query to find 5th highest amount paid from the customer table.

988

What do you understand by physical_only option in dbcc checkdb?

1020

What are the differences between substr and charindex in sql server.

1186

What are relationships and mention different types of relationships in the dbms

1011

What do you understand by integration services in sql server?

1001

What is single-user mode?

981

What are the differences between ms sql server & oracle?

1115

What part does database design plays a role in performance of an sql server-based application?

1033

What do you understand by replication in sql server? Mention the different types of replication in sql server.

994

What is the command dbcc checkdb used for?

1069

Un-Answered Questions { SQL Server }

How to list all columns in a table using odbc_columns()?

1032

Where are sql server user names and passwords stored in sql server?

1154

What are the differences between triggers and stored procedures?

1114

When is the use of update_statistics command?

1057

How adventureworkslt tables are related?

981

What are the types of processing and explain each? : sql server analysis services, ssas

1205

What are the new features of sql server 2008 r2 reporting service?

212

How to perform backup for certificates in sql server? : sql server security

1143

Explain user defined functions?

1045

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1115

What is the difference between a function and a stored procedure?

1124

Define model database?

1032

Where is my database stored on the hard disk in ms sql server?

1110

what are different types of backups available in sql server? : Sql server database administration

984

How to delete existing rows in a table?

1246

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