Register

GATE CSE 2024 | Set 2 | Question: 9

• edited by
2,732 views
4 votes
4 votes

​​​​​Once the $\text{DBMS}$ informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes are reflected on disk. This property is called

  1. durability
  2. atomicity
  3. consistency
  4. isolation
• edited by
User Avatar

2 Answers

4 votes
4 votes
ACID: Durability

• Changes to database made by committed transaction must persist in spite of any failure.

(Responsibility of the Recovery System.)
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

2.5k
views
1 answers
3 votes
Arjun asked Feb 16
2,546 views
GATE CSE 2024 | Set 2 | Question: 17
Which of the following statements about the Two Phase Locking ($2 \mathrm{PL}$) protocol is/are TRUE?$2 \mathrm{PL}$ permits only serializable ... can be obtained inside that transactionA deadlock is possible with $2 \mathrm{PL}$
User Avatar
2.7k
views
2 answers
4 votes
Arjun asked Feb 16
2,705 views
GATE CSE 2024 | Set 2 | Question: 10
In the context of owner and weak entity sets in the $\text{ER}$ (Entity-Relationship) data model, which one of the following statements is ... entity set nor owner entity set MUST have total participation in the identifying relationship
User Avatar
3.0k
views
2 answers
5 votes
Arjun asked Feb 16
3,013 views
GATE CSE 2024 | Set 2 | Question: 16
​​​​​Which of the following file organizations is/are $\text{I/O}$ efficient for the scan operation in $\text{DBMS}$?SortedHeapUnclustered tree indexUnclustered hash index
User Avatar
3.3k
views
2 answers
6 votes
Arjun asked Feb 16
3,274 views
GATE CSE 2024 | Set 2 | Question: 35
The relation schema, Person (pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operators are ... $2$3$4$
User Avatar
Link Copied!