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                      
tip   To Refer this Site to Your Friends   Click Here
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 transaction ? Give me one example.
 Question Submitted By :: Murali Gudipudi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is transaction ? Give me one example.
Answer
# 1		 
transaction is series of actions that should happen without 
any fail.
 if the transaction consists of 3  actions , if anyone of 
these fails, then whole transaction wil be rolled back.


like,

  banking: we used to say it as a transaction.
  logging in, transfer fund and logging out.
 if any one of these fails ,
  the transaction  will  not be completed.
 
Is This Answer Correct ?    7 Yes 0 No
Nirmala.s
 
  Re: What is transaction ? Give me one example.
Answer
# 2		 
Transaction is logical unit of work. It will be done all 
the things must otherwise none.
It Should be Satisfy ACID Property.
A - Acit
C - Consistency
I - Isolation
D - Durability.

  By
Kumar T
 
Is This Answer Correct ?    1 Yes 0 No
Kumar
 
 
 
  Re: What is transaction ? Give me one example.
Answer
# 3		 
Well kumar u r right but in ACID Property 
A stands Atomicity not Acit
Remaining are correct.
 
Is This Answer Correct ?    1 Yes 0 No
Geetanjali
 
  Re: What is transaction ? Give me one example.
Answer
# 4		 
A transaction is a logical unit of work, it ensures that 
multiple data modifications are procecessed together.
A transaction follows four properties(rules).
Those properties are "ACID".
ACID stands for  Automocity
                 Consistency
                 Isolation and
                 Durability
 
Is This Answer Correct ?    0 Yes 0 No
Mobin Sathupally
 
  Re: What is transaction ? Give me one example.
Answer
# 5		 
Transcation is sequence of operations performaed a single 
logical unit of work

Atomic
Constistence
Isolation
Durabulity
 
Is This Answer Correct ?    2 Yes 0 No
Hari
 
  Re: What is transaction ? Give me one example.
Answer
# 6		 
Hai Geetanjali
Thanks
By
Kumar.T
 
Is This Answer Correct ?    1 Yes 0 No
Kumar.t
 
  Re: What is transaction ? Give me one example.
Answer
# 7		 
Hai..

plz understand what they asked?
don't post answer what u studied in material..

if u know well with example post it..

plz don't waste ur time and others?
 
Is This Answer Correct ?    3 Yes 0 No
Senthilsjc
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is database replicaion? What are the different types of replication you can set up in SQL Server? HCL4
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  5
What is database normalization? Digicel5
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
What is Covering Indexes? Plz explain with example  2
What is deadlock and how to avoid the deadlocks. Wipro3
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
What is Trigger? Misys2
How to count the number of duplicate items in a table?  1
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?  1
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
What is BCP? When do we use it?  1
What is the difference Between Sql-server 2000 & 2005 Value-Labs2
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
What is the difference between views and stored procedures? Can we have input parameters for views?  3
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
 
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