Global Assam Educational Hub

  Q. Explain the meaning of the expression ACID transaction. ACID means Atomic, Consistency, Isolation, Durability, so when any transaction happen it should be Atomic that is it should either be complete or fully incomplete. There should not be anything like Semi complete. The Database State should remain consistent after the completion of the transaction. If there are more than one Transaction then the transaction should be scheduled in such a fashion that they remain in Isolation of one another. Durability means that Once a transaction commits, its effects will persist even if there are system failures. Image Courtesy  :media.proprofs.com Q. Explain the difference between an explicit and an implicit lock. Explicit Lock :- Lock is explicitly requested for a record or table. Implicit Lock :- Lock is implied but is not acquired. Q. Explain how a database could be recovered via reprocessing. Why is this generally not feasible?

Recommended Best Books for MBA 1st semester Course by the University are as follows Managing Organization Books List: Management by Robbins S.P., Coulter Mary and Niharika Vohra, Pearson Education (10 th edition), 2010. Ethics in Management by S.A. Sherlekar, Himalayan Publishing. Behavioural Science Book List: Organization Behaviour , Stephen P. Robbins; Timothy A. Judge; Seema Sanghi. 13 th Edition, Pearson-Prentice Hall. Organizational Behaviour - A Modern Approach by Arun Kumar , N Meenakshi , Vikas Publishing. Organization Behaviour , V.S.P. Rao, 1 st Edition, Excel Books. Organization Behaviour , Margie Parikh, Rajen Gupta, 1 st Edition, Tata McGraw Hill. Managerial Economics Book List: 1.     Business Economics- M.Adhikari, Excel Books 2.     Modern Micro Economics- Koutsoyannis, McMillan 3.     Managerial Economics- Keat, Young.& Banerjee. ...