This set of MCQ(multiple choice questions) focuses on the Data Base Management System Week 7 answers.
The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.
Course layout (Answers link)
Answers COMING SOON! Kindly Wait!
Week 0: Assignment answers
Week 1:Â Course Overview. Introduction to RDBMS
Week 2: Structured Query Language (SQL)Â
Week 3: Relational Algebra. Entity-Relationship ModelÂ
Week 4: Relational Database Design
Week 5:Â Application Development. Case Studies. Storage and File StructureÂ
Week 6: Indexing and Hashing. Query ProcessingÂ
Week 7:Â Query Optimization. Transactions (Serializability and Recoverability)Â
Week 8:Â Concurrency Control. Recovery Systems. Course Summarization.
NOTE: You can check your answer immediately by clicking show answer button. Data Base Management System Week 7 answers” contains 10 questions.
Now, start attempting the quiz.
Data Base Management System Week 7 answers
Q1. Choose the correct option for the above transaction schedule.
a) The schedule is neither conflic serializable nor view serializable schedule
b) The schedule is both conflict and view serializable schedule
c) The schedule is only view serializable schedule
d) The schedule is only conflict serializable schedule
Answer: b)
Q2. Consider the following schedule S involiving five transactions T1, T2, T3, T4 and T5.
Identify the correct option(s) that represent the order of execution of all transactions of the above schedule S.
a) T4 -> T5 -> T1 -> T3 -> T2
b) T5 -> 74 -> T1 -> T3 -> T2
c) T1 -> T2 -> T3 -> T5 -> T4
d) T4 -> T1 -> T4 -> T3 -> T2
Answer: b)
Q3. Identify the possible number of conflict serializable schedules of the above schedule S.
a) 0
b) 1
c) 3
d) 5
Answer: b)
Q4. Identify the possible number of view serializable schedules of the schedule S.
a) 5
b) 3
c) 2
d) 1
Answer: c)
Q5. Identify the correct statement(s) from the followings. In this context, older implies smaller timestamp.
a) In Wound-Wait Deadloack Prevention scheme. Older transaction forces rollback of younger transaction instread of waiting for it.
b) In Wound-Wait Deadlock Prevention scheme. Younger transaction never wait for older ones; they are rolled back instead.
c) In Wait-Die Deadlock Prevention scheme. Older transaction forces rollback of younger transaction instead of waiting for it.
d) In Wait-Die Deadlock Prevention scheme. Younger transactions never wait for older ones; they are rolled back instead.
Answer: a), d)
Q6. Identify the correct wait-for graph for the above scenario.
Answer: d)
Q7. Which of the following statements is (are) true for the above two schedules S1 and S2?
a) Both schedules S1 and S2 are Recoverable Schedule.
b) Both schedules S1 and S2 are Cascadeless Schedule.
c) The schedule S1 is Cascadeless Schedule but the schedule S2 is a Recoverable Schedule.
d) The schedule S1 is Cascadeless Schedule but the schedule S2 is not a Recoverable Schedule.
Answer: a), c)
Q8. Which of the following statements is (are) true?
a) Both T1 and T2 follow rigorous two-phase locking protocol.
b) Both T1 and T2 follow strict two-phase locking protocol.
c) Only T1 follows strict two-phase locking protocol, but T2 does not follow two-phse locking protocol.
d) Only T1 follows rigorous two-phase locking protocol but T2 does not follow two-phase locking protocol.
Answer: c)
Q9. Identify the incorrect statement(s) about the lock compatibility matrix given below, where S denotes a shared mode lock and X denotes an exclusive mode lock.
Answer: b)
Q10. Identify the correct statement(s) based on the above schedule S.
Answer: b)
Data Base Management System Week 7 answers
Q1.
Answer: c)
Q2.
Answer: b)
Q3.
Answer: c)
Q4.
Answer: c)
Q5.
Answer: d)
Q6.
Answer: b), c)
Q7.
Answer: c)
Q8.
Answer: d)
Q9.
Answer: b), d)
Q10.
Answer: a), b)
<< Prev- Data Base Management System Week 6 Assignment Solutions
>> Next- Data Base Management System Week 8 Assignment Solutions
DISCLAIMER: Use these answers only for the reference purpose. Quizermania doesn't claim these answers to be 100% correct. So, make sure you submit your assignments on the basis of your knowledge.
For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.