When does a Transaction end ?

Answers were Sorted based on User's Feedback



When does a Transaction end ?..

Answer / kumar

Transaction ends with COMMIT or ROLLBACK keywords.

Is This Answer Correct ?    8 Yes 1 No

When does a Transaction end ?..

Answer / bas

when ever commit or rollback statement occurred in the end
of trasaction

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More Oracle General Interview Questions

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,


I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  


What are the components of Logical database structure of ORACLE database?

4 Answers  


how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,


What is the quickest way to export a table to a flat file?

0 Answers  






Can sub procedure/function be called recursively?

0 Answers  


Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,


which language is used to develop the oracle........?

4 Answers   Infosys,


how the indexes are stored in the Oracle Database?

0 Answers  


What is the difference between normal and corelated subqueries?

2 Answers  


How you open and close a cursor variable.Why it is required?

2 Answers  


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)