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 
wt is mean by acid property? i know it is 
atomocity,consistency,isolation and durabulaty but wt is 
these mean and wt actions it's perform
 Question Submitted By :: Venkat
I also faced this Question!!     Rank Answer Posted By  
 
  Re: wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
Answer
# 1		 
Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)

Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)

Isolated (no transaction sees the intermediate results of
the current transaction)

Durable (the values persist if the data had been committed
even if the system crashes right after).
 
Is This Answer Correct ?    0 Yes 1 No
Praveen
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How the data stores in a page?  1
What are constraints? Explain different types of constraints?  6
What are primary keys and foreign keys?  3
what is differece between union and union all  4
What is a Lock and let me know Different types of locks?  1
What types of integrity are enforced by a foreign-key constraint  1
what is meant by deafult in sql server?  2
How do I list the available tables in a database I'm querying?  3
What is Trigger? Misys2
In which year relase the 7.0& 2000 & 2005?  1
what is the maximum size of a row in sql server 2000 and 2005  2
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages. 247Customer3
How do we get month name in SQL Server 2000, Oracle, MS Access?  9
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?  3
What is user stored procedure & it purpose? Wipro3
What is the difference between SSAS 2000 and SSAS 2005? APX1
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?  3
how to generate XML out of QUERY? McAfee1
What are statistics, under what circumstances they go out of date, how do you update them? HCL2
Can we have more than one NULL in a column having unique constraint? 247Customer7
 
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