Oracle Interview Questions -4Tuesday, March 25, 2014
Oracle Interview Questions -4
Extracted Page: http://www.gcreddy.net/2013/01/oracle-interview-questions-4.html
Q.Explain the steps executed during a typical transaction.
•A transaction contains one or more SQL statements.
•It is an atomic unit.
•It begins with the first executable SQL statement.
•It ends when it is committed or rolled back.
•The effects of all the SQL statements in a transaction can be either all committed or all rolled back.
Q.Explain the steps executed during SQL statement processing.
A.Steps in Processing SQL Statements
Define an application request
For DML statements and queries with input variables, perform one or more bi
Additional text has been truncated due to copyright reasons. Things without URLs and private things don't get truncated.