Answer Posted / ashok
All the DML operations between two COMMIT points can be called as a Transaction and Oracle server handles this as a single unit
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of database management systems?
What are the different dml commands in sql?
Do we need to create index on primary key?
What is sharding in sql?
Difference between table function and pipelined function?
How long it takes to learn pl sql?
What is sql injection vulnerability?
What is sqlite used for?
When are we going to use truncate and delete?
How do you bind variables in pl sql?
How to combine two stored procedures in sql?
difference between anonymous blocks and sub-programs.
Which is faster union or join?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How sql query is executed?