i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?
- 5 Answers
- 6104 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shrikant
After any DDL statement commit will happen by default. So
after any DML statement if you execute DDL satement then
everything is commited.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / debashish mohanty
1.After Successful table creation the deletion are not be committed.
2.Delete is a DML operation its not auto committed.
3.There is no dependency between deleting rows and creation of table.
4.May be the Question is totally wrong else am Screwed to answer this kind of Questions.
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / mohit singla
Deletion won't be commit. Also if our table is created
successfully and we are using rollback even then it won't
fetch the delete statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an oracle data file?
What is the exact use of Collections?
definition of cluster and non-clustered index?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
How to create a new view in oracle?
How to unlock the sample user account in oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
What is an Oracle sequence?
How to insert multiple rows with one insert statement in oracle?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
List out the components of logical database structure of oracle database.
Oracle General 
