in Education by
The time to process the remote backup can be reduced by (a) Flags (b) Breakpoints (c) Redo points (d) Checkpoints I got this question during an interview for a job. My question is from Remote Backup Systems 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
Correct choice is (d) Checkpoints Explanation: If the log at the remote backup grows large, recovery will take a long time. The remote backup site can periodically process the redo log records that it has received and can perform a checkpoint, so that earlier parts of the log can be deleted.

Related questions

0 votes
    Remote backup system must be _________ with the primary site. (a) Synchronised (b) Separated (c) ... Backup Systems topic in chapter Recovery System of Database Management...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The remote backup site is sometimes also called the (a) Primary Site (b) Secondary Site (c) Tertiary ... Backup Systems topic in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    False minima can be reduced by deterministic updates? (a) yes (b) no This question was posed to me in ... Neural Networks of Neural Networks Please answer the above question....
asked Aug 27, 2022 in Education by JackTerrance
0 votes
    Read overhead in a Columnar database can be partly reduced by Multicolumnprojection and _____________....
asked Jan 26, 2021 in Technology by JackTerrance
0 votes
    A 200/1 Current Transformer (CT) is wound with 400 turns on the secondary on a toroidal core. When it carries ... for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 17, 2021 in Education by JackTerrance
0 votes
    How can false minima be reduced in case of error in recall in feedback neural networks? (a) by providing additional ... (d) none of the mentioned Please answer the above question....
asked Sep 3, 2022 in Education by JackTerrance
0 votes
    Can probability of error in recall be reduced? (a) yes (b) no This question was addressed to me during ... Neural Networks of Neural Networks Please answer the above question....
asked Sep 3, 2022 in Education by JackTerrance
0 votes
    Can probability of error in recall be reduced? (a) yes (b) no This question was addressed to me during ... Neural Networks of Neural Networks Please answer the above question....
asked Aug 30, 2022 in Education by JackTerrance
0 votes
    Can error in recall due to false minima be reduced? (a) yes (b) no I have been asked this question ... Feedback Neural Networks of Neural Networks Please answer the above question....
asked Aug 30, 2022 in Education by JackTerrance
0 votes
    How can error in recall due to false minima be reduced? (a) deterministic update for states (b) stochastic update ... (d) none of the mentioned Please answer the above question....
asked Aug 30, 2022 in Education by JackTerrance
0 votes
    Probability of error in recall of stored patterns can be reduced if? (a) patterns are stored appropriately (b) inputs ... d) none of the mentioned Please answer the above question....
asked Aug 27, 2022 in Education by JackTerrance
0 votes
    Viewed from the terminals A and B the circuit given below can be reduced to an equivalent circuit with a single ... GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 12, 2021 in Education by JackTerrance
0 votes
    A _______________ configuration can make takeover by the backup site almost instantaneous. (a) Hot-spare (b ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Suppose the user finds the usage of room number and phone number in a relational schema there is confusion ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The backup is taken by (a) Erasing all previous records (b) Entering the new records (c) Sending ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
...