- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
86.
Choose the correct order to package and upload data for an incident to Oracle Support.
- A.Schedule, create new package, view manifest, view contents
- B.Create new package, view manifest, view contents, schedule
- C.Schedule, create new package, view contents, view manifest
- D.Create new package, view contents, view manifest, schedule
- E.None of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| All other sequences are incorrect. D is the correct sequence. First, create the new package; then view the package contents. Next, view the manifest; then schedule the job to upload the data for the incident to Oracle Support. |
87.
Which of the following is not an advantage of block media recovery (BMR)?
- A.Reduced MTTR.
- B.Data files remain offline while corrupt blocks are repaired.
- C.Data files remain online while corrupt blocks are repaired.
- D.A and C
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Option A is incorrect because reduced MTTR is an advantage of BMR. Option C is incorrect because the data files’ remaining online is an advantage of BMR. Since A and C are advantages, D is also incorrect. |
88.
Which of the following methods can be used to detect block corruption?
- A.ANALYZE operations
- B.dbv
- C.SQL queries that access the potentially corrupt block
- D.RMAN
- E.All of the above
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| Option A is correct because if you attempt to analyze a table or index that has a cor- rupt block, the ANALYZE command will indicate it. Option B is correct because the dbv command (DB Verify utility) is used to verify the data-structure integrity of an offline data file. DB Verify will let you know if the data file fails the integrity check. Option C is correct unless you have used DBMS_REPAIR.SKIP_CORRUPT_BLOCKS to permit queries to skip corrupt blocks. D is correct because the RMAN BACKUP command will detect corruption by default. |
89.
Which of the following are correct about block media recovery? (Choose all that apply.)
- A.Physical and logical block corruption is recorded automatically in V$DATABASE_ BLOCK_CORRUPTION .
- B.Logical corruptions are repairable by BMR.
- C.Physical corruptions are repairable by BMR.
- D.RMAN can use any backup for a BMR restore.
- E.Archive log mode is not required if you have both a full and incremental backup for restore.
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| Option B is incorrect because logical corruptions are not repairable by BMR. Option D is incorrect because you must use a level 0 or full backup for the restore. Option E is incorrect because ARCHIVELOG mode is a requirement for BMR. |
90.
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating
block corruption in File# 1201 and Block# 1968. You analyze the table and the corrup-
tion is verified. Which RMAN command do you use to perform BMR and repair the
corrupt block? (Choose all that apply.)
- A.RECOVER FILE=1201 BLOCK=1968;
- B.RECOVER CORRUPTION LIST;
- C.RECOVER DATAFILE 1201 BLOCK 1968;
- D.RECOVER BLOCK CORRUPTION LIST;
- E.None of the above
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
| Option A is incorrect because the syntax is wrong. Option D is incorrect because BLOCK doesn’t belong. B is how you recover all corrupt blocks listed in V$DATABASE_BLOCK_ CORRUPTION . C is the correct syntax to recover just the one block that you’ve identified as corrupt. |
|
|
||||||||||||||||||||||||||||
