This set of MCQ(multiple choice questions) focuses on the Data Base Management System Week 8 Solutions.
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 8 Solutions” contains 10 questions.
Now, start attempting the quiz.
Data Base Management System Week 8 Solutions
Q1. d) No Action: T1; Redo: T2, T4; Undo: T3
Q2. b) 17 milliseconds
Q3. b), c)
Q4. a) 800400 block transfers and 2 seeks
Q5. d)
Q6. d) 2), 4), 5)
Q7. c)
Q8. d)
Q9. c) 5 Seconds
Q10. a), b)
Data Base Management System Week 8 Solutions
Q1.
Answer: b), c)
Q2.
Answer: c)
Q3.
Answer: d)
Q4. Let us consider the following statistics for searching for a condition in a given relation.
Number of blocks containing record of the relation (b) = 200
Time to transfer one block (tb) = 0.4 milliseconds
Time for one seek (ts) = 4 milliseconds
Identify the cost of selection query on a key attribute using linear search file scan.
a) 84 milliseconds
b) 50.4 milliseconds
c) 4.44 milliseconds
d) 44 milliseconds
Answer: d)
Q5.
Answer: c)
Q6.
Answer: b)
Q7.
Answer: c)
Q8.
Answer: a), c)
Q9. Identify the incorrect statement(s) from the followings.
a) The immediate modification scheme allows updates of an uncommitted transaction to be made to the buffer, or the disk itself, before transaction commits.
b) The deferred-modification scheme allows updates of an uncommitted transaction to be made to the buffer, or the disk itself, before transaction commits.
c) Physical blocks are those blocks residing on the disk.
d) System buffer blocks are those blocks which reside temporarily in the main memory.
Answer: b)
Q10.
Answer: b)
<< Prev- Data Base Management System Week 7 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.