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 |
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
What are the types of trigger in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to convert a string to a date in oracle database?
What is a Temporary Segment ?
What is set operator oracle?
Is there any function in oracle similar like group_concat of mysql?
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.
Name the three major set of files on disk that compose a database in Oracle?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain oracle’s server parameter file.