Define Transaction ?

Answers were Sorted based on User's Feedback



Define Transaction ?..

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

Define Transaction ?..

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

Define Transaction ?..

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

Define Transaction ?..

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

Define Transaction ?..

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

Post New Answer

More Oracle General Interview Questions

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  


What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,


Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  


What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,






How to list all tables in your schema?

0 Answers  


Can you drop an index associated with a unique or primary key constraint?

0 Answers  


"primary key=unique+null" is equal,reson?not,reason?

5 Answers  


What are transaction isolation levels supported by oracle?

0 Answers  


What are the attributes of the cursor?

0 Answers  


What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers  


what is a Nested Loop join?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)