Define Transaction ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dynamic proxy?

546


How to assign a table row to a record variable?

575


How to assign query results to variables?

585


How to filter out duplications in the returning rows using oracle?

633


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1793






Explain user account with reference to oracle.

524


Is oracle a language?

515


What is set verify off in oracle?

568


What language does oracle use?

591


What happens if you use a wrong connect identifier?

496


Explain oracle’s server parameter file.

562


What is the difference between primary key and unique key and foreign key in oracle?

544


How do I connect to oracle?

557


How to assign a tablespace to a users in oracle?

585


What is blob data type in oracle?

552