What is a transaction, Database Management System

What is a Transaction?

A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If you have any method of Operating Systems, then we can say that a transaction is analogous to processes.

 

Posted Date: 7/26/2013 7:03:03 AM | Location : United States







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

Write discussion on What is a transaction
Your posts are moderated
Related Questions
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)

Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

what is lossless & dependency preserving decomposition ?

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

What is the difference between SQL Server 2000 clustered and nonclustered indexes? With a clustered index, the data are kept in the bottom level of the index and in the similar

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict