Which of the following statements are true?
i) Changes in data done by execution of an instruction of a transaction are directly stored in the database.
ii) Database in committed & aborted state of the transaction is always consistent.
iii) Phantom read problem during concurrency of transactions is about not finding a variable.
iv) Normalization is the solution to the redundancy problem.
i, iv
ii, iii, iv
i, iii, iv
i, ii
Boost your performance with adaptive practice tests
Practice every concept in the syllabus
Compare your speed and accuracy with your peers
Download the app and practice on the go