Database Management System Set 30

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 30

Q1 | What was the name of the first commercially available microprocessor chip?
Q2 | The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
Q3 | The ALU of a computer normally contains a number of high speed storage element called
Q4 | A dump of the database contents is also referred to as an                            dump.
Q5 |                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
Q6 |                    dump schemes have been developed that allow transactions to be active while the dump is in progress.
Q7 | ARIES uses a                        to identify log records, and stores it in database pages.
Q8 | ARIES supports                        operations, which are physical in that the affected page is physically identified, but can be logical within the page.
Q9 |                              is used to minimize unnecessary redos during recovery.
Q10 |                      scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
Q11 | Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the                field of the page.
Q12 | The                                      contains a list of pages that have been updated in the database buffer.
Q13 |                        determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
Q14 |                      starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
Q15 |                              rolls back all transactions that were incomplete at the time of crash.
Q16 | Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
Q17 | Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
Q18 | Which of the following is used for undo operations alone?
Q19 | Redo operations are performed exclusively using
Q20 | An operation is said to be                      if executing it several times in a row gives the same result as executing it once.
Q21 | Immediate database modification technique uses
Q22 | Shadow paging has
Q23 | For correct behaviour during recovery, undo and redo operation must be
Q24 | If                        are not obtained in undo operation it will cause problem in undo- phase.
Q25 | The remote backup site is sometimes also called the
Previous Next