Interested to Buy Any Domain ? << Click Here >> for more details...
What does COMMIT do ?
- 4 Answers
- 10710 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
COMMIT makes permanent the changes resulting from all SQL
statements in the transaction. The changes made by the SQL
statements of a transaction become visible to other user
sessions transactions that start only after transaction is
committed.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kiran
when ever a user performs commit action , the data is
permanently written the the tablespace and cannot be rolled
back
after performing the commit operation , the users in other
user sessions can view only the committed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sikdar
Commit is a TCL command which is used to make database
transaction parmanent.
The data is commited but it can't be rollbacked.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / annu rajput
Commit is a TCL command which is used to make database
transaction parmanent.
one the data is commited it can't be rollbacked.
Thanks
Annu Rajput
| Is This Answer Correct ? | 5 Yes | 3 No |
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Explain oracle data types with examples?
What is ceil and floor in oracle?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
what is the difference between sql& oracle?
How many types of table in Oracle?
defination of bitmap index
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
 How to use an oracle sequence generator in a mapping?
How to execute a stored procedure in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Oracle General 
