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
How to invoke the original export import utilities?
does the query needs a hint to access a materialized view?
What is meant by joins? List out the types of joins.
Name the various constraints used in oracle?
How to recover a dropped table in oracle?
what is insert all statement in sql
What is transport network substrate (tns) in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to specify default values in insert statement using oracle?
Can group functions be used in the order by clause in oracle?
State and explain the different types of data models?
Explain the use of Merge statement in oracle 11g
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to run create database statement again?
1) Does oracle have any table which contain all the exceptions and it's code internally?