What is transaction ? Give me one example.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Define normalisation?
What is the language structure to add a record to a table?
How do you create a data source?
What is the purpose of forms?
Tell me what is the significance of null value and why should we avoid permitting null values?
* 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
Is it possible for a stored procedure to call itself or recursive stored procedure?
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?
How to copy the tables, schema and views from one sql server to another?
Why is replication required on the sql server?
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
How to select some specific rows from a table in ms sql server?