Which of the following operations in SQL retrieves the rows from the active set, one row at a time?

Which of the following levels of RAID technology refers to disk mirroring with block?

Which of the following objects in PL/SQL returns data value at the end?

In distributed database systems, each server participating in a distributed database is administered independently from all other databases means

Which of the following properties of transaction management requires that if a transaction is interrupted by a failure, its partial results are not at all taken into consideration and the whole operation has to be repeated?

Which of the following roles in distributed transaction refers to a node that is forced to reference data on other nodes to complete its part of the transaction?

Which of the following is an area or automatic storage management disk group that serves as the default storage area for files related to recovery?

Which of the following components of recovery manager is a vendor specific application that allows RMAN to backup to a storage system such as tape?

Which of the following components of recovery manager is a copy of the primary database that is updated using archived logs created by the primary database?

Which of the following database objects in PL/SQL groups objects and programs together into a single entity?

Which of the following explicit cursor attributes evaluates, true if the cursor is opened?

_____________ is the data stored in the cursor of a PL/SQL program.

Which of the following objects in Oracle consists of physical files and memory components?

The database writer, log writer and checkpoint processes are _______________ type of processes in Oracle 9i.

Which of the following pools in System Global Area consists of memory area that is shared by multiple users?