Answer Posted / kiran
when ever a user performs commit action , the data is
permanently written the the tablespace and cannot be rolled
back
after performing the commit operation , the users in other
user sessions can view only the committed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do we display rows from the table without duplicates?
In oracle there is column command, how will you explain that?
How to start a specific oracle instance?
How to delete multiple rows from a table in oracle?
How to login to the server without an instance?
What is the difference between substr and instr?
How to create a table index in oracle?
What is raw datatype in oracle?
Point out the difference between user tables and data dictionary?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the set operators union, union all, minus & intersect meant to do?
What are the uses of synonyms?
How oracle handles dead locks?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Please explain drop constraint oracle?
