11g OCP 053

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database.
The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you
lost your production database completely along with the recovery catalog database. You want to recover the target
database and make it functional.

You could consider performing the following steps to accomplish this task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file.
3) Start the target database Instance.
4) Mount the database.
5) Restore the data files.
6) Open the database with the RESETLOGS option.
7) Recover the data files.
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8

Correct Answer: B

QUESTION 105
You configured the default backup device type as disk for RMAN backups. In your database, because of
business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN
BACKUP command is used.
What must you set using the RMAN CONFIGURE command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2;
C. RETENTION POLICY TO REDUNDANCY 2;
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct Answer: C

QUESTION 111

You have configured flash recovery area in your database and you set the following Initialization
parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the
LOG_ARCHIVE_DEST_I
parameter Is not available for the archived redo log file to be created in. All redo log groups have been
used. What happens in an event of log switch?
A. The online redo log file Is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is
made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination
set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log
files are created in the next two available locations to guarantee archive log success.
Correct Answer: D

 

Explanation:

QUESTION NO: 729
You execute the following Recovery Manager (RMAN) commands in (he following order:
BACKUP VALIDATE DATABAE
RECOVER CORRUPTION LIST;

Which (two tasks are performed by these commands? (Choose two.)

A. Repair the corrupted blocks. If any. In the backup created.
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks-
C. Back up the database after checking whether array of the files have corrupted blocks.
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION
view.
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_
CORRUPTION

Answer: B,C

Repairing All Block Corruption in the Database: Example The following example runs a backup validation to populate V$DATABASE_BLOCK_CORRUPTION, then repairs any corrupt blocks recorded in the view:

BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;

187.You are managing an Oracle Database 11g database. You want to take a backup on tape drives ofthe USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each.To accomplish the backup, you issued the following RMAN command:
RMAN>BACKUP SECTION SIZE 300MTABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using theabove command?

• The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
• The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
• The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
• None

178.Which three statements are true regarding the functioning of the Autotask Background Process(ABP)?

• It creates jobs without considering the priorities associated with them.
• It translates tasks into jobs for execution by the scheduler.
• It determines the list of jobs that must be created for each maintenance window.
• It is spawned by the MMON background process at the start of the maintenance window.
• It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

 

179.Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

• Generate reports on data failure such as data file failures.
• You can track the Service Request (SR) and implement repairs.
• You can package and upload diagnostic data to Oracle Support.
• You can manually run health checks to gather diagnostic data for a problem.

14. Which of the following does the recover command not do?
A. Restore archived redo logs.
B. Apply archived redo logs.
C. Restore incremental backups.
D. Apply incremental backups.
E. Restore datafile images

13. Which of the following restrictions are not true with respect to tablespace point-in-time
recovery? (Choose all that apply.)
A. The target database must be in NOARCHIVELOG mode.
B. No backup is required of the database before you perform a TSPITR.
C. You must have all archived redo logs generated since the last backup up to the point to
which you want to restore the transport set.
D. If you rename a tablespace, you can not perform a TSPITR to any point in time before
that rename operation occurred.
E. If you have tables in tablespace_1 that have associated constraints in tablespace_2,
then you must transport both tablespaces

13. Which of the following restrictions are not true with respect to tablespace point-in-time
recovery? (Choose all that apply.)
A. The target database must be in NOARCHIVELOG mode.
B. No backup is required of the database before you perform a TSPITR.
C. You must have all archived redo logs generated since the last backup up to the point to
which you want to restore the transport set.
D. If you rename a tablespace, you can not perform a TSPITR to any point in time before
that rename operation occurred.
E. If you have tables in tablespace_1 that have associated constraints in tablespace_2,
then you must transport both tablespaces.

19. In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?
A. The datafiles have an ONLINE status.
B. The datafiles have an OFFLINE status.
C. The datafiles have an ONLINE status and are in hot backup mode prepared for an
online backup.
D. The datafiles have an OFFLINE status and are in hot backup mode for an online
backup.
E. The datafiles are in STANDBY mode

11. At the request of a user, you issue the following command to restore a dropped table:
flashback table “BIN$F2JFfMq8Q5unbC0ceE9eJg==$0” to
before drop; Later, the user notifies you that the data in the table seems to be very old and
out of date. What might be the problem?
A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. A previous Flashback Drop operation had been performed, resulting in multiple versions
of the table being stored in the Recycle Bin.
D. Either option A or B could be correct. Not enough information was provided to deter-mine which.
E. None of the above

4. To manually configure the SGA components using Oracle Enterprise Manager Memory
Advisor, you can set values for which of the following initialization parameters? (Choose
all that apply.)
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

6. Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following
pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

7. In Oracle 11g, by default which one of the following conditions implicitly enables Automatic
PGA Memory Management?
A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above

8. Automatic PGA Memory Management eliminates the need to manually configure which of
the following initialization parameters? (Choose all that apply.)
A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET

15. When exporting metadata for the transportable tablespaces, what is the correct next step
after confirming endian format?
A. Export the tablespaces using data pump.
B. Determine if the transportable set is self-contained.
C. Convert the datafiles using RMAN.
D. Copy the datafiles from source to destination.

16. Which of the following are prerequisite steps to transport a database? (Choose all that apply.)

A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
B. Verify that there are no restrictions or limitations that the source or destination data-base may encounter.
C. Verify that the source and destination have the same Oracle version, critical updates,
patch-set version, and patch-set exceptions.
D. Determine if you will perform the conversion on the source or destination platform.
E. None of the above.

Chapter 12: Using the scheduler to Automate Tasks

6. Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all
that apply.)
A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE

12. Which of the following objects can be directly referenced by a window object? (Choose all
that apply.)
A. Schedule object
B. Program object
C. Job object
D. Resource plan
E. Resource consumer group

13. Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A. PLSQL_BLOCK
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL

18. When a job exceeds the date specified in its END_DATE attribute, which of the following will
happen? (Choose all that apply.)
A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP
attribute is FALSE.
D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute
is TRUE and the value of the CASCADE attribute is TRUE.
E. The STATE column of the job table will be set to COMPLETED for the job.