Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is autonomouse transaction?

Question Posted / mailtogirik

Answers were Sorted based on User's Feedback



what is autonomouse transaction?..

Answer / p.rajasekar

Autonomous transactions are started by a parent, or main,
transaction but operate
independently of the parent for transaction control. If a
commit or rollback is used
in the autonomous or main transaction, or if a failure
occurs for any reason, it does
not impact the other transaction.
Our favorite use of this feature is for logging application
events. If the need is to
log activity, regardless of the outcome, but the logging
success or failure should not
impact the application, autonomous transactions are the
perfect solution.
To create an autonomous transaction, use a pragma called
AUTONOMOUS_TRANSACTION. The pragma is placed in the
declaration section of the block.

Is This Answer Correct ?    16 Yes 0 No

what is autonomouse transaction?..

Answer / rasmita basantia

its mainly used in that schenario where u are interested to
perform independent transaction.

Is This Answer Correct ?    1 Yes 0 No

what is autonomouse transaction?..

Answer / singh

eg: We can take a normal bank transaction. Each transaction
has two part one debit and other credit and if any one part
fails the whole transanction fails.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

What is sorting in sql?

0 Answers  

How many parts of a pl sql block are optional?

0 Answers  

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

What is the limitation on the block size of pl/sql?

0 Answers  

What are functions in sql?

0 Answers  

What is spool?

0 Answers  

Explain cursor types?

0 Answers  

What is int identity in sql?

0 Answers  

Why is theta join required?

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

what is heap table? : Sql dba

0 Answers  

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

For more SQL PLSQL Interview Questions Click Here
Categories