\ Free Question's Objective

Time

Email Us

admin@resultjob.com

Database Management System Question

Database Management System Question With Answer & Solution
Que. - The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
Que. - The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
Que. - The assumption that hardware errors and bugs in the software bring the system to a halt, but do not corrupt the nonvolatile storage contents, is known as the
Que. - The database is partitioned into fixed- length storage units called
Que. - The log is a sequence of                     recording all the update activities in the database.
Que. - In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.
Que. - The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
Que. - If a transaction does not modify the database until it has committed, it is said to use the                        technique.
Que. -                          using a log record sets the data item specified in the log record to the old value.
Que. - In the                      phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.