Properties of a transaction , Database Management System

Properties of a Transaction       

A transaction has four main properties. These are:

  • Atomicity
  • Consistency
  • Isolation or Independence
  • Durability or Permanence


Posted Date: 3/11/2013 5:19:46 AM | Location : United States

Related Discussions:- Properties of a transaction , Assignment Help, Ask Question on Properties of a transaction , Get Answer, Expert's Help, Properties of a transaction Discussions

Write discussion on Properties of a transaction
Your posts are moderated
Related Questions
What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

What is D command work in the respect of QBE? D: It is the command inside QBE to delete tuple(s) from the relation.

What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

Benefits and Limitations od Data Models?

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR