Questions
Which of the following recovery techniques that recovers from non-catastropic transaction failure, is the one that do not physically update the database on disk, until a transaction reaches its commit point?
- System log
- Deferred update
- Immediate update
- Rollback
- Savpoint
Which of the following properties of a transaction states that the changes applied to the database by a committed transaction must persist in the database?
- Atomicity
- Consistency preservation
- Isolation
- Durability or permanency
- Schema definition
Which of the following operations of recovery manager signals a successful end of the transaction, So that any changes executed by the transaction can be safely committed to the database?
- Begin_Transaction
- Read or Write
- End_Transaction
- Commit_Transaction
- Rollback
Which of the following properties of transaction refers to multiple transactions, accessing the same database at the same time?
- Concurrency
- Referential Integrity
- Functional Dependency
- Normalisation
- Entity Integrity
Which of the following databases permit the database system to store a history of changes and allow users to query both current, and past states of the database?
- Spatial databases
- Multimedia databases
- Temporal databases
- Triggers
- Cursors
Which of the following components in the active database rules is the one that determines whether the rule action should be executed or not?
- Event
- Condition
- Action
- Relationships
- Alerts
Which of the following considerations in the design and implementation of active databases states that the condition is evaluated as part of the same transaction, as the triggering event and is evaluated immediately?
- Deferred consideration
- Immediate consideration
- Detached consideration
- Action consideration
- Reply consideration
Which of the following functions in a distributed database environment is the ability to access remote sites and transmit queries, and data among the various sites via a communication network?
- Keeping track of data.
- Distributed transaction management.
- Distributed query processing.
- Replicated data management.
- Distributed data recovery.
Which of the following forms of data warehouse provide views of operational databases that are materialised for efficient access?
- Data marts
- Virtual data warehouse
- Enterprise-wide data warehouse
- Stored data warehouse
- Meta data
Which of the following features of Oracle Open Gateways provides access to a non-Oracle database from an oracle server, is a procedural system like a messaging or a queuing system that is accessed by Oracle using PL/SQL remote procedure calls?
- Distributed transactions
- Global Query Optimisation
- Procedural Access
- Transparent SQL access
- Key Constraints
Which of the following tables maintained by the transaction manager contains an entry for each active transaction in database recovery?
- Dirty Page Table
- Transaction Table
- Symbol Table
- Create Table
- Log Table
Which of the following methods in recovery schemes of database, considers the database to be made up of a number of fixed-size disk pages for recovery purposes?
- Directory
- Shadow Paging
- Transaction Table
- Log Sequence Number
- Checkpoints
Which of the following object is kept under the control of the DBMS for the purpose of holding data buffers in database recovery mechanism?
- System Catalog
- DML Precompiler
- DBMS Cache
- Metadata
- Dirty bit
Which of the following recovery mechanisms must ensure that the before image (BFIM) of the data item is recorded in the appropriate log entry, and that the log entry is flushed to disk before the BFIM is overwritten with the after image (AFIM) in the database on disk?
- Page Table
- Segmentation
- Overlays
- Write-ahead logging
- Semaphores
Which of the following terms in DBMS recovery technique cannot write data to a disk even after the cache page is updated through a transaction before the transaction commits?
- Steal approach
- No-Steal approach
- Force approach
- No-Force approach
- Procedural approach