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

Oracle Certification

Oracle Database 11g: 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. Examine the following PL/SQL block used to create a schedule by the SYS user:

BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name     => 'my_stats_schedule',
start_date        => SYSTIMESTAMP,
end_date          => SYSTIMESTAMP + INTERVAL '30' day,
repeat_interval   => 'FREQ=HOURLY; INTERVAL=4',
comments          => 'The statistics schedule');
END;

Which two statements are true about the schedule created? (Choose two)

  1. The schedule is created with access to public
  2. A job defined with the schedule runs in every four hours for 30 days
  3. The schedule can be attached with the jobs created only by the SYS user
  4. A job defined with the schedule runs for four hours every day for the next 30 days
2. Which option speeds up the disk rebalancing in an Automatic Storage Management (ASM) disk group by increasing the degree of parallelism?
  1. Increasing ASM_POWER_LIMIT
  2. Increasing the number of DBWR processes
  3. Increasing the number of ASMB processes
  4. Increasing the number of DBWR_IO_SLAVES
3. Identify two permanent items in the Flash Recovery Area. (Choose two)
  1. Flashback logs
  2. Archived redo logs
  3. Control file autobackups
  4. Multiplexed copies of online redo logs
  5. Multiplexed copies of the current control file
4. The database is in the ARCHIVELOG mode and is configured for remote administration. You execute the following command when the database is in the MOUNT state:

$ nid TARGET=sys/oracle DBNAME=orcl_dup SETNAME=YES

Which two actions would you perform after the command executes successfully? (Choose two)
  1. Open the database with the RESETLOGS option
  2. Create a new password file and restart the database instance
  3. Change the DB_NAME parameter in the parameter file and restart the database instance
  4. Perform a backup of the database because the archive logs cannot be used for the current database incarnation
5. Which two statements are true about the Recovery Manager (RMAN) multisection backup? (Choose two)
  1. Multisection backup produces multipiece backup set
  2. Multisection backups can be performed as backup sets and image copies
  3. The backup optimization feature must be enabled to perform multisection backup
  4. RMAN can break up large files into sections and back up and restore these sections independently
6. What is determined by Recovery Manager (RMAN) multiplexing?
  1. The number of files per backup set during the backup
  2. The number of sections to which a file is divided during backup
  3. The number of channels opened automatically during the back up of the database
  4. The number of files in a backup that are read simultaneously and then written to the same backup piece
7. Identify two results that you get using the BACKUP VALIDATE Recovery Manager (RMAN) command. (Choose two)
  1. It checks for the obsolete backups in the recovery catalog
  2. It confirms that all database files exist and are in the correct locations
  3. It checks for the availability of backup sets and image copies in the recovery catalog
  4. It identifies whether tape streaming or disk input/output (I/O) is the bottleneck in a backup job
8. Examine the following command:

SQL> CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;

Which two statements are true about the restore point created by the above command? (Choose two)
  1. The restore point is never edged out of the control file until it is dropped explicitly
  2. The NOLOGGING operation such as direct loads cannot be reversed using the restore point
  3. The database can be flashed back up to the SCN at the command, even if flashback logging is not enabled                    
  4. Shrinking of data files or dropping a tablespace do not prevent flashing back the affected data files to the restore point
  • 9. Which two operations can you perform using the ALTER FLASHBACK ARCHIVE command? (Choose two) 

    1. Purge some data from the Flashback Data Archive
    2. Add new tablespace to the Flashback Data Archive
    3. Change the retention time of a Flashback Data Archive
    4. Remove all tablespaces from the Flashback Data Archive                      
    10. Which three criteria will not allow the shrink operation in a table? (Choose three)
    1. The table is part of a cluster
    2. The table is managed by free lists
    3. ROW MOVEMENT is enabled for the table
    4. The table has blocks with migrated and chained rows
    5. The table is in the automatic segment space-managed tablespace and has a function based index                     

    Answers

    1. AB
    2. A
    3. DE
    4. BC
    5. AD
    6. D
    7. BD
    8. AC
    9. AC
    10. ABE