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

Define normalisation?

0 Answers  


What is the language structure to add a record to a table?

0 Answers  


How do you create a data source?

0 Answers  


What is the purpose of forms?

0 Answers  


Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  






* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  


Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  


Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  


How to copy the tables, schema and views from one sql server to another?

0 Answers  


Why is replication required on the sql server?

0 Answers  


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  


How to select some specific rows from a table in ms sql server?

0 Answers  


Categories