@

Dark Mode

Profile
Edit my Profile
Messages
My favorites

Register

Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams

Dark Mode

GATE CSE 2024 | Set 2 | Question: 9

Arjun asked in Databases Feb 16 edited Feb 21 by makhdoom ghaya

1,945 views

1 vote

1 vote

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

durability
atomicity
consistency
isolation

gatecse2024-set2
databases
transaction-and-concurrency

Arjun asked in Databases Feb 16 edited Feb 21 by makhdoom ghaya

by Arjun

1.9k views

0 Comments

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

1 vote

1 vote

A.

Durability

supreetshukla answered Feb 16

by supreetshukla

0 Comments

Please log in or register to add a comment.

0 votes

0 votes

ACID: Durability

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

(Responsibility of the Recovery System.)

Deepak Poonia answered Feb 16

by Deepak Poonia

0 Comments

Please log in or register to add a comment.

Answer:

← Previous Next →

← Previous in category Next in category →

Related questions

1 vote

1 vote

1 answer

1

Arjun asked in Databases Feb 16

1,676 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 TRUE? The weak entity set MUST have total participation in the identifying ... in the identifying relationship Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

Arjun asked in Databases Feb 16

by Arjun

1.7k views

gatecse2024-set2
databases

2 votes

2 votes

2 answers

2

Arjun asked in Databases Feb 16

2,157 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}$? Sorted Heap Unclustered tree index Unclustered hash index

Arjun asked in Databases Feb 16

by Arjun

2.2k views

gatecse2024-set2
databases
multiple-selects

1 vote

1 vote

1 answer

3

Arjun asked in Databases Feb 16

1,750 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 schedules With $2 \mathrm{PL}$, a transaction always locks the data item being read or ... , no more locks on any data item can be obtained inside that transaction A deadlock is possible with $2 \mathrm{PL}$

Arjun asked in Databases Feb 16

by Arjun

1.8k views

gatecse2024-set2
databases
two-phase-locking-protocol
multiple-selects

2 votes

2 votes

1 answer

4

Arjun asked in Databases Feb 16

1,877 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 available: selection, projection, cross product, and rename. To find the list of cities ... above operators, the minimum number of cross product operations that must be used is $1$ $2$ $3$ $4$

Arjun asked in Databases Feb 16

by Arjun

1.9k views

gatecse2024-set2
databases

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Quick search syntax

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Recent Posts

Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes

Subjects

All categories
General Aptitude (3.5k)
Engineering Mathematics (10.4k)
Digital Logic (3.6k)
Programming and DS (6.2k)
Algorithms (4.8k)
Theory of Computation (6.9k)
Compiler Design (2.5k)
Operating System (5.2k)
Databases (4.8k)
CO and Architecture (4.0k)
Computer Networks (4.9k)
Artificial Intelligence (79)
Machine Learning (48)
Data Mining and Warehousing (25)
Non GATE (1.4k)
Others (2.7k)
Admissions (684)
Exam Queries (1.6k)
Tier 1 Placement Questions (17)
Job Queries (80)
Projects (11)
Unknown Category (870)

64.3k questions

77.9k answers

244k comments

80.0k users

Recent Blog Comments

category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...

Send feedback
Rank Predictor
College Prediction
Useful Links
FAQ
Corrections
Discuss
Copyright
Request
Testimonials
Chat Logs
Chat
Badges
Search tips
Exam Category
Blog Category
Blog Tags
Privacy
Test Series
GATER
Refund Policy
Terms and Conditions
Contact Us

Developed by Chun

Twitter WhatsApp Facebook Reddit LinkedIn Email

Link Copied!