Answer Posted / sohini
A transaction is a series of SQL data manipulation
statements that does a logical unit of work.DML statements
run between explicit COMMIT,ROLLBACK or when database is
connected or disconnected form a transaction.DDL, DCL and
TCL statements issue autocommit hence they do not form
transaction.Also when one transaction ends another one
starts.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to lock and unlock a user account in oracle?
Explain the use of inctype option in exp command.
What privilege is needed for a user to insert rows to tables in another schema?
How to view the tablespaces in the current database?
How to get last row id?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to write a query with an inner join in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How can we force the database to use the user specified rollback segment?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain joins in oracle?
Whether any commands are used for months calculation? If so, what are they?
Explain alias?
How to use values from other tables in update statements using oracle?