Answer Posted / 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 |
Post New Answer View All Answers
What is flashback in Oracle?
Differentiate between pre-select and pre-query?
How to assign data of the deleted row to variables?
What is the difference between alert log file and tarce file ?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is a lookup table in oracle?
How to pass parameters to procedures?
What is meant by joins? List out the types of joins.
Why do we use coalesce function in oracle?
How do we get field details of a table?
What is a parameter file in oracle?
How to open and close an explicit cursor in oracle?
Can we write dml statement in function in oracle?
What is ceil and floor in oracle?
How to generate query output in html format?