Interested to Buy Any Domain ? << Click Here >> for more details...
Define Transaction ?
- 5 Answers
- 10758 Views
- I also Faced
- E-Mail Answers
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 an Oracle Instance?
what is host string in sql plus? how does it related to database?
How can I create database in oracle?
How to specify default values in insert statement using oracle?
Can objects of the same Schema reside in different tablespaces.?
Explain the difference between a procedure and a function?
how do get database name at sql prompt?
How to create tables for odbc connection testing?
How many anonymous blocks can be defined?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
what is load balancing and what u have used to do this?(sql loader)
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Oracle General 
