Answer Posted / 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 |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
State the various uses of dbcc command?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain about the analyze command in oracle?
State any two functions of oracle?
Can the query output be sorted by multiple columns in oracle?
What is oracle analytical function?
How to load data through external tables?
Please explain compound trigger in oracle?
What is a nested table and how is it different from a normal table?
What are the database administrators utilities available?
How many types of tables supported by oracle?
How to export data to a csv file?
What is a named program unit?
What is a initialization parameter file in oracle?