Questions
Which of the following objectives of Data Distribution is achieved by having redundant fragment allocation meeting the site requirements?
- Availability and reliability of distributed data
- Processing locality
- Workload distribution
- None of these
Which of the following schemas defines at which site a fragment is allocated?
- Global schema
- Fragmentation schema
- Allocation schema
- None of these
Which of the following caches is also managed by using the Least Recently Used (LRU) algorithm, which is on a First-in First-out basis?
- Library cache
- Data dictionary cache
- Database buffer cache
- None of these
Which of the following types of authentication mechanisms is created by the DBA to create user account in the database for each user who needs to access database?
- Operating system authentication
- Database authentication
- Network authentication
- None of these
In which of the following design approaches are global relations progressively split into fragments?
- Grouping approach
- Top-Down approach
- Split approach
- None of these
Which of the following methods is used in Oracle to establish ordinal positions of objects for comparisons such as < or between and for sorting, etc.?
- Member method
- Comparison method
- Static method
- None of these
Which of the following conditions in defining fragments controls replication of data explicitly at the allocation level?
- Completeness condition
- Reconstruction condition
- Disjoint condition
- None of these
Which of the following databases is the one in which idea of distribution of the data is considered and hierarchical approach in administration of data like Global administrator is incorporated?
- Centralized database
- Distributed database
- Duplicate database
- None of these
Which of the following method subtypes in Oracle gives the information that new subtypes may not override this method?
- OVERRIDING
- NOT INSTANTIABLE
- FINAL
- None of these
Which of the following phases in Recovery Manager Environment(RMAN) determines which objects the command will access?
- Execution phase
- Compilation phase
- Error phase
- None of these
Which of the following schemes in distributed database management consists of locks that has one copy of each data item privilged and lock all the copies so that conflicts are discovered at the site where the primary copy resides?
- Primary copy locking
- Read - Write locks
- Majority locking
- None of these
Which of the following responses in the Prepare Phase does not allow to perform modification of the data on the node?
- Prepared
- Read only
- Abort
- None of these
Which of the following is the first phase in distributed transaction where the Global Coordinator, asks participating nodes other than the commit point site to promise to commit or roll back the transaction, even if there is a failure?
- Commit phase
- Forget phase
- Prepare phase
- None of these
________________ is the role of node in the session tree of a distributed transaction.
- Database server
- Clients
- Local coordinator
- Global coordinator
Which of the following memory components of the System Global Area (SGA) consists of memory area that are shared by multiple users?
- Large Pool
- Java Pool
- Stream Pool
- Shared Pool
Which of the following files in Oracle 9i contains a number of parameters that can be used to configure the Oracle 9i instance?
- Archive files
- Password file
- Parameter file
- None of these
Which of the following shutdown modes in Oracle performs all currently active transactions which will be allowed to complete?
- Normal
- Immediate
- Transactional
- Abort
Which of the following contents of Program Global Area (PGA) consists of memory area that holds session's variables and session-related information?
- SQL Work Area
- Session Memory
- Private SQL Area
- None of these
Which of the following models shows how data and processing is distributed across the range of processors?
- Client-Server model
- Repository model
- Abstract machine model
- None of these