Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

SQL Server databases & ACID properties.

Aug 14 2012 12:00AM by Nakul Vachhrajani   

Question

Which SQL Server database does not follow ACID properties? Explain the reasons behind your answer.

Answer

The tempdb database does not follow the ACID property of "Durability".

Whenever Microsoft SQL Server is restarted, the tempdb is recreated. Any data that was committed to the tempdb is lost and replaced by a fresh copy from the model database, therefore violating the durability property which states that the effect of a transactoin must be persisted within the database irrespective of the state of the system.

Read through the page referenced (under the "Read More..." section) for more details.

Read More..   [240 clicks]

Published under: SQL Server Interview Questions · DBA Interview Questions ·  ·  · 


Nakul Vachhrajani
4 · 36% · 11648
3
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server databases & ACID properties." rated 5 out of 5 by 6 readers
SQL Server databases & ACID properties. , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]