QUESTION 1
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, https://www.pass4itsure.com/1z0-043.html while querying the user1.employees table, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: ‘/u01/app/oracle/oradata/orcl/example01.dbf’
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
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery
Correct Answer: D
QUESTION 2
A database is running in ARCHIVELOG mode. It has two online redo log groups and each group has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of a redo log file and the LGWR terminates causing the instance to crash.
Which method should be used to efficiently recover from this loss of the current group member?
A. Restart the database; it would automatically re-create the corrupted redo log member.
B. Restore the corrupted redo log group, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with RESETLOGS.
C. Restore the corrupted redo log member, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with RESETLOGS.
D. Restore whole database backup, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with the RESETLOGS option.
Correct Answer: D
QUESTION 3
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?
A. the DBNEWID utility
B. the DBVERIFY utility
C. the ANALYZE command
D. the RMAN REPORT command
E. the RMAN CROSSCHECK command
F. the CHECK_OBJECT procedure of the DBMS_REPAIR package
Correct Answer: B QUESTION 4
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation.
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).
Correct Answer: C QUESTION 5
You set the value for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter to 7. Which two records in the control file of the database are circularly reused for storage because of using this parameter? (Choose two.)
A. backup records
B. data file records
C. archive log records
D. tablespace records
E. redo thread records
Correct Answer: AC QUESTION 6
You executed the following command at the command prompt:
$ rman TARGET sys/oracle@ad10g CATALOG rmanusr/rmanusr@as10g SCRIPT backup_whole
Which three statements are true regarding this command? (Choose three.)
A. The backup_whole script is stored in the target database.
B. The backup_whole is a stored script in the recovery catalog.
C. The RMAN session terminates automatically after the execution of the command.
D. The backup_whole script is executed automatically after the successful connection to the recovery catalog only.
E. The command produces an error because the RMAN script cannot be executed from the command line.
F. The backup_whole script is executed automatically after the successful connection to target and catalog database.
Correct Answer: BCF QUESTION 7
You have configured and registered your target database in a recovery catalog. Because the application needs it, you created a new tablespace in the target database. Then you executed the following command from an RMAN session after connecting to the target and catalog databases, both:
RMAN> REPORT SCHEMA;
Which statement describes the operation performed?
A. The target database instance transfers the updated information to the recovery catalog.
B. The command shows the information from the control file of the target database and recovery catalog is synchronized with the target database after the command is executed.
C. The media manager transfers the schema details from the control file of the target database to the recovery catalog.
D. The recovery catalog will be updated by RMAN with the updated information in the control file of the target database and displays information about the database files.
Correct Answer: D QUESTION 8
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two.)
A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.
Correct Answer: DE QUESTION 9
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.
Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two.)
A. drop and re-create the index
B. coalesce the ORDERS_IND index
C. coalesce the INDEXES tablespace
D. drop and re-create the ORDERS table
E. rebuild the index online and move it to another tablespace
Correct Answer: BE QUESTION 10
You lost the index tablespace in your database. https://www.pass4itsure.com/1z0-043.html You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?
A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes.
Correct Answer: E
