| Transaction [message #62770] |
Thu, 12 August 2004 15:46  |
David
Messages: 110
Registered: November 1998
|
Senior Member |
|
|
Anyone know the right answer:
Query is not a transaction. True or False.
Thanks.
|
|
|
|
| Re: Transaction [message #62771 is a reply to message #62770] |
Thu, 12 August 2004 16:00  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
true. I'd say a transaction is from the start of data insert/update/delete to a commit/rollback in that scope. The last few words are to clarify that commit/rollback in an autonomous transaction (in the oracle sense) doesn't count if it occurs in the main transaction.
|
|
|
|
|
|
| Re: Transaction [message #62787 is a reply to message #62771] |
Fri, 13 August 2004 07:59 |
David
Messages: 110
Registered: November 1998
|
Senior Member |
|
|
Thanks a lot, Guys. I remember I ran into this question when I prepared DBA test. When someone asked me again. I forgot the answer.
People who think query is a transaction usually says that query hold some resource until it finishes. It problem needs an official answer that it is just a connection, not a transaction.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
