0 0 votes IN DEFFERED DATABASE MODIFICATION ,A TRANSACTION IS PARTIALLY COMMITED AND FAILURE OCCURS BEFORE COMMIT AND A LOG IS CREATED AS FOLLOWS <T,STARTS> <T,A,500> <T,COMMITS> Q-> WILL THE ORIGINAL DATABSE WILL MODIFIED OR NOT?? PLEASE EXPLAIN. Databases databases recovery-from-failure deffered-database-modification + – indrajeet 937 views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
0 0 votes No Original Database will not modified since their is a log file in main memory for a transaction till commit all modifications are stored in log file Before commit if transaction fails then the data in disk will not be changed after commit operation the data modification is reflected in disk shivanisrivarshini answered Jun 16, 2016 shivanisrivarshini comment Share Follow See all 2 Comments 2 2 Comments reply indrajeet commented Jun 16, 2016 reply Follow flag log is stored in stable storage then?? 0 0 replyShare shivanisrivarshini commented Jun 16, 2016 reply Follow flag log stored in main memory 0 0 replyShare Please log in or register to add a comment.
