SQL Server Interview Questions    

Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks 8 things you should NOT do in a Group Discussion How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite Soft skills every professional must have

SQL Server Interview Questions & Answers part 2

---

<<Previous  Next>>

By Nishant Kumar

Part 1 | Part 2 | Part 3 | Part 4 | part 5 | part 6 | part 7 | part 8 | part 9 What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column? Answer - A table can have only one ROWGUIDCOL column...... What is the actions prevented once referential integrity is enforced? Answer - Following are the actions prevented once referential integrity is enforced...... What are the commands available for Summarizing Data in SQL Server? Answer - We have CUBE or ROLLUP operators to generate summary reports. Both are part of the GROUP BY.... List out the difference between CUBE operator and ROLLUP operator Answer - CUBE generates a result set that represents aggregates for all combinations of values in the selected columns....... What are the guidelines to use bulk copy utility of SQL Server? Answer - While importing data, the destination table must already exist...... What are the capabilities of Cursors? Answer - Cursors can support various functionalities that are listed here..... What are the ways to controlling Cursor Behavior? Answer - Cursors behavior can be controlled by dividing them into cursor types: forward-only, static,........ What are the advantages of using Stored Procedures? Answer - Stored procedures provide performance benefits through local storage, precompiling the code, and caching...... What are the ways to code efficient transactions? Answer - Database users can have permission to execute a stored procedure without being.... What are the differences among batches, stored procedures, and triggers? Answer - A batch is a group of one or more SQL statements. SQL Server compiles the statements...... What security features are available for stored procedures? Answer - Database users can have permission to execute a stored procedure without being...... What are the instances when triggers are appropriate? What are the restrictions applicable while creating views? Answer - Views can be created referencing tables and views only in the current database....... What are the events recorded in a transaction log? Answer - The start and end of each transaction...... Describe when checkpoints are created in a transaction log. Answer - It is created when CHECKPOINT statement is executed....... Part 1 | Part 2 | Part 3 | Part 4 | part 5 | part 6 | part 7 | part 8 | part 9 <<Previous  Next>>