UGC NET CSE | December 2006 | Part 2 | Question: 17

Question

In DBMS, deferred update means :

• A. All the updates are done first but the entries are made in the log file later

• B. All the log files entries are made first but the actual updates are done later

• C. Every update is done first followed by a writing on the log file

• D. Changes in the views are deferred till a query asks for a view

Answer 1

option B  as log file entries made and actual updates are done after COMMIT.