Interview Questions for Java | C++ | Testing | ASP.NET | Cobol | Mainframe | Oracle Database

Add comment

Q: Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?
ALL DDL statements are auto-commit. That means whenever you execute a DDL statement, all prior transactions get commited. Please note that the commit is issued before excuting the DDL. So even if the DDL statement errors out, commit would have happened.

Q: Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?