Can you have a nested transaction?
- 1 Answers
- 2506 Views
- I also Faced
- E-Mail Answers
Answer / abinash
yes we can have nested transaction.
A transaction is nothing a set of sql statement which either executes at a time or nothing will happen and we specify the transaction using Begin and End.
And also we can have multiple begin end (nested transaction) inside a transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
Write short notes on manual refreshes.
Explain about relational database management systems?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
fact table and dimension table containg one to many relationship or many to one relastionship
How to use timestamp datatypes
Explain about a primary key?
What are the three types of database design?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
what is the use of foreginkey
Why does this query return 0?
What are cursors? Explain different types of cursors?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
