can a schedule cascade Rollback and still be not recoverable. I mean if transactions can rollback then shouldn’t it be recoverable?
I think it is only possible in one scenario wherein if we consider a schedule(system of multiple transactions) such that, few set of transaction have tendency to cascade rollback whereas there exists other few sets which are non-recoverable as well as do not cascade rollback.
Only then i think the statement “that a schedule can cascade rollback and be non-recoverable at the same time” makes sense. AM I right??
And then follow up this question https://gateoverflow.in/299764/virtual-gate-test-series-databases-schedule?show=299770
I think only option 1 and 2 are correct.