State of Transactions<\/strong><\/h2>\n![\"\"](\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\")
<\/p>\n
Active State<\/h3>\n\n- A transaction is said to be in an active state when the execution process begins.<\/li>\n
- This is the state where read write operations are performed.<\/li>\n<\/ul>\n
Partially Committed<\/h3>\n\n- A Transaction is said to be in a partially committed state after the end of a transaction.<\/li>\n<\/ul>\n
Committed State<\/h3>\n\n- When a transaction is executed successfully, transaction is said to be in the committed state.<\/li>\n
- Changes made are recorded in the database permanently.<\/li>\n<\/ul>\n
Failed State<\/h3>\n\n- A transaction is considered to be in the failed state when any one of the checks fails, or when the transaction is aborted while it is in the active state.<\/li>\n<\/ul>\n
Terminated State<\/h3>\n\n- A transaction is said to be in the terminated state when certain transactions which are leaving the system cannot be restarted.<\/li>\n<\/ul>\n
\n
\n","protected":false},"excerpt":{"rendered":"
If we need one or more database access operations, we have a logical unit of processing called Database Transaction. In simple, database transactions represent real-world events of any enterprise. Database is inconsistent during the transaction. Database is committed only once the state is changed from one consistent state to another. State of Transactions Active State […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[17398,17402,19017,19010,19011,19013,19016,7226,17405,19018,19015,19012,19014],"class_list":["post-5045","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-acid-properties-in-dbms","tag-acid-properties-of-transaction-in-dbms","tag-concurrent-execution-of-transaction-in-dbms","tag-dbms-transaction","tag-dbms-transaction-property","tag-how-to-process-the-transaction-in-dbms","tag-state-of-transaction-in-dbms","tag-transaction-in-dbms","tag-transaction-management-in-dbms","tag-types-of-transaction-in-dbms","tag-what-are-the-properties-of-transaction-in-dbms","tag-what-is-transaction-in-dbms","tag-what-is-transaction-in-dbms-with-example"],"yoast_head":"\n
What is Transaction in DBMS ? - DBMS Transaction Property<\/title>\n<meta name=\"description\" content=\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database 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:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Transaction in DBMS ? - DBMS Transaction Property\" \/>\n<meta property=\"og:description\" content=\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-26T10:07:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\",\"name\":\"What is Transaction in DBMS ? - DBMS Transaction Property\",\"isPartOf\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"datePublished\":\"2022-10-26T10:07:01+00:00\",\"dateModified\":\"2022-10-26T10:07:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"contentUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"width\":650,\"height\":387},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\/\/www.wikitechy.com\/interview-questions\"],\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Transaction in DBMS ? - DBMS Transaction Property","description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database 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:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is Transaction in DBMS ? - DBMS Transaction Property","og_description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-10-26T10:07:01+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg"}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","name":"What is Transaction in DBMS ? - DBMS Transaction Property","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","datePublished":"2022-10-26T10:07:01+00:00","dateModified":"2022-10-26T10:07:01+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","width":650,"height":387},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=5045"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045\/revisions"}],"predecessor-version":[{"id":5047,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045\/revisions\/5047"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=5045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=5045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=5045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n- \n
- A transaction is said to be in an active state when the execution process begins.<\/li>\n
- This is the state where read write operations are performed.<\/li>\n<\/ul>\n
Partially Committed<\/h3>\n
- \n
- A Transaction is said to be in a partially committed state after the end of a transaction.<\/li>\n<\/ul>\n
Committed State<\/h3>\n
- \n
- When a transaction is executed successfully, transaction is said to be in the committed state.<\/li>\n
- Changes made are recorded in the database permanently.<\/li>\n<\/ul>\n
Failed State<\/h3>\n
- \n
- A transaction is considered to be in the failed state when any one of the checks fails, or when the transaction is aborted while it is in the active state.<\/li>\n<\/ul>\n
Terminated State<\/h3>\n
- \n
- A transaction is said to be in the terminated state when certain transactions which are leaving the system cannot be restarted.<\/li>\n<\/ul>\n
\n
\n","protected":false},"excerpt":{"rendered":"
If we need one or more database access operations, we have a logical unit of processing called Database Transaction. In simple, database transactions represent real-world events of any enterprise. Database is inconsistent during the transaction. Database is committed only once the state is changed from one consistent state to another. State of Transactions Active State […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[17398,17402,19017,19010,19011,19013,19016,7226,17405,19018,19015,19012,19014],"class_list":["post-5045","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-acid-properties-in-dbms","tag-acid-properties-of-transaction-in-dbms","tag-concurrent-execution-of-transaction-in-dbms","tag-dbms-transaction","tag-dbms-transaction-property","tag-how-to-process-the-transaction-in-dbms","tag-state-of-transaction-in-dbms","tag-transaction-in-dbms","tag-transaction-management-in-dbms","tag-types-of-transaction-in-dbms","tag-what-are-the-properties-of-transaction-in-dbms","tag-what-is-transaction-in-dbms","tag-what-is-transaction-in-dbms-with-example"],"yoast_head":"\n
What is Transaction in DBMS ? - DBMS Transaction Property<\/title>\n<meta name=\"description\" content=\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database 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:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Transaction in DBMS ? - DBMS Transaction Property\" \/>\n<meta property=\"og:description\" content=\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-26T10:07:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\",\"name\":\"What is Transaction in DBMS ? - DBMS Transaction Property\",\"isPartOf\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"datePublished\":\"2022-10-26T10:07:01+00:00\",\"dateModified\":\"2022-10-26T10:07:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"contentUrl\":\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\",\"width\":650,\"height\":387},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#website\",\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\/\/www.wikitechy.com\/interview-questions\"],\"url\":\"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Transaction in DBMS ? - DBMS Transaction Property","description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database 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:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is Transaction in DBMS ? - DBMS Transaction Property","og_description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-10-26T10:07:01+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg"}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","name":"What is Transaction in DBMS ? - DBMS Transaction Property","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","datePublished":"2022-10-26T10:07:01+00:00","dateModified":"2022-10-26T10:07:01+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is Transaction in DBMS ? - If we need one or more database access operations, we have a logical unit of processing called Database Transaction.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg","width":650,"height":387},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=5045"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045\/revisions"}],"predecessor-version":[{"id":5047,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5045\/revisions\/5047"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=5045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=5045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=5045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- A transaction is said to be in the terminated state when certain transactions which are leaving the system cannot be restarted.<\/li>\n<\/ul>\n
- A transaction is considered to be in the failed state when any one of the checks fails, or when the transaction is aborted while it is in the active state.<\/li>\n<\/ul>\n
- A Transaction is said to be in a partially committed state after the end of a transaction.<\/li>\n<\/ul>\n