an interview question, is there condition that we operate on one table ....

[raminaa niilian]

Hi
Thank you for reading my post
I have a question which is asked during an interview, can you help me with its answer?

is there condition that we operate on one table with different isolation level?

[Jeanne Boyarsky]

Raminaa,
What do you think? That would provide a good starting point for discussion.

[raminaa niilian]

Thank you for reply.
I think a single operation like delete allways has same level of importance and so it has same transaction level when ever that specific operation happens on that table.

Thanks

[Jeanne Boyarsky]

Your answer makes sense. I interpreted the question a bit differently. I was thinking they meant does it make sense to use different isolation levels at different times.

The nice thing about interview questions is that there is rarely a right or wrong answer. It's more about how you explain it.