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 explicit mode in sql server?

1056

What is logon trigger?

1086

How to Update from select query in sql server?

1058

What is system stored procedures?

1039

What is sql injection? How to protect against sql injection attack?

991

What is repeatable read?

1009

What is a rollup clause?

964

How can I know what locks are running on which resource?

948

When I delete any data from a table, does the sql server reduce the size of that table?

1007

What is user-defined functions? What are the types of user-defined functions that can be created?

1031

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1073

How to find the list of fixed hard drive and free space on server?

1190

What is difference in performance between insert top (n) into table and using top with insert?

1038

What is change data capture (cdc) in sql server 2008?

1024

Where are sql server usernames and passwords stored in the sql server?

1110

Un-Answered Questions { SQL Server }

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

983

How can I check if a view exists in a sql server database?

1033

what is a schema in sql server 2005? : Sql server database administration

1021

How does Report Builder support Analysis Services cubes?

153

What is sql language?

1134

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1128

what is a self join? Explain it with an example? : Sql server database administration

945

How to filter records of table in SQL SERVER?

1082

How to call a function from a stored procedure in SQL Server ?

1024

How many replicas are maintained for each SQL Azure database?

142

What is onf in normalization form?

1052

What is a performance monitor?

972

What do you understand by physical_only option in dbcc checkdb?

977

What is attribute? : sql server analysis services, ssas

1015

How to replace the Query Result 'Null Value' with a text ?

1031

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