Can you have a nested transaction?
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 |
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
can you give me the syntax of named procedure??
What is a self join? Explain it with an example?
What is denormalization and when would you go for it?
What are the three types of database design?
What are the key features of dbms?
Explain about the database management systems.
How to create an external table.
Write short notes on manual refreshes.
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about a primary key?
How can I detect whether a given connection is blocked?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)