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
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
When do you get a .pll extension in oracle?
How to write a left outer join with the where clause in oracle?
Can sub procedure/function be called recursively?
How to list all user accounts in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is an oracle function?
How to create a table interactively?
How can we force the database to use the user specified rollback segment?
How a database is related to tablespaces?
Name the three major set of files on disk that compose a database in Oracle?
Is a rollback possible to any savepoint?
How to write a query with a left outer join in oracle?
What is a data dictionary and how can it be created?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.