BIT01s: DBMS-II Exam 03

Course Name: Database management System -II
Course Code: CES- 504

Dear BIT01s,
This is the syllabus for our upcoming DBMS-II exam 03 which will be held 8th May(Sunday) at 2:30pm.

Chapter-15: Transactions (Every topics of this chapter Madam already discussed)
15.1 Transaction Concept (ACID Properties)
15.2 Transaction State
15.3 Implementation of Atomicity and Durability
15.4 Concurrent Executions
15.5 Serializability
15.5.1 Conflict Serializability
15.5.2View Serializability
15.6 Recoverability
15.6.2 Cascade less Schedules
15.7 Implementation of Isolation
15.8 Testing for Serializability

Chapter -16: Currency Control
Page : 635 to 641
16.1 Lock Based Protocols
16.1.1 Locks
16.1.2 Granting of Locks
16.1.3 The Two Phase Locking Protocol

Only green Color syllabus of this chapter is included in this exam.


16.1.5(Graph Based Protocols) to 16.2.2(The Timestamp Ordering Protocol)
16.4 Multiple Granularity
16.6 Deadlock Handling
16.7.3 The Phantom Phenomenon

*Note: From chapter 16 Madam Only completed 16.1 to 16.1.3 since today. So I don’t know what will be happened for other topics of this Chapter. Please anybody consult with Madam and then inform about it.


Edited:

Efat talked with madam on 4May. His part-


today I talked with madam
and she ensured me that, from chapter 16 there is only 16.1.1-16.1.4
she also told to emphasis on the exercises.
but she may give something that is relate with chapter but it may not in the exercise.

Syllabus Updated by BIT0119:
I spoke to Tahrima madam on May 7, 2011 and she confirmed that from chapter 16 we need to read upto 16.1.3(inclusive). And guess what, there will be 2 sets of questions in the exam.

Good work buddy

Again....Ibrahim

OMG!!
again this is a huge syllabus
but thanx and to our beloved IBRA

today I talked with madam
and she ensured me that, from chapter 16 there is only 16.1.1-16.1.4
she also told to emphasis on the exercises.
but she may give something that is relate with chapter but it may not in the exercise.

BIT0115-Efat wrote:today I talked with madam
and she ensured me that, from chapter 16 there is only 16.1.1-16.1.4
she also told to emphasis on the exercises.
but she may give something that is relate with chapter but it may not in the exercise.

সেটা কি রবিবারের পরীক্ষার জন্য নাকি সব পরীক্ষার জন্য?

জানানোর জন্য ধন্যবাদ।

Thanks Efat for the update

I think, it is for the Sunday exam.

ওহ আচ্ছা। তার মানে আমাদের পড়ানো না হলেও সেটা পরীক্ষায় থাকে।
আমাদের PL এর মাঝে ক্লাস নেবার কথা বলে ভার্সিটিতে আনানো হয়। সেই ক্লাস আবার হয় না।
আবার বলা হয় আমরা যেনো PL এর সময় Project এর কাজ শেষ করি, কারণ PL এর পরে পরীক্ষা, আর পরীক্ষার পরেই LAB demo

Bravo, Bravo!!!

BIT0129-Tabassum wrote:Thanks Efat for the update

I think, it is for the Sunday exam.

You should've updated Ibrahim's post with Efat's info.

yaaap. it is only for the next upcoming quiz/in-course/mid-term what it will be
but, madam told she may extend the syllabus, But I donno how and when?

Probably she wants to take class in the gap between exams Or in the vacation after exam.

BIT0122-Amit wrote:ওহ আচ্ছা। তার মানে আমাদের পড়ানো না হলেও সেটা পরীক্ষায় থাকে।
আমাদের PL এর মাঝে ক্লাস নেবার কথা বলে ভার্সিটিতে আনানো হয়। সেই ক্লাস আবার হয় না।
আবার বলা হয় আমরা যেনো PL এর সময় Project এর কাজ শেষ করি, কারণ PL এর পরে পরীক্ষা, আর পরীক্ষার পরেই LAB demo

Bravo, Bravo!!!

IIT এখন জোকস করার ভাল একটা জায়গা। যার যখন মন চায় আসে, চেহারা দেখে, জোকস করে, চলে যায়।

Syllabus Updated by BIT0119:
I spoke to Tahrima madam on May 7, 2011 and she confirmed that from chapter 16 we need to read upto 16.1.3(inclusive). And guess what, there will be 2 sets of questions in the exam.

Thanks for the update Asif. But when you update, please post the update as a reply too. otherwise, it might be ignored.

shit! ! !
again 2 set of question :O :O
it is really not a good decision.
there is no similarity of the difficulty level

uff

Damn

We have to stand against this kind of two set questions. Two or more set of questions are only ok when it is ensured that, all are of same difficulty level. But all the time in DBMS exams, the sets are not equal. So we must raise our opinion against it

We all will have to tell her that her SETs were totally unfair.