Distributed Database Transaction and Recovery Techni...
Distributed database transaction and recovery techniques Java/Oracle /C/C++Oracle
Questions
In which of the following transaction's properties are either all or none of the transaction's operations performed?
- Durability
- Shared mode
- Atomicity
- Growing phase
- The local agent
Which of the following components of the RMAN environment containing the control files, datafiles etc. that RMAN backups or restore?
- Target database
- Duplicate database
- Media management catalog
- Proxy archived log backups
- Stored script
In which of the following RAID levels does any disk failure destroys the array, which becomes more likely with more disks in the arrary?
- RAID level 3
- RAID level 0
- RAID level 4
- One-safe
- Registration
Which of the following RAID level provides fault tolerance from two drive failures and array continues to operate with up to two failed drives?
- Stored script
- RAID level 6
- RAID level 3
- RAID level 4
- Two-very-safe
Which of the following is not stored in an RMAN-specific format?
- Image copy
- Stored script
- Standby database
- Media management catalog
- Registration
Which of the following nodes participating in the session tree sends all of the distributed transaction's SQL statements, remote procedure calls and so forth to the directly reference nodes?
- Local coordinator
- Global coordinator
- Database server
- Client
- Shared mode
Which of the following transaction's properties states that an incomplete transaction can't disclose its result to other transactions until it is committed?
- Exclusive mode
- Durability
- Isolation
- Growing phase
- The local agent
Which of the following database is created as a separate database by RMAN because it has different DBID from its primary database?
- Logical standby database
- Registration
- Media management catalog
- Physical standby database
- Proxy archived log backups
Which of the following features of the RMAN describes the contents of the backup set that define which files are multiplexed and the level of multiplexing?
- Proxy archived log backups
- Recovery through Resetlogs
- Automatic datafiles creation
- Detection of failure
- Disk topology and automatic performance tuning
Duing which of the following phases does RMAN determine which object will the command access for example, resolving a tablespace name into its component datafiles?
- Execution phase
- Growing phase
- Shared mode
- Compilation phase
- Registration
In which of the following transaction's properties, if many transactions execute concurrently, the result must be same as if they were executed serially in the same order?
- Serializability
- Durability
- Shared mode
- Growing phase
- One-safe
Which of the following areas is a directory, filesystem etc., includes archived redo logs, flashback logs and RMAN backups?
- Oracle flashback database
- Proxy archived log backups
- SQL work area
- Flash recovery area
- Stored script
In which of the following RAID levels does array continue to operate so long as at least one drive is functioning?
- Detection of failure
- RAID level 1
- RAID level 3
- RAID level 4
- Two-very-safe
Which of the following files is a text file which contains RMAN commands as you would enter them at the command line?
- Stored script
- Command language interpreter
- Command file
- The archive file
- The parameter file
You can create which of the following components of the RMAN environment that contains the RMAN metadata for multiple target database unless you are using RMAN with a physical standby database?
- Media management application
- Media management catalog
- Recovery catalog database
- Duplicate database
- Registration