What is CrazyEngico.com (CE)?

CrazyEngico (CE) is a one-stop solution for interview questions and answers, domain knowledge, e-learning, tutorials, articles and many more learning material.
e-learning - Intelligent e-learning tutorials and articles
Domain Knowledge Learn about various business domains/verticals such as Banking, Financial, Insurance, Healthcare and many more...
Interview Questions and Answers - Post your questions and answers. 1000+ database of ready questions and answers available to prepare for an interview.
Tutorials - 300+ video tutorials from beginner to expert level.
Articles - 300+ technical articles to understand concepts.
Forum - A technical forum to post your queries/responses.

Search Questions

Post Your Question
Interview Questions/Answers

SQL Server Q & A
Interview Q & A >> SQL Server >>

Total SQL Server questions: 55

Q 1) What is a Stored Procedure?
Q 2) What is a Function?
Q 3) What is a View?
Q 4) What is a Trigger?
Q 5) What is Index? What is it's purpose?
Q 6) Explain about Clustered and Non-Clustered index.
Q 7) What is the disadvantage of an index?
Q 8) How can I enforce to use particular index?
Q 9) What is Index Tuning?
Q 10) Difference between Index defrag and Index rebuild
Q 11) What is Sorting and what is the difference between sorting and clustered indexes?
Q 12) What are statistics, under what circumstances they go out of date, how do you update them?
Q 13) What is fillfactor? What is the use of it? What happens when we ignore it? When you should use low fill factor?
Q 14) What are the data types in SQL?
Q 15) Difference between char and nchar
Q 16) Difference between varchar and nvarchar
Q 17) What is the GUID datasize?
Q 18) How GUID becoming unique across machines?
Q 19) What is the difference between text and image data type?
Q 20) What are Joins?
Q 21) What is a Left Join or Left Outer Join?
Q 22) What is a Right Join or Right Outer Join?
Q 23) What is a Full Join or Full Outer Join?
Q 24) What are Cross Joins?
Q 25) What is a Self Join?
Q 26) What are the difference between UNION and JOINS?
Q 27) Can you improve performance by using the ANSI-style joins instead of the old-style joins?
Q 28) What is a derived table?
Q 29) What are the different types of stored procedure?
Q 30) How do you mark the stored procedure to automatic execution?
Q 31) How will you know whether the SQL statements are executed?
Q 32) Why one should not prefix user stored procedure with sp_?
Q 33) What can cause a stored procedure execution plan to become invalidated and/or fall out of cache?
Q 34) What are the ways SQL Server provides to recompile a stored procedure?
Q 35) How will you handle Errors in SQL Stored Procedure?
Q 36) How will you raise an error in SQL?
Q 37) How will you return XML from Stored Procedure?
Q 38) Can a Stored Procedure call itself (recursive)? If so then up to what level and can it be control?
Q 39) What are Nested Triggers?
Q 40) What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Q 41) Difference between View and Stored Procedure
Q 42) Difference between Function and Stored Procedure
Q 43) What are the types of Triggers?
Q 44) Difference between Trigger and Stored Procedure
Q 45) What are the drawbacks of Triggers?
Q 46) What are locks?
Q 47) What are the different types of locks?
Q 48) What is a dead lock?
Q 49) What is a live lock?
Q 50) What is isolation level?
Q 51) What is escalation of locks?
Q 52) Does the View occupy memory space?
Q 53) Can you drop a table if it has a view?
Q 54) Why doesn't SQL Server permit an ORDER BY clause in the definition of a view?
Q 55) What is Transaction?

Post your question
By clicking on Submit button you agree to the Terms of Service agreement.

Display Name:  
Select Category:  
Post Your Question:  

Copyright © 2018 CrazyEngico.com. All rights reserved.
CrazyEngico.com is not responsible for the content and CrazyEngico.com does not evaluate or guarantee the accuracy of any CrazyEngico.com content.
Please read our terms of service agreement before using this site.