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

Mention the differences between local and global temporary tables.

1110

What do you understand by check constraint in sql server?

1015

What is the tcp/ip port on which sql server runs?

1236

What do you understand by intent locks?

1058

Explain log shipping and mention its advantages.

1088

Explain log shipping?

1076

What do you understand by the analysis services in sql server?

981

What are the steps you must follow to hide sql server instances?

1023

What are the advantages of mirroring?

1041

What do you understand by user-defined function in the sql server?

1009

What are the differences between having and where clause.

1016

What are the options which must be set to allow the usage of optimistic models?

1020

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1036

Mention the command used to rename the database.

1051

Mention the differences between sql server and mysql.

1084

Un-Answered Questions { SQL Server }

Define inner join in sql server joins?

1125

How to find tables without indexes?

1153

What are the encryption mechanisms in sql server?

1080

How to specify the collation for a character data type in ms sql server?

1079

Explain different types of lock modes in sql server 2000?

982

How many types of functions are there in sql server?

985

Describe in brief databases and sql server databases architecture.

1065

Describe how to use the linked server?

1201

What are the disadvantages of using the stored procedures?

1186

What is equi join with example?

1226

How to truncate the log in sql server 2012? : sql server database administration

1344

Explain primary key in sql server?

1074

What is sql collation?

1269

Give the query of getting last two records from the table in SQL SERVER?

1008

how to determine the service pack currently installed on sql server? : Sql server database administration

1026

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