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 is the use of floor function in sql server?

1127

Define the one-to-one relationship while designing tables.

939

Which is the main third-party tool used in sql server?

992

What is the boxing and unboxing concept in .net?

976

What is the log shipping?

1063

Is there any difference between primary key and unique with the not null condition?

1001

In which tcp/ip port does sql server run? Can it be changed?

1038

What is "scheduled jobs" or "scheduled tasks"?

1027

What is the dbcc command and why is it used?

1107

How will you decide the active and passive nodes?

1179

How can you hide the sql server instances?

1067

What is the difference between value type and reference type?

987

Define magic tables in sql server?

1116

Explain different types of collation sensitivity?

1031

What command is used to rename the database?

1086

Un-Answered Questions { SQL Server }

How to insert a new row into a table with "insert into" statements in ms sql server?

1013

What is openxml in sql server?

1219

How to declare a cursor with "declare ... Cursor" in ms sql server?

1090

What you can do to delete a table without the delete trigger firing?

1012

What are the database roles? : sql server security

1277

What is the recursive stored procedure in sql server?

1076

Is it safe to delete log files?

971

What is the difference function and stored procedure?

1110

how many bits ip address consist of? : Sql server database administration

943

How to return the date part only from a sql server datetime datatype?

1164

What are the features of Embedded SQL

1173

How to return the top 5 rows from a select query in ms sql server?

1209

How to use the inserted and deleted pseudo tables?

1003

What is Federation and Federation Member?

You want to implement the one-to-many relationship while designing tables. How would you do it?

996

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