Ask a Question

The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.

in Education by
The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction. (a) Validation protocol (b) Validation-based protocol (c) Timestamp protocol (d) Timestamp-ordering protocol This question was addressed to me in semester exam. Question is taken from Multiple Granularity topic in section Concurrency Control of Database Management

1 Answer

0 votes
by
The correct answer is (a) Validation protocol The best explanation: A concurrency-control scheme imposes the overhead of code execution and possible delay of transactions. It may be better to use an alternative scheme that imposes less overhead.

Related questions

0 votes
Q: When a transaction Ti attempts to update a data item, it requests a _________ on that data item.
    When a transaction Ti attempts to update a data item, it requests a _________ on that data item. ... Snapshot Isolation topic in chapter Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.
    If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ... Based Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: State true or false: SAP systems are divided into different clients depending on business requirement, the data can be accessed within the client only.
    State true or false: SAP systems are divided into different clients depending on business requirement, the data can be accessed within the client only. A. True B. False...
asked Feb 20, 2023 in Technology by JackTerrance
0 votes
Q: Suppose you have three Jobs of which Jobs 1 and 2 are executed parallelly. Job 3 executes only after Jobs 1 and 2 complete their execution. Which of the following components can be used to set this up?
    Suppose you have three Jobs of which Jobs 1 and 2 are executed parallelly. Job 3 executes only after Jobs 1 and ... can be used to set this up? tUnite tPostJob tRunJob tParallelize...
asked Mar 24, 2021 in Technology by JackTerrance
0 votes
Q: An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
    An Oracle __________ is a set of tables and views that are used as a read-only reference about the ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Read the following statement carefully and find out whether it is correct about the hacking or not?
    Read the following statement carefully and find out whether it is correct about the hacking or not? It can be possible that ... some cases, it can be referred to as a legal task...
asked Mar 4, 2021 in Technology by JackTerrance
0 votes
Q: __________ read only parameter that returns the width and height of the current device surface in inches.
    __________ read only parameter that returns the width and height of the current device surface in inches. (a) Din ... of R Programming Select the correct answer from above options...
asked Feb 10, 2022 in Education by JackTerrance
0 votes
Q: Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
    Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: B-link tree requires a pointer to its __________ sibling.
    B-link tree requires a pointer to its __________ sibling. (a) Upper (b) Lower (c) Right (d) ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: When a server requires special configuration beyond that covered by the automated deployment scripts, it is called __________
    When a server requires special configuration beyond that covered by the automated deployment scripts, it is ... Snowflake Server Configuration Drift Server Sprawl Automation Fear...
asked Sep 15, 2021 in Technology by JackTerrance
0 votes
Q: Function with different behavior depending on amount of input args
    I want to create a function which will check if it is a correct hour to make an action, but I ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 22, 2022 in Education by JackTerrance
0 votes
Q: The….. becomes different shapes depending on the task you are performing.
    The .. becomes different shapes depending on the task you are performing. (a) Active tab (b) Insertion point (c) ... (e) None of above Select the correct answer from above options...
asked Dec 12, 2021 in Education by JackTerrance

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

...