{"id":14683,"date":"2023-03-20T10:33:08","date_gmt":"2023-03-20T10:33:08","guid":{"rendered":"https:\/\/www.prepbytes.com\/blog\/?p=14683"},"modified":"2023-12-26T09:35:53","modified_gmt":"2023-12-26T09:35:53","slug":"transaction-in-dbms-examples","status":"publish","type":"post","link":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/","title":{"rendered":"Transaction in DBMS and Examples"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\" alt=\"\" \/><\/p>\n<p>Transactions in Database Management Systems (DBMS) are crucial for maintaining data integrity and ensuring reliable operations within databases. A transaction is a sequence of operations (read, write, update, etc.) performed on a database that must be executed as a single unit. It follows the ACID (Atomicity, Consistency, Isolation, Durability) properties to guarantee reliability, accuracy, and consistency of the data.<\/p>\n<p>In this article, we&#8217;ll delve into the fundamentals of transactions in DBMS, exploring their importance, characteristics, and examples. Understanding transactions is pivotal for developers, database administrators, and anyone working with databases to ensure robustness and reliability in handling data operations.<\/p>\n<h2>What is a Transaction in DBMS?<\/h2>\n<p>Transaction in DBMS refers to the sequence of operations we perform on the database that is treated as a single unit of work. The transaction in DBMS can consist of any operation like update, delete, and insert. DBMS has many uses one of the major use is to protect the user data in case of any system failure whether hardware failure or software failure. The transaction starts from the execution of the first operation and it ends with the execution of the last operation.<br \/>\nThe user data is preserved by storing the data in a consistent state. When you execute the same program multiple times it will result in multiple transactions.<\/p>\n<h3>Example of Transaction in DBMS<\/h3>\n<p>Let\u2019s understand transaction in DBMS with the help of an example. We will discuss the standard example of an ATM as you can use the ATM machine easily and will be within everyone\u2019s reach so that you can understand the transactions clearly.<br \/>\nThe steps shown below are the operations of the transaction.<\/p>\n<ul>\n<li>Transaction is started<\/li>\n<li>Insert your ATM card.<\/li>\n<li>Select the language according to your preference.<\/li>\n<li>Select the option of savings account.<\/li>\n<li>Enter the amount you need to withdraw.<\/li>\n<li>Enter your pin secretly.<\/li>\n<li>Wait for the processing time.<\/li>\n<li>Collect the cash from the machine.<\/li>\n<li>Transaction completed.<\/li>\n<\/ul>\n<p>In the above example, these all steps are done by you but in transaction in DBMS there are mainly three main operations.<\/p>\n<ul>\n<li>Read<\/li>\n<li>Write<\/li>\n<li>Commit<\/li>\n<\/ul>\n<p>Let\u2019s understand all the above operations with the help of the example.<\/p>\n<p>We have to transfer rs 100 from account A to account B. INitally account has rs 600 and B has rs 900.<\/p>\n<pre><code>R(A) -- 600     \/\/ Accessed from the RAM.\nA = A-100        \/\/ Deducting rs 100 from A.\nW(A)--500       \/\/ Updated in RAM.\nR(B) -- 900     \/\/ Accessed from RAM.\nB=B+100          \/\/ 100\u20b9 is added to B's Account.\nW(B) --1000      \/\/ Updated in RAM.\ncommit          \/\/ The data in RAM is taken back to Hard Disk.<\/code><\/pre>\n<p>In the above example, we have performed the transaction where we have added rs 100 from A\u2019s account to B\u2019s account.<br \/>\nThe transaction is saved after the commit statement so if the system fails the transaction starts from the last commit statement. So it is advised to commit the transactions after their completion.<\/p>\n<h3>Uses of Transaction Management<\/h3>\n<p>There are many uses of transaction management and some of them are mentioned below:<\/p>\n<ul>\n<li>With the help of transaction management we can access the data concurrently.<\/li>\n<li>They are also used to satisfy the ACID properties.<\/li>\n<li>It can be used to solve Read\/Write conflicts.<\/li>\n<li>It is used for locking protocol and concurrency control protocols.<\/li>\n<li>We can use it to implement cascading, recoverability, and serializability.<\/li>\n<\/ul>\n<h3>ACID Properties of a Transaction<\/h3>\n<p>To ensure data integrity and consistency, transactions in DBMS are required to follow the ACID properties. ACID stands for Atomicity, Consistency, Isolation, and Durability.<\/p>\n<ul>\n<li>\n<p><strong>Atomicity<\/strong><br \/>\nWe can refer to atomicity as the indivisibility of the transaction. It means whether the transaction happens completely or does not happen at all. We will consider the transaction as a single unit of work and it either succeeds or fails as a whole. If the transaction fails in between the changes made during the transaction must e undone and the database will return to the original state.<\/p>\n<\/li>\n<li>\n<p><strong>Consistency<\/strong><br \/>\nIn simple words consistency refers to the correctness of the database. It is referred to as the state of the database before the transaction and after the transaction. The database must be consistent before, during, and after the execution of the transaction.<\/p>\n<\/li>\n<li>\n<p><strong>Isolation<\/strong><br \/>\nIsolation refers to the property with the help of which multiple transactions can occur concurrently. When many transactions are occurring concurrently the changes made in one transaction does not disturb or be applicable in other transaction. They all will execute like they are the only transaction in the system.<\/p>\n<\/li>\n<li>\n<p><strong>Durability<\/strong><br \/>\nIt means when the transaction has been completely executed the changes made by it should be written properly and must remain in the database even after the system failure. The changes are stored in nonvolatile memory so that they can be stored permanently.<\/p>\n<\/li>\n<\/ul>\n<h3>Transaction States<\/h3>\n<p>Transaction in DBMS consists of various states as it is a multiple state process.<br \/>\nA transaction in a DBMS can be in one of the following states:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039865-1-01%20%281%29.png\" alt=\"\" \/><\/p>\n<ul>\n<li>\n<p><strong>Active<\/strong><br \/>\nA transaction is said to be in an active state when its operations are ongoing. It advances to the partly committed state if all read and write operations are completed without any errors, but if any operation fails for any reason, it enters a failed state.<\/p>\n<\/li>\n<li>\n<p><strong>Partially Committed<\/strong><br \/>\nThe modifications that were previously made in the main memory are now permanently made in the database after all read and write operations are finished. Following this, the state will advance to the committed state, but in the event of failure, it will go to the failed state.<\/p>\n<\/li>\n<li>\n<p><strong>Committed<\/strong><br \/>\nWhen the transaction completes all the operations successfully, all the changes made by the transaction in the partially committed state are stored permanently then the transaction is said to be complete. After this, the transaction can move to the terminated state.<\/p>\n<\/li>\n<li>\n<p><strong>Failed<\/strong><br \/>\nIf any operation in the transaction fails due to software or hardware issue then it goes to the failed state. The occurrence of a failure makes a permanent change in the database and the changes made in the local memory are rolled back in case of failure.<\/p>\n<\/li>\n<li>\n<p><strong>Aborted<\/strong><br \/>\nDuring execution if the transaction fails then it goes from the failed state to the aborted state. The changes made during these transactions are rolled back as they are not permanently saved and the transaction will start from the last active state.<\/p>\n<\/li>\n<li>\n<p><strong>Terminated<\/strong><br \/>\nIf the transaction comes from the committed state or gets aborted after the rollback, then the transaction comes to a consistent state from where the new transaction can get started.<\/p>\n<\/li>\n<\/ul>\n<p><strong>Conclusion<\/strong><br \/>\nTransactions serve as the backbone of data management in DBMS, providing a framework for reliable and consistent database operations. Maintaining ACID properties ensures that transactions execute accurately, remain isolated from each other, and persist despite system failures. Examples like online banking transactions, inventory management in e-commerce platforms, and airline reservation systems illustrate the real-world significance of transactions.<\/p>\n<p>By comprehending the essence of transactions and their adherence to ACID principles, database practitioners can build resilient systems, maintain data integrity, and ensure the reliability of their applications in handling critical data operations.<\/p>\n<h2>Frequently Asked Questions Related to Transaction in DBMS<\/h2>\n<p>Here are some of the frequently asked questions about transactions in DBMS.<\/p>\n<p><strong>1. What are the different recovery management techniques?<\/strong><br \/>\nThe different recovery management techniques are checkpointing, journaling, and shadow paging.<\/p>\n<p><strong>2. Why are ACID properties important in transactions?<\/strong><br \/>\nACID properties\u2014Atomicity, Consistency, Isolation, and Durability\u2014are crucial for maintaining the reliability and integrity of transactions. Atomicity ensures that transactions are treated as a single unit; Consistency ensures that the database remains in a valid state before and after the transaction; Isolation ensures that transactions are executed independently without interference; Durability ensures that the changes made by committed transactions persist even after system failures.<\/p>\n<p><strong>3. What are some real-world examples of transactions in DBMS?<\/strong><br \/>\nNumerous real-world applications rely on transactions in DBMS. For instance, online banking transactions involving fund transfers, e-commerce platforms managing inventory, airline reservation systems handling seat bookings\u2014all these operations involve multiple database actions executed as transactions to ensure data accuracy and reliability.<\/p>\n<p><strong>4. How does a DBMS ensure the durability of transactions?<\/strong><br \/>\nDBMS ensures transaction durability by using techniques like write-ahead logging (WAL) or maintaining transaction logs. Changes made by committed transactions are recorded in logs before they are written to disk. In case of system failure, these logs are used to recover committed transactions and ensure that changes are durably stored.<\/p>\n<p><strong>5. What happens if a transaction fails to complete in a DBMS?<\/strong><br \/>\nIf a transaction fails to complete (due to errors, system crashes, etc.) in a DBMS, the system employs rollback mechanisms to undo the changes made by the incomplete transaction, ensuring that the database remains consistent and in a valid state.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transactions in Database Management Systems (DBMS) are crucial for maintaining data integrity and ensuring reliable operations within databases. A transaction is a sequence of operations (read, write, update, etc.) performed on a database that must be executed as a single unit. It follows the ACID (Atomicity, Consistency, Isolation, Durability) properties to guarantee reliability, accuracy, and [&hellip;]<\/p>\n","protected":false},"author":52,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[190],"tags":[],"class_list":["post-14683","post","type-post","status-publish","format-standard","hentry","category-dbms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Transaction in DBMS<\/title>\n<meta name=\"description\" content=\"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transaction in DBMS\" \/>\n<meta property=\"og:description\" content=\"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\" \/>\n<meta property=\"og:site_name\" content=\"PrepBytes Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prepbytes0211\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-20T10:33:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-26T09:35:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\" \/>\n<meta name=\"author\" content=\"Prepbytes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prepbytes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\"},\"author\":{\"name\":\"Prepbytes\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e\"},\"headline\":\"Transaction in DBMS and Examples\",\"datePublished\":\"2023-03-20T10:33:08+00:00\",\"dateModified\":\"2023-12-26T09:35:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\"},\"wordCount\":1391,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\",\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\",\"url\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\",\"name\":\"Transaction in DBMS\",\"isPartOf\":{\"@id\":\"http:\/\/43.205.93.38\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\",\"datePublished\":\"2023-03-20T10:33:08+00:00\",\"dateModified\":\"2023-12-26T09:35:53+00:00\",\"description\":\"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.\",\"breadcrumb\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage\",\"url\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\",\"contentUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/43.205.93.38\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBMS\",\"item\":\"https:\/\/prepbytes.com\/blog\/category\/dbms\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Transaction in DBMS and Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/43.205.93.38\/#website\",\"url\":\"http:\/\/43.205.93.38\/\",\"name\":\"PrepBytes Blog\",\"description\":\"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING\",\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/43.205.93.38\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/43.205.93.38\/#organization\",\"name\":\"Prepbytes\",\"url\":\"http:\/\/43.205.93.38\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"contentUrl\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"width\":160,\"height\":160,\"caption\":\"Prepbytes\"},\"image\":{\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/prepbytes0211\/\",\"https:\/\/www.instagram.com\/prepbytes\/\",\"https:\/\/www.linkedin.com\/company\/prepbytes\/\",\"https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e\",\"name\":\"Prepbytes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g\",\"caption\":\"Prepbytes\"},\"url\":\"https:\/\/prepbytes.com\/blog\/author\/gourav-jaincollegedekho-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Transaction in DBMS","description":"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/","og_locale":"en_US","og_type":"article","og_title":"Transaction in DBMS","og_description":"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.","og_url":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/","og_site_name":"PrepBytes Blog","article_publisher":"https:\/\/www.facebook.com\/prepbytes0211\/","article_published_time":"2023-03-20T10:33:08+00:00","article_modified_time":"2023-12-26T09:35:53+00:00","og_image":[{"url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg","type":"","width":"","height":""}],"author":"Prepbytes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Prepbytes","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#article","isPartOf":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/"},"author":{"name":"Prepbytes","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e"},"headline":"Transaction in DBMS and Examples","datePublished":"2023-03-20T10:33:08+00:00","dateModified":"2023-12-26T09:35:53+00:00","mainEntityOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/"},"wordCount":1391,"commentCount":0,"publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg","articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/","url":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/","name":"Transaction in DBMS","isPartOf":{"@id":"http:\/\/43.205.93.38\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg","datePublished":"2023-03-20T10:33:08+00:00","dateModified":"2023-12-26T09:35:53+00:00","description":"Understand What is a Transaction in DBMs with example. Uses of Transaction Management and ACID Properties of a Transaction.","breadcrumb":{"@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#primaryimage","url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg","contentUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679293039778-Transaction%20in%20DBMS.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/prepbytes.com\/blog\/transaction-in-dbms-examples\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/43.205.93.38\/"},{"@type":"ListItem","position":2,"name":"DBMS","item":"https:\/\/prepbytes.com\/blog\/category\/dbms\/"},{"@type":"ListItem","position":3,"name":"Transaction in DBMS and Examples"}]},{"@type":"WebSite","@id":"http:\/\/43.205.93.38\/#website","url":"http:\/\/43.205.93.38\/","name":"PrepBytes Blog","description":"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING","publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/43.205.93.38\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/43.205.93.38\/#organization","name":"Prepbytes","url":"http:\/\/43.205.93.38\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/","url":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","contentUrl":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","width":160,"height":160,"caption":"Prepbytes"},"image":{"@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/prepbytes0211\/","https:\/\/www.instagram.com\/prepbytes\/","https:\/\/www.linkedin.com\/company\/prepbytes\/","https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA"]},{"@type":"Person","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e","name":"Prepbytes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g","caption":"Prepbytes"},"url":"https:\/\/prepbytes.com\/blog\/author\/gourav-jaincollegedekho-com\/"}]}},"_links":{"self":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/comments?post=14683"}],"version-history":[{"count":3,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14683\/revisions"}],"predecessor-version":[{"id":18568,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14683\/revisions\/18568"}],"wp:attachment":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/media?parent=14683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/categories?post=14683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/tags?post=14683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}