What happens to the current transaction if the session is ended?



What happens to the current transaction if the session is ended?..

Answer / Gaurav Singhal

If a session ends, the current transaction remains open. However, once all sessions that are connected to the transaction end, the transaction will be automatically committed or rolled back depending on its status.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,


20. Using a set operator, display the client number of all clients who have never placed an order.

1 Answers   Wipro,


Can the query output be sorted by multiple columns in oracle?

1 Answers  


what is the syntax of update command?

3 Answers   Semantic Space,


What is the data pump import utility?

1 Answers  


what is data abstraction

3 Answers   Semantic Space,


What is RULE-based approach to optimization ?

1 Answers  


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1 Answers  


What is the difference between translate and replace?

1 Answers  


Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

1 Answers  


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)