What is an autonomous transaction?

AnswerBot
2y

Autonomous transaction is a separate transaction initiated by a parent transaction.

  • It allows a subtransaction to commit or rollback independently of the parent transaction.

  • It is useful for logging or ...read more

Manohar Gonuguntlla
2y

An autonomous transaction is an independent transaction started by a calling program. A commit or rollback of SQL statements in the autonomous transaction has no effect on the commit or rollback in a ...read more

Manohar Gonuguntlla
2y

An autonomous transaction is an independent transaction started by a calling program. A commit or rollback of SQL statements in the autonomous transaction has no effect on the commit or rollback in a ...read more

Deepak Pradhan
2y

Autonomous transection is independent transmission. This transaction is never effective main transection committee or role back.

Autonomous transection declare in anonymous block, procedure and trigger...read more

Raghavapurapu Anilkumar
2y

Autonomous transaction an independent transaction started a calling program.commit or roll back of SQL statements in the autonomous transaction no effect on the commit or roll back

Anonymous
2y

Autonomous transaction changes the way a sub program works in a transaction A sub program marked with this transaction can perform SQL operations without committing or rolling back the data in the mai...read more

Tanu singhal
2y

All the modifications done on data will be termed as a transaction

Select
Add answer anonymously...

TCS Plsql Developer interview questions & answers

A Plsql Developer was asked 4mo agoQ. What is the difference between procedures and functions?
A Plsql Developer was asked 4mo agoQ. What is the difference between char, varchar, and varchar2 data types?
A Plsql Developer was asked 4mo agoQ. What are the differences between Rank and Dense Rank in SQL?

Popular interview questions of Plsql Developer

A Plsql Developer was asked 4mo agoQ1. What is the difference between procedures and functions?
A Plsql Developer was asked 4mo agoQ2. What is the difference between char, varchar, and varchar2 data types?
A Plsql Developer was asked 4mo agoQ3. What are the differences between Rank and Dense Rank in SQL?
TCS Plsql Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+

Reviews

10L+

Interviews

4 Cr+

Salaries

1.5 Cr+

Users

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits