What is a Transaction in Oracle - A transaction is a Logical unit of work that compromises one or more SQL Statements executed by a single User. According to ANSI, a transaction begins with first executable statement and ends when it is explicitly committed or rolled back.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What is a Transaction in Oracle

Answer: A transaction is a Logical unit of work that compromises one or more SQL Statements executed by a single User. According to ANSI, a transaction begins with first executable statement and ends when it is explicitly committed or rolled back.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6831 users
Added on	9/18/2014
Views	68575
Rate it!

Question: What is a Transaction in Oracle

Answer:

A transaction is a Logical unit of work that compromises one or more SQL Statements executed by a single User. According to ANSI, a transaction begins with first executable statement and ends when it is explicitly committed or rolled back. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	How many types of Sql Statements are there in Oracle?	View Answer
	What are the Back ground processes in Oracle and what are they?	View Answer
	If a View on a single base table is manipulated will the changes be reflected on the base table ?	View Answer
	What is a join ? Explain the different types of joins ?	View Answer
	What is Referential Integrity ?	View Answer
	How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?	View Answer
	What is the Subquery ?	View Answer
	What is difference between TRUNCATE & DELETE ?	View Answer
	How do you find the numbert of rows in a Table ?	View Answer
	What is use of a cursor variable? How it is defined?	View Answer
	What is difference between UNIQUE and PRIMARY KEY constraints?	View Answer
	Difference between database triggers and form triggers?	View Answer
	How will you delete duplicating rows from a base table?	View Answer
	When do you use WHERE clause and when do you use HAVING clause?	View Answer
	How you open and close a cursor variable. Why it is required?	View Answer
	What is OCI. What are its uses?	View Answer
	What is the purpose of a cluster?	View Answer
	Difference between an implicit & an explicit cursor.?	View Answer
	What is difference between Rename and Alias?	View Answer
	What are various joins used while writing SUBQUERIES?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode