Friday, October 26, 2007

[10G] 1Z0-043 example

-> You work as a database administrator at Your database is open and
running in ARCHIVELOGmode. You take RMAN full backups every
Sunday night. On Monday morning, while querying the
user1.employeestable, you receive the following error
01578: ORACLE data block corrupted (file # 5, block # 51)
ORA-01110: data file 5:
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file and all the archived logs are accessible.
Which option would you choose?

A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
F. investigate the time at which the corruption occurred and perform a point-in-time
Answer: D

Because RMAN BLOCKRECOVER can help recovery when Database online(no downtime) and to recover MTTR.

-> You are working on an Oracle Database 10g database. You enabled the Flashback
Database feature. Which two statements regarding flashback logs are true? (Choose
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database.
Answer: A, C

A: Flashback logs aren't archived, B: Flashback log aren't maintained in redo log files, C: Flashback logs are maintained in the Flashback Recovery Area (db_recovery_file_dest), E: Flashback log clear auto after you disable Flashback Database

-> In your production database you want to use an Automatic Storage Management
(ASM) instance to manage the database files.
Which option would you use to migrate the database files from a non-ASM instance
to an ASM instance?
A. Oracle Migration Assistant
B. Recovery Manager (RMAN)
C. Oracle Data Pump Export and Import
D. conventional Oracle Export and Import
E. operating system utilities to copy the files to the ASM instance
Answer: B

RMAN is only solution migrate database file from non-ASM to ASM

-> Using Oracle Scheduler you have scheduled two jobs, JOB_Aand JOB_B, to
run at 9:00 p.m. every Friday. You want both the jobs to
use a single resource plan, WEEKEND_PLAN.
Which task must have already been performed to enable you to achieve this
A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A window group must have been created with the WEEKEND_PLAN resource plan.
Answer: A

windows have used resource plan
job class haven't used resource plan but use resource consumer group

-> You defined the Recovery Manager (RMAN) retention policy to recovery window of
7 days by executing the following command:
When a backup is performed, what would be the status of this backup after seven
A. The backup would be marked as invalid.
B. The backup would be marked as obsolete.
C. The backup would be removed from the media.
D. The backup would be removed from the RMAN repository.
Answer: B

Because "RECOVERY WINDOW OF 7" status after 7 days was only obsolete.

1 comment:

Anonymous said...

-> In your database, all the tablespaces are locally managed. You started Recovery
Manager (RMAN) using recovery catalog and restored the control file by using the
following command:


Which two operations do you need to perform after restoring the control file from
backup? (Choose two.)
A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode
Answer: B, C

If you restore controlfile, you have to add new tempfiles and open database with RESETLOGS

->While designing your database, you have created the EMPLOYEEStable as an
index-organized (IOT). You want to create a bitmap index on
the JOD_IDcolumn to make queries faster.
Which task must have been completed so that you are able to create the bitmap
A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.

Answer: B

If you have an IOT and would like to create a bitmap index, you have to create mapping table