Bissoy.com
Doctors Medicines MCQs Q&A

To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.

To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation. Correct Answer Consistent

Data structures such as B+-trees would not be in a consistent state, and neither logical redo nor logical undo operations can be performed on an inconsistent data structure.

Related Questions

Consider a Simple Checkpointing Protocol and the following set of operations in the log. (start, T4); (write, T4, y, 2, 3); (start, T1); (commit, T4); (write, T1, z, 5, 7); (Checkpoint); (start, T2); (write, T2, x, 1, 9); (commit, T2); start, T3); (write, T3, z, 7, 2); if a crash happens now and the system tries to recover using both undo and redo operations, what are the contents of the undo list and the redo list?
Consider a simple checkpointing protocol and the following set of operations in the log. (start, T4); (write, T4, y, 2, 3); (start, T1); (commit, T4); (write, T1, z, 5, 7); (checkpoint); (start, T2); (write, T2, x, 1, 9); (commit, T2); (start, T3), (write, T3, z, 7, 2); If a crash happens now and the system tries to recover using both undo and redo operations, what are the contents of the undo list and the redo list?
Which of the given options best describes the truthfulness of the following statements? (i) Ctrl + Y is used to perform "undo" operation in MS-Word. (ii) Ctrl + Z is used to perform "redo" operation in MS-Word. iii) Ctr l+ E  is used to Center the text
Which of the given options best describes the truthfulness of the following statements? (i) Ctrl + Y is used to perform "undo" operation in MS-Word. (ii) Ctrl + Z is used to perform "redo" operation in MS-Word.
If u (x, y, z, t) = f(x + iβy - vt) + g(x - iβy - vt), where f and g are arbitrary and twice differentiable functions, is a solution of the wave equation $$\frac{{\partial {u^2}}}{{\partial {x^2}}} = \frac{{{\partial ^2}u}}{{\partial {y^2}}} = \frac{1}{{{c^2}}}\frac{{{\partial ^2}u}}{{\partial {t^2}}}$$     then β is
Six students of a school – Radha, Raj, Rahul, Mira, Aarav and Arijit are selected from different classes – 7th, 8th, 9th, 10th, 11th and 12th standards (not necessarily in the same order) to perform individually in the school annual function. Their order of performances is decided as per their classes. The one who is in 12th class will perform first, then after that 11th class student will perform and so on. Mira will perform immediate after the Rahul but before Arijit. Mira does not study in 8th class. Raj will perform immediate after Aarav but Raj neither studies in 8th class nor in 7th class. Who will perform last in the school annual function?
Consider the following with reference to Article 18? (a) No title, not being a military or academic distinction, shall be conferred by the State. (b) The citizen of India shall accept any title from any foreign State. (c) No person who is not a citizen of India shall, while he holds any office of profit or trust under the State, accept without the consent of the President any title from any foreign State. (d) The person holding any office of profit or trust under the State shall, without the consent of the President, accept any present, emolument, or office of any kind from or under any foreign State.
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
For correct behaviour during recovery, undo and redo operation must be
If ___________ are not obtained in undo operation it will cause problem in undo-phase.