• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which of the following statement will not implicitly begin a transaction

 
sam liya
Ranch Hand
Posts: 1240
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


this question i got from paper.It gives answer as a,b and c.
anyway then why d doesn't get as a answer?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this question about a specific database? I ask because the answer given is not universally applicable to all RSBMSs (for example, if the database is SQL Server or MySQL's MyISAM database engine none of the available answers are correct).

 
sam liya
Ranch Hand
Posts: 1240
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
no,this is not specific any database?
 
Tanzy Akhtar
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not very sure, But as per simple logic,
read operation (that is SELECT) does not change the state of the database.

Hence it should not be the part of any transaction.

Please correct me if my guess is wrong.


Thanks,
Tanzy.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic