What is SAVE POINT?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

186. What is SAVE POINT?

For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.

(Continued on next question...)

Other Job Interview Questions

• Audit Trial
• What are the different Levels of Auditing?
• What is a correlated subquery?
• What are the system resources that can be controlled through Profile?
• What are the steps involved in Database Startup?
• What is the maximum number of triggers, can apply to a single table?
• Shall we create procedures to fetch more than one record?
• What is a deadlock and Explain?
• What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
• What is difference between CHAR and VARCHAR2?
• More...