Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. It is possible for the transaction to use inactive extents from another undo tablespace. B. It is possible for the transaction to span different undo segments. C. It is possible for the transaction to reuse inactive extents from another undo segment. D. It is possible for the transaction to extend the undo tablespace, even if defined with AUTOEXTENSIBLE set to FALSE.

A. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment. B. You can create an automatic space management segment in a dictionary-managed tablespace. C. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment. D. You can create an automatic space management segment only in a locally managed tablespace.

A. any tablespace depending on the temporary LOBs' definition B. in the user's temporary tablespace C. in the user's default tablespace D. in the SYSTEM tablespace

A. PASSWORD_LIFE_TIME B. PASSWORD_LOCK_TIME C. PASSWORD_VERIFY_FUNCTION D. FAILED_LOGIN_ATTEMPTS

A. Changes to the parameter are only in the currently running instance. B. The parameters are specified in the PFILE parameter file. C. The value for the parameters is TRUE. D. The parameters are specified in the SPFILE parameter file.

A. Savepoint names need to be unique between the calling transaction and the autonomous transaction. B. Deadlocks between the autonomous transaction and its calling transaction are prevented. C. Committed changes in an autonomous transaction are visible to other transactions (except possibly the calling transaction) regardless of whether the calling transaction commits or rolls back. D. They share resources with the calling transaction.

A. BFILE B. BLOB C. LOBFILE D. CLOB

A. partial database backups B. incremental block-level backup C. skipping unused blocks D. online backups E. detection of corrupted blocks during backup

A. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database B. SYNC or ASYNC to identify the network transmission mode C. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby D. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously

A. 6 * CPU_COUNT B. 4 * number of rollback transactions C. 4 * CPU_COUNT D. 2 * number of rollback transactions E. 2 * CPU_COUNT

A. DBMS_LT.ENABLETABLE('MORTGAGE'); B. DBMS_WM.ENABLEVERSIONING('MORTGAGE'); C. DBMS_LT.ENABLEVERSIONING('MORTGAGE'); D. DBMS_WM.ENABLE_TABLE('MORTGAGE');

A. Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values B. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE. C. Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE all to AUTO. D. Set the instance parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to appropriate values.

A. the number of blocks to be read during instance recovery, or the time needed to complete instance recovery B. the number of passes through the redo logs made by the recovery process to identify blocks needing recovery C. the instance that will perform recovery in a Real Application Clusters database D. the size of the redo buffer in the SGA

A. They should be granted, by the Global Cache Service, an exclusive mode resource for each instance involved. B. They should be transferred across a high-speed cluster interconnect. C. They should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered. D. They should be written to disk by the sending instance and read from disk by the receiving instance.