Oracle database 10g:new features for Oracle8i ocps Sample Questions:

1. When you are performing a backup, the Flash Recovery Area is low on free space. Under which two circumstances would warnings be issued to you? (Choose two.)

A) When the used space is at 85%, a warning is issued.
B) When the used space is at 99%, a critical warning is issued.
C) When the used space is at 90%, a warning is issued.
D) When the used space is at 97%, a critical warning is issued.
E) When the used space is at 95%, a warning is issued.
F) When the used space is at 95%, a critical warning is issued.

2. Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

A) determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
B) flashback the database to before the transaction was committed
C) manually enter the appropriate data again
D) execute the ROLLBACK command with transaction number
E) point-in-time recovery

3. You want to execute the following statements in resumable mode:
CREATE TABLE ... AS SELECT CREATE INDEX CREATE MATERIALIZED VIEW
Which two methods can be used to enable a session for resumable space allocation? (Choose two.)

A) Execute the ALTER DATABASE ENABLE RESUMABLE statement.
B) Set the RESUMABLE_TIMEOUT initialization parameter to true.
C) Execute the ALTER SESSION ENABLE RESUMABLE statement.
D) Set the RESUMABLE_TIMEOUT initialization parameter to none.
E) Set the RESUMABLE_TIMEOUT initialization parameter to a nonzero value.

4. Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recovery strategy available in Oracle 10g?

A) Take the individual data file (not the wholetablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
B) Take the individual data file offline (not the wholetablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
C) Rebuild the index using the online option.
D) Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.

5. What must you do to enable Automated SQL Execution Memory Management?

A) Set the instance parameter PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to 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) Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values

Solutions: