What are the uses of Rollback Segment ?
Answers were Sorted based on User's Feedback
Answer / swapna
It is used to revoke transactions from hardware device.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / paresh
It is used to revoke transactions from hardware device.What
ever u change in statement If u not commite u rollback the
previous statement.
| Is This Answer Correct ? | 3 Yes | 1 No |
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is control file used for?
What is BBED in Oracle?
what are the things that you consider while creating indexes on partitioning tables?
How to add another datafile to a tablespace?
How to pass a cursor variable to a procedure?
List out the components of logical database structure of oracle database.
How do I uninstall oracle client from windows?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is the difference between normal and corelated subqueries?
What happens if variable names collide with table/column names?