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?

1049

What are subqueries in sql server? Explain its properties.

978

What do you understand by mirroring?

959

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

976

How can you check the version of sql server?

1059

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

896

What do you understand by physical_only option in dbcc checkdb?

952

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

1040

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

923

What do you understand by integration services in sql server?

933

What is single-user mode?

876

What are the differences between ms sql server & oracle?

1017

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

942

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

903

What is the command dbcc checkdb used for?

974

Un-Answered Questions { SQL Server }

What is the purpose of forms?

917

How to choose all records from the table?

1021

What do we have to check in database testing?

983

How many null values we can have in a unique key field in sql server?

917

Do you know what is a with(nolock)?

1013

Does partitioning ssd reduce performance?

863

Where are SQL server users names and passwords are stored in sql server?

1217

What are the advantages of using stored procedures in sql server?

971

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1017

Is foreign key a primary key?

1001

What is bit data type? What's the information that can be stored inside a bit column?

888

What are the components of sql server service broker?

958

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

968

What is the order in which the sql query is executed?

893

What is oltp (online transaction processing)?

960

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