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
What is a view and how is it different from a table?
What is oracle join syntax?
Explain overloading. Can functions be overloaded?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to shutdown your 10g xe server?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How can I introduce multiple conditions in like operator?
What is the Tune Query
What are the different types of record groups in oracle? Explain each of them
What are the data types in oracle?
What are the numeric comparison operations?
What is index in Oracle?
What is difference between truncate and delete?
what is the dual table in oracle?
Can group functions be mixed with non-group selection fields?