Ask a Question

Redo operations are performed exclusively using

in Education by
Redo operations are performed exclusively using (a) Logical logging (b) Physical logging (c) Physical log records (d) Both Physical logging and Physical log records This question was posed to me in an interview for internship. My question is based upon Lock Release and Undo Operations topic in portion Recovery System of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Right choice is (d) Both Physical logging and Physical log records Easiest explanation - Logging of old-value and new-value information is called physical logging.

Related questions

0 votes
Q: Which are the operations can be performed on a document using Elasticsearch?
    Which are the operations can be performed on a document using Elasticsearch?...
asked Jun 3, 2021 in Technology by JackTerrance
0 votes
Q: Can math operations be performed on a void pointer?
    Can math operations be performed on a void pointer?...
asked Jan 22, 2021 in Technology by JackTerrance
0 votes
Q: ___________________ is usually targeted by nature where the emails are exclusively designed to target any exact user.
    ___________________ is usually targeted by nature where the emails are exclusively designed to target any exact user ... Security:,Cyber Security-Jobs:,Cyber Security Applications...
asked Oct 31, 2021 in Education by JackTerrance
0 votes
Q: There are special redo-only log records generated during transaction rollback, called _________ in ARIES.
    There are special redo-only log records generated during transaction rollback, called _________ in ARIES. (a) ... from ARIES in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: __________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
    __________ starts from a position determined during analysis, and performs a redo, repeating history, to ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: ___________ determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
    ___________ determines which transactions to undo, which pages were dirty at the time of the crash, and ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: 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 ... Undo Operations topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: What do you understand by Redo Log file mirroring?
    What do you understand by Redo Log file mirroring?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
Q: Using yq in Front Matter .md files with conditional operations
    I have Front Matter files like this: --- title: BMW i320 M3 150HP Petrol 2020 category: sportscar ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 5, 2022 in Education by JackTerrance
0 votes
Q: What are the general tasks that are performed with backpropagation algorithm?
    What are the general tasks that are performed with backpropagation algorithm? (a) pattern mapping (b) function ... all of the mentioned Please answer the above question....
asked Sep 3, 2022 in Education by JackTerrance
0 votes
Q: Which of the following tasks are not performed by the Election Commission?
    Which of the following tasks are not performed by the Election Commission? (a) Preparing the Electoral Rolls. ... Panchayat elections. Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
Q: What functions are performed by the control unit? Can we call it the control centre
    What functions are performed by the control unit? Can we call it the control centre of computer system? Why? Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: What functions are performed by the control unit? Can we call it the control centre
    What functions are performed by the control unit? Can we call it the control centre of computer system? Why? Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...