How to rollback the current transaction in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
What is Segment Advisor in Oracle?
Why packages are used in oracle?
What is pragma autonomous transaction in oracle?
Can you assign multiple query result rows to a variable?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
How to execute a stored procedure in oracle?
How to call a stored function with parameters?
What is a cognitive schema?
How can you Enforce Referential Integrity in snapshots ?
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 partitions in oracle?