ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What is a transaction and what are ACID properties?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is a transaction and what are ACID properties?
Answer
# 1		 
A transaction is a logical unit of work in which, all the
steps must be performed or none. ACID stands for Atomicity,
Consistency, Isolation, Durability. These are the properties
of a transaction.
 
Is This Answer Correct ?    1 Yes 0 No
Srivas
 
  Re: What is a transaction and what are ACID properties?
Answer
# 2		 
A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four 
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and 
Durability.
 
Is This Answer Correct ?    1 Yes 0 No
Mobin Sathupally
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are sub-queries? Give example? In which case sub-queries are not feasible? Infosys1
What is the difference between SSAS 2000 and SSAS 2005? APX1
syntax for deleting the database in T SQL  3
can any one please send sql quries most used in applications.  1
what is index seek and index scan?  2
How to Execute an Operating System Command From Within SQL Server ?  2
What is the difference between distinct clause and group by clause? Value-Labs1
What are the types of indexes available with SQL Server?  2
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies9
What is the STUFF function and how does it differ from the REPLACE function?  1
What are the pros and cons of creating extended stored procedures?  1
what is advantages in sql 2005 over sql 2000?  1
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
What is Trigger? Misys2
How to Check Whether a Global Temporary Exists in a SQL Database or not?  2
Advantages and Disadvantages of Cursor? Zenith4
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  14
How the data stores in a page?  1
What is the system function to get the current user's user id? TCS2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com