Which of the following objectives of Data Distribution is achieved by having redundant fragment allocation meeting the site requirements?

Which of the following schemas defines at which site a fragment is allocated?

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?

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?

In which of the following design approaches are global relations progressively split into fragments?

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.?

Which of the following conditions in defining fragments controls replication of data explicitly at the allocation level?

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?

Which of the following method subtypes in Oracle gives the information that new subtypes may not override this method?

Which of the following phases in Recovery Manager Environment(RMAN) determines which objects the command will access?

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?

Which of the following responses in the Prepare Phase does not allow to perform modification of the data on the node?

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?

________________ is the role of node in the session tree of a distributed transaction.

Which of the following memory components of the System Global Area (SGA) consists of memory area that are shared by multiple users?

Which of the following files in Oracle 9i contains a number of parameters that can be used to configure the Oracle 9i instance?

Which of the following stages in software design allows an user to identify a number of solutions and to evaluate them all?

Which of the following designs in Design process allows an user to design the algorithms used to provide services and are designed in detail and specified?

Which of the following shutdown modes in Oracle performs all currently active transactions which will be allowed to complete?

In which of the following models are objects class/inheritance diagrams may be used to show how entities have common charcteristics?

Which of the following is the process which controls the changes made to a system and manages the different versions of the evolving software product?

Which of the following types of software maintenance involves implementing new functional or non-functional system requirements?

Which of the following approach to program development whereby programmers assume that there may be undetected faults or inconsistencies in their programs?

Which of the following objects in object-oriented design is a package of software-controlled instruments, which collects data , performs some data processing and transmits this data for further processing?

Which of the following in object-oriented development is concerned with realizing a software design using an object-oriented programming language?

Which of the following in domain-specific architectural model is an abstract and describe a larger class of systems?

Which of the following activities in Function-oriented design describes the entities in the design that may be recorded in a data dictionary?

Which of the following activities in Architectural design is the one in which a general model of the control relationships between the parts of the system is established?

Which of the following contents of Program Global Area (PGA) consists of memory area that holds session's variables and session-related information?

Which of the following models shows how data and processing is distributed across the range of processors?