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
What is a data lock in oracle?
What is BBED in Oracle?
How to use "in" parameter properly?
How to create a new table in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is ADDM Advisor in Oracle?
What is the difference between a primary key & a unique key?
Which is better Oracle or MS SQL? Why?
what are bitmap indexes? How does they work?
Explain the use of consistent option in exp command.
How to start a new transaction in oracle?
How to view all columns in an existing table?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain what are synonyms used for?
How do I call oracle stored procedures that take no parameters?