This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Remote Backup Systems”. 1. The remote backup site is sometimes also called the a) Primary Site b) Secondary Site c) Tertiary Site d) None of the mentioned 2. Remote backup system must be _________ with the primary site. a) Synchronised b) Separated c) … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Lock Release and Undo Operations”. 1. Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value. a) Higher-level lock b) Lower-level lock c) Read only lock d) Read write … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “ARIES”. 1. ARIES uses a ___________ to identify log records, and stores it in database pages. a) Log sequence number b) Log number c) Lock number d) Sequence 2. ARIES supports ___________ operations, which are physical in that the affected page is physically … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Failure with Nonvolatile Storage”. 1. The silicon chips used for data processing are called a) RAM chips b) ROM chips c) Micro processors d) PROM chips 2. Which of the following is used for manufacturing chips? a) Control bus b) Control unit c) … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Buffer Management”. 1. In order to reduce the overhead in retrieving the records from the storage space we use a) Logs b) Log buffer c) Medieval space d) Lower records 2. The order of log records in the stable storage ____________ as the … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Recovery”. 1. The log is a sequence of _________ recording all the update activities in the database. a) Log records b) Records c) Entries d) Redo 2. In the ___________ scheme, a transaction that wants to update the database first creates a complete … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Failure Classification”. 1. The recovery scheme must also provide a) High availability b) Low availability c) High reliability d) High durability 2. Which one of the following is a failure to a system a) Boot crash b) Read failure c) Transaction failure d) … Read more
This set of Database Question Bank focuses on “Concurrency in Index Structures”. 1. The method of access that uses key transformation is called as a) Direct b) Hash c) Random d) Sequential 2. Why do we need concurrency control on B+ trees ? a) To remove the unwanted data b) To easily add the index … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Insertion Deletion Predicate Reads”. 1. Which statements are correct regarding indexes? a) When a table is dropped, the corresponding indexes are automatically dropped b) For each DML operation performed, the corresponding indexes are automatically updated c) A non-deferrable PRIMARY KEY or UNIQUE KEY … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Snapshot Isolation”. 1. Snapshot isolation is a particular type of ______________ scheme. a) Concurrency-control b) Concurrency-allowance c) Redirection d) Repetition-allowance 2. Snapshot isolation is used to give a) Transaction a snapshot of the database b) Database a snapshot of the transaction c) Database … Read more
