{"id":5045,"date":"2022-10-26T10:07:01","date_gmt":"2022-10-26T10:07:01","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=5045"},"modified":"2022-10-26T10:07:01","modified_gmt":"2022-10-26T10:07:01","slug":"what-is-transaction-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/","title":{"rendered":"What is Transaction in DBMS ?"},"content":{"rendered":"<ul>\n<li style=\"text-align: justify;\">If we need one or more database access operations, we have a logical unit of processing called Database Transaction.<\/li>\n<li style=\"text-align: justify;\">In simple, database transactions represent real-world events of any enterprise.<\/li>\n<li style=\"text-align: justify;\">Database is inconsistent during the transaction.<\/li>\n<li style=\"text-align: justify;\">Database is committed only once the state is changed from one consistent state to another.<\/li>\n<\/ul>\n<h2 id=\"state-of-transactions\" style=\"text-align: justify;\"><strong>State of Transactions<\/strong><\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-5046\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg\" alt=\"\" width=\"650\" height=\"387\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms.jpg 650w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms-300x179.jpg 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/transactions-in-dbms-390x232.jpg 390w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<h3 id=\"active-state\" style=\"text-align: justify;\">Active State<\/h3>\n<ul style=\"text-align: justify;\">\n<li>A transaction is said to be in an active state when the execution process begins.<\/li>\n<li>This is the state where read write operations are performed.<\/li>\n<\/ul>\n<h3 id=\"partially-committed\" style=\"text-align: justify;\">Partially Committed<\/h3>\n<ul style=\"text-align: justify;\">\n<li>A Transaction is said to be in a partially committed state after the end of a transaction.<\/li>\n<\/ul>\n<h3 id=\"committed-state\" style=\"text-align: justify;\">Committed State<\/h3>\n<ul style=\"text-align: justify;\">\n<li>When a transaction is executed successfully, transaction is said to be in the committed state.<\/li>\n<li>Changes made are recorded in the database permanently.<\/li>\n<\/ul>\n<h3 id=\"failed-state\" style=\"text-align: justify;\">Failed State<\/h3>\n<ul style=\"text-align: justify;\">\n<li>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<h3 id=\"terminated-state\" style=\"text-align: justify;\">Terminated State<\/h3>\n<ul style=\"text-align: justify;\">\n<li>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<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>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\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-transaction-in-dbms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-transaction-in-dbms\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What is Transaction in DBMS ?\",\"datePublished\":\"2022-10-26T10:07:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-transaction-in-dbms\\\/\"},\"wordCount\":184,\"commentCount\":0,\"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\",\"keywords\":[\"acid properties in dbms\",\"acid properties of transaction in dbms\",\"concurrent execution of transaction in dbms\",\"dbms transaction\",\"dbms transaction property\",\"how to process the transaction in dbms\",\"state of transaction in dbms\",\"transaction in dbms\",\"transaction management in dbms\",\"types of transaction in dbms\",\"what are the properties of transaction in dbms\",\"what is transaction in dbms\",\"what is transaction in dbms with example\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-transaction-in-dbms\\\/#respond\"]}]},{\"@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\",\"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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"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","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What is Transaction in DBMS ?","datePublished":"2022-10-26T10:07:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/"},"wordCount":184,"commentCount":0,"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","keywords":["acid properties in dbms","acid properties of transaction in dbms","concurrent execution of transaction in dbms","dbms transaction","dbms transaction property","how to process the transaction in dbms","state of transaction in dbms","transaction in dbms","transaction management in dbms","types of transaction in dbms","what are the properties of transaction in dbms","what is transaction in dbms","what is transaction in dbms with example"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-transaction-in-dbms\/#respond"]}]},{"@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","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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","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}]}}