NPTEL Data Base Management System Assignment 7 Answers 2023

Hello NPTEL Learners, In this article, you will find NPTEL Data Base Management System Assignment 7 Week 7 Answers 2023. All the Answers are provided below to help the students as a reference donā€™t straight away look for the solutions, first try to solve the questions by yourself. If you find any difficulty, then look for the solutions.

NPTEL Data Base Management System Assignment 8 Answers 2023 Join GroupšŸ‘‡
NPTEL Principles of Management Assignment 1 Answers 2023

Note: We are trying to give our best so please share with your friends also.

NPTEL Data Base Management System Assignment 7 Answers 2023
NPTEL Data Base Management System Assignment 7 Answers 2023

NPTEL Data Base Management System Assignment 7 Answers 2023:

We are updating answers soon Join Group for update: CLICK HERE

Q.1. Consider the following schedule 8 of transactions T_{1} and T_{2} The read operation on data Item A is denoted by read (A) and the write operation on data item A is denoted by write(A).

Which of the following is TRUE about the schedule S?

  • a) S is serializable both as T_{1} T2 and T_{2}, T_{1}
  • b) S is not serializable neither as T_{1} T_{2} nor T_{2}, T_{1}
  • c) S is serializable only as T_{1} T_{2}
  • d) S is serializable only as T_{2} T_{1} ^ i

Q.2. Consider the following schedule S involving six transactions T_{1} , T_{2} , T3, T_{4} T_{5} and T_{6} :

R(X) denotes read operation on data item X by transaction T_{1}. W(X) denotes write operation on data item X by transaction T_{i}

Choose the correct option for the above transaction schedule.

  • a) The schedule is only view serializable schedule.
  • b) The schedule is only conflict serializable schedule.
  • c) The schedule is both view and conflict serializable schedule.
  • d) The schedule is neither conflict serializable nor view serializable schedule.

Q.3. Consider the following schedule S involving four transactions T_{1} T_{2} T_{3} and T_{4}

R(X) denotes read operation on data item X by transaction T_{i} W(X) denotes write operation on data item X by transaction T.

Identify the possible number of conflict serializable schedules of the above schedule S.

  • a) 1
  • b) 2
  • e) 3
  • d) 4
NPTEL Data Base Management System Assignment 7 Answers Join GroupšŸ‘‡
NPTEL Data Base Management System Assignment 7 Answers 2023

Q.4. Consider the following schedule S.

R(Y) denotes read operation on data item Y by Transaction T_{i} W(Y) denotes write operation on data item Y by Transaction T_{i} Identify the possible number of view serializable schedule of the above schedule S.

  • a) 1
  • b) 2
  • c) 3
  • d) 4

Q.5. Suppose in a database, there are four transactions T_{1} , T_{2} T_{3} and T_{4} Transaction T_{1} is waiting for transactions T_{2} and T_{4} transaction T_{2} is waiting for transaction Ts and T_{4} and transaction T_{3} is waiting for transactions T_{4} to release a data item. Identify the correct wait-for graph for the above scenario.

  • Answer: B

Q.6. Consider two transactions given below where lock-X(A) denotes T, has obtained an Exclusive-mode lock on item A and lock-S(A) denotes T has obtained a Shared-mode lock on item A.

Which of the following statement is (are) true?

  • a) Both T_{1} and T_{2} follow the rigorous two-phase locking protocol.
  • b) Both T_{1} and T_{2} do not follow the rigorous two-phase locking protocol.
  • c) Only T_{1} follows the rigorous two-phase locking protocol.
  • d) Only T_{2} follows the rigorous two-phase locking protocol.

Q.7. Suppose in a database, there are three transactions T_{1} T_{2} and T_{3} with timestamp 12, 14 and 16 respectively. T_{1} is holding a data item which T_{2} and T3 are requesting to acquire. Which of the following statement(s) is (are) correct in respect of Wound-Wait Deadlock Prevention scheme?

  • a) Transaction T_{2} will wait for T_{1} to release the data item.
  • b) Transaction T_{3} will wait for T_{1} to release the data item.
  • c) Transaction T_{2} will be aborted.
  • d) Transaction T_{3} will be aborted.
NPTEL Data Base Management System Week 7 Answers Join GroupšŸ‘‡
CLICK HERE

Q.8. Consider the following schedule S.

R(Y) denotes read operation on data item Y by Transaction T. W(Y) denotes write operation on data item Y by Transaction T. Identify the correct statement(s) based on the above schedule S.

  • a) If T1 fails(aborted), only T2 must be rolled back.
  • b) If T1 fails(aborted), only T3 must be rolled back.
  • c) If T1 fails(aborted), both T2 and T3 must be rolled back.
  • d) If T1 fails(aborted), neither T2 nor T3 must be rolled back.

Q.9. Consider the following schedule S.

R(X) denotes read operation on data item X by Transaction Ti. W(X) denotes write operation on data item X by Transaction T.

Choose the correct options for the above schedule.

  • a) The schedule is only recoverable schedule.
  • b) The schedule is only cascadeless schedule.
  • e) The schedule is recoverable schedule and cascadeless schedule both.
  • d) The schedule is neither recoverable nor cascadeless schedule.

Q.10. Identify the correct option(s) which is (are) used in Transaction Control Language (TCL).

  • a) Alter
  • b) Insert
  • c) Update
  • d) Savepoint
NPTEL Data Base Management System Assignment 7 Answers Join GroupšŸ‘‡
NPTEL Data Base Management System Assignment 7 Answers 2023

Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong donā€™t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided byĀ Chase2learn. This tutorial is only for Discussion andĀ LearningĀ purpose.

About NPTEL Data Base Management System Course:

Databases form the backbone of all major applications today ā€“ tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. NPTEL Data Base Management System Assignment 5 Answers

Course Outcome:
  • 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.
CRITERIA TO GET A CERTIFICATE:

Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course. ( NPTEL Data Base Management System Assignment 5 Answers)
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

If you have not registered for exam kindly register Through https://examform.nptel.ac.in/

Join Our Telegram Group:- CLICK HERE

Sharing Is Caring