"A script enabled browser is required for this page to function properly"

Oracle Certification

Oracle Database 10g: Administration II

Sample Questions

View answers below

Sample questions are provided solely to familiarize candidates with the multiple-choice format and writing style of questions that will be found on the exam.  Sample questions may not cover the full spectrum of difficulty that is covered by the exam questions. Success on the sample questions does not predict success on the exam.

1. You configure Flashback Database for the database instance with the following commands:

SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=2880 SCOPE=BOTH SQL> ALTER DATABASE FLASHBACK ON;

Which three statements must be true to make the above configuration successful? (Choose three)

  1. The database is open
  2. The database is in the ARCHIVELOG mode
  3. The database is backed up at least once
  4. The database is mounted in the EXCLUSIVE mode
  5. The flash recovery area is configured for the database instance
2. You receive the following error while enabling the Flashback Database for the database instance:

SQL> ALTER DATABASE FLASHBACK ON;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.

What is the reason for this?

  1. The database is not in the ARCHIVELOG mode
  2. The database is opened with the RESETLOGS option
  3. The Flash Recovery Area is not configured for the database instance
  4. The DB_FLASHBACK_RETENTION_TARGET parameter is set to zero
3. You have a requirement to create a tablespace of 16 KB block size. You executed the CREATE TABLESPACE command and receive the following error:

SQL> CREATE TABLESPACE glob_tbs DATAFILE SIZE 50M BLOCKSIZE 16K
CREATE TABLESPACE glob_tbs DATAFILE SIZE 50M BLOCKSIZE 16K
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes

Which action would you take for successful execution of the command at the next attempt?
  1. Set the DB_16K_CACHE_SIZE parameter to a nonzero value
  2. Set the DB_KEEP_CACHE_SIZE parameter to a nonzero value
  3. Change the block size in the command to a value less than the standard block size
  4. Change the DB_BLOCK_SIZE parameter to 16 K in the parameter file and restart the database
4. Examine the following scenario with respect to user-managed backup and recovery:

- The loss of an important nonsystem tablespace in the database is reported at 11:30 AM
- The tablespace was accidentally dropped at 11 AM.
- You have the backup of all data files.
- You have the backup of the control file that has an entry for the tablespace.

Which statement is true about the recovery of the tablespace?
  1. Restore all data files; recover the database until a time before 11 AM
  2. Restore the control file; restore the data file that corresponds to the tablespace; recover the database
  3. Restore the control file; recover the database until a time before 11 AM with the USING BACKUP CONTROLFILE option
  4. Restore the control file; restore all data files; recover the database until a time before 11 AM with the USING BACKUP CONTROLFILE option
5. You follow the incremental backup strategy for backing up your database. You want the Recovery Manager (RMAN) to identify only the modified blocks and avoid scanning every block in the data files while performing the incremental backup.

What would you do to achieve this?

  1. Enable the block change tracking feature
  2. Configure the backup optimization feature
  3. Configure the RMAN for compressed backup
  4. Enable Flashback Database for the target database instance
6. While the database instance is running, you receive an out-of-memory error due to the undersizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:

ORA-04031: unable to allocate 4000 bytes of shared memory

On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further.

Identify a solution to reduce the probability of getting this error in future.
  1. Set the PRE_PAGE_SGA parameter to TRUE
  2. Set the LOCK_SGA initialization parameter to TRUE
  3. Implement Automatic Shared Memory Management
  4. Set the SGA_TARGET initialization parameter to zero
7. The STATISTICS_LEVEL parameter is set to BASIC for your database instance. Identify three implications of this setting. (Choose three) 
  1. Statistics monitoring is enabled for objects
  2. Automatic SGA Memory Management is disabled
  3. Automatic optimizer statistics collection remains enabled
  4. Automatic Database Diagnostic Monitor (ADDM) is disabled
  5. Automatic Workload Repository (AWR) Snapshots is disabled
8. Examine the following command:

SQL> ALTER TABLE booking SHRINK SPACE;

Identify the activities that are performed when the above command is executed. (Choose all that apply)

  1. The high-water mark (HWM) for the BOOKING table is adjusted
  2. The shrink operation touches all blocks in the BOOKING table
  3. The data manipulation language (DML) triggers in the BOOKING table are executed
  4. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
  5. The indexes for the BOOKING table are maintained automatically and kept in a usable state
9. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.

Which activity would you perform to maintain a consistent performance of the database while adding or removing disks? 
  1. Increase the number of DBWR_IO_SLAVES
  2. Increase the number of ARB processes through the ASM_POWER_LIMIT parameter
  3. Increase the number of ASMB processes using the REBALANCE clause with the ALTER DISKGROUP command.                     
  4. Increase the number of DBWR processes through the DB_WRITER_PROCESSES parameter.
10. Which type of data structure is used by Oracle to maintain the bitmap blocks (BMBs) for free space management in a locally-managed tablespace
  1. Tree.
  2. Stack.
  3. Circle
  4. Queue

Answers

  1. BDE
  2. A
  3. A
  4. D
  5. A
  6. C
  7. BDE
  8. AE
  9. B
  10. A