What is difference between rollback immediate and with no_wait during alter database?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is Trigger?

3 Answers   Misys,


What is database black box testing?

0 Answers  


Explain the cursor lock types?

0 Answers  


which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,


What is Cross Join

3 Answers  






Explain how many normalization forms?

0 Answers  


How do you find the number of rows in a table?

7 Answers  


how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  


What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,


How do I debug a stored procedure in sql server?

0 Answers  


how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  


What are four major operators that can be used to combine conditions on a where clause?

0 Answers  


Categories