InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If You Insert A Row In A Table, Then Create Another Table And Then Say Rollback. In This Case Will The Row Be Inserted ? |
|
Answer» Yes. Because CREATE table is a DDL which commits automatically as SOON as it is executed. The DDL commits the transaction even if the create statement fails INTERNALLY (EG table already exists error) and not syntactically. Yes. Because Create table is a DDL which commits automatically as soon as it is executed. The DDL commits the transaction even if the create statement fails internally (eg table already exists error) and not syntactically. |
|