Syllabus of Database management system

bts1jimin asked Aug 27, 2018

1,045 views

1 votes

Are following part of gate syllabus for dbms?

1-Validation Based protocols

2-multiversion schemes

3-snapshot isolation

4-predicate reads(concurrency control)

5-concurrency in index structures.

Databases
syllabus
databases
transaction-and-concurrency
concurrency

+ –

bts1jimin asked Aug 27, 2018

bts1jimin

1.0k views

See all

1 1 comment

Syed Sauban

commented Dec 13, 2018

I also have a question regarding DBMS syllabus. Check the link below:

https://gateoverflow.in/277998/question-regarding-gate-syllabus-for-dbms

0 votes

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Voting & Accepting an answer helps improve the community

← Previous Next →

← Previous in category Next in category →

Related questions

1 votes

0 answers

GateAspirant999 asked May 20, 2018

3,129 views

Understanding multiversion timestamp ordering protocol in database systems
I was reading multiversion timestamp ordering protocol from the book Database Systems Concepts by Korth. It can be explained in simpler words as follows: Each data item version $Q$ has two timestamps associated with it: W-timestamp: ... I am wrong and it was indeed asked in previous year GATE paper?) Can we safely skip it?

I was reading multiversion timestamp ordering protocol from the book Database Systems Concepts by Korth. It can be explained in simpler words as follows:Each data item ve...

GateAspirant999

3.1k views

GateAspirant999 asked May 20, 2018

Databases
databases
concurrency
transaction-and-concurrency

+ –

2 votes

1 answer

Rahul Jain25 asked Feb 4, 2017

2,382 views

Database 2PL and Timestamp doubt
I)All schedules that are allowed under 2PL are also allowed under Timestamp?? Is vice versa true?? II)Plz explain by giving example. I have read that there are schedules that are allowed under 2PL but not under Timestamp and vice versa, ... ?? IV) Are all view serializable allowed under Timestamp(Thomas write rule)??? Explanation along with example would be helpful.

I)All schedules that are allowed under 2PL are also allowed under Timestamp?? Is vice versa true??II)Plz explain by giving example. I have read that there are schedules t...

Rahul Jain25

2.4k views

Rahul Jain25 asked Feb 4, 2017

Databases
databases
conflict-serializable
concurrency
transaction-and-concurrency

+ –

11 votes

2 answers

vix28 asked Sep 8, 2016

12,489 views

serializablity and recoverability of schedules
1) T1: R(X), T2: W(X), T1: W(X), T2: Abort, T1: Commit 2) T1: W(X), T2: R(X), T1: W(X), T2: Abort, T1: Commit 3) T1: W(X), T2: R(X), T1: W(X), T2: ... : Abort Can anyone explain whether these schedules are serializable, conflict-serializable, view serializable, recoverable, avoids-cascading-aborts, and strict? The abort operation actually bugging me.

1) T1: R(X), T2: W(X), T1: W(X), T2: Abort, T1: Commit2) T1: W(X), T2: R(X), T1: W(X), T2: Abort, T1: Commit3) T1: W(X), T2: R(X), T1: W(X), T2: Commit, T1: AbortCan anyo...

vix28

12.5k views

vix28 asked Sep 8, 2016

Databases
transaction-and-concurrency
concurrency
conflict-serializable
view-serializable
databases

+ –

1 votes

2 answers

DebRC asked Aug 16, 2022

1,949 views

Is a Serial Schedule always Recoverable?
Is only conflict serializable schedules are recoverable? Or both view as well as conflict serializable schedules are recoverable? I have been seeing different answers in different forum.

Is only conflict serializable schedules are recoverable?Or both view as well as conflict serializable schedules are recoverable?I have been seeing different answers in di...

DebRC

1.9k views

DebRC asked Aug 16, 2022

Databases
databases
concurrency
transaction-and-concurrency
serializability

+ –

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

1 1 comment reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

1 1 comment