Define Transaction ?
Answers were Sorted based on User's Feedback
Answer / satyaki_raju@yahoo.com
A transaction is a particular type of external event which
can be expressed in terms of money and brings change in
financial position of a business unit.A transaction
involves transfer of something of value between two or more
entities.A transaction may be in exchange in which each
party receives as well as sacrifices value.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rati srivastava
transaction have the property that if they are interrupted
before they complete the database will restore to a self
consistent state usually the one before the transaction
began.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gvmahesh
transaction is a kind of physical work that is done againist
to the database by using logical operations.
this means if we want to make any changes on existing data
then we done some transactions through DML
commands(INSERT,DELETE,UPDATE)
we done any transactions all the changing data should be in
rollback segment area untill we commited that data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / guest
Transaction is an list of commands given in oracle.
which includes DDL,DML,DCL,TCL,DSL
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / sohini
A transaction is a series of SQL data manipulation
statements that does a logical unit of work.DML statements
run between explicit COMMIT,ROLLBACK or when database is
connected or disconnected form a transaction.DDL, DCL and
TCL statements issue autocommit hence they do not form
transaction.Also when one transaction ends another one
starts.
| Is This Answer Correct ? | 3 Yes | 2 No |
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is transaction control statement and how many types of transaction control statement in Oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Is there an oracle sql query that aggregates multiple rows into one row?
What is the exact use of Collections?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Explain oracle instance.
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Explain an exception and its types?
What happens to indexes if you drop a table?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
How to use subqueries with the exists operator in oracle?