What is transaction ? Give me one example.




Answers were Sorted based on User's Feedback



What is transaction ? Give me one example...

Answer / nirmala.s

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 ?    44 Yes 9 No

What is transaction ? Give me one example...

Answer / geetanjali

Well kumar u r right but in ACID Property
A stands Atomicity not Acit
Remaining are correct.

Is This Answer Correct ?    19 Yes 4 No

What is transaction ? Give me one example...

Answer / mobin sathupally

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 ?    18 Yes 4 No




What is transaction ? Give me one example...

Answer / senthilsjc

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 ?    17 Yes 4 No

What is transaction ? Give me one example...

Answer / kumar

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 ?    24 Yes 16 No

What is transaction ? Give me one example...

Answer / ashique

Transaction is a database operation that satisfies following
a condition called ACID:

A (Atomicity) : Do all the operations successfully Or None.
C (Consistency) : The operation should not violate data
integrity concept.
I (Isolation) : When one person is manipulating the data,
others should wait (i.e synchronization).
D (Durability): Once transaction is over succesfully, the
changes should be permanent at any cost.

The best example of a simple transaction is bank fund
transfer from one account to another. Try to implement above
points using your common sense. Thank you :)

Is This Answer Correct ?    11 Yes 3 No

What is transaction ? Give me one example...

Answer / hari

Transcation is sequence of operations performaed a single
logical unit of work

Atomic
Constistence
Isolation
Durabulity

Is This Answer Correct ?    12 Yes 8 No

What is transaction ? Give me one example...

Answer / shoaib aatish

Transaction is accrue between tow parties like any business-related exchange such as Payments to employees, Sales to customers and payments to the suppliers. Thus, processing business transaction was the first application of computer for most organizations.
Regards:
Shoaib Aatish from MSC CS, UAF, FSD

Is This Answer Correct ?    2 Yes 2 No

What is transaction ? Give me one example...

Answer / raj

Transaction is a daily routine work in companies, it is a
part of data that is stored daily, for example banking in
which data is stored daily.

Is This Answer Correct ?    2 Yes 3 No

What is transaction ? Give me one example...

Answer / mr.narendra singh(gulli)

transction is a process use for either execution or set
of exection process complite or abort or rollback.
Ex-ATM(alternative transation machine),railway reservation
and so on.

Is This Answer Correct ?    3 Yes 5 No

Post New Answer



More SQL Server Interview Questions

SQL Server Architecture ?

0 Answers   IBM, Sapient,


Delete duplicate rows without using rowid.

0 Answers   Nagarro,


when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,


What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Merrill Lynch, Wipro, Accenture,


What is Online Index Rebuild Operation?

1 Answers  






what is call by value & call by reference ?

2 Answers   Cap Gemini,


what is the output for this query select * from employee where 1=1;

4 Answers  


How retrieve field names from the table in SQL through JAVA code?

0 Answers  


can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,


If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  


What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


wat new abt truncate in sql server

2 Answers   HP, HCL,






Categories