- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
1.
What are the different archiving modes available in the Oracle Database? (Choose all that apply.)
- A.LOGGING mode
- B.NOLOGGING mode
- C.ARCHIVELOG mode
- D.ARCHIVING mode
- E.NOLOGFILE mode
- F.NOARCHIVELOG mode
- G.RECOVERY mode
- Answer & Explanation
- Report
Answer : [C, F]
Explanation :
Explanation :
| The two logging modes that are available in Oracle are NOARCHIVELOG mode—which is the default—and ARCHIVELOG mode. In NOARCHIVELOG mode, the database does not create archived redo logs, and as a result the recovery options are fewer. In ARCHIVELOG mode, the database creates archived redo logs and this results in a much larger number of options. |
2.
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users
complain that they don’t want you to shut down the database to perform the backup.
What options are available to you?
- A.Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.
- B.Just back up the database data files without shutting down the database.
- C.You will have to wait until you can shut down the database to perform the backup.
- D.Mark each data file as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.
- E.Back up only the data files that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the data files the user changed during the course of the remaining backup.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You will have to wait until you can shut down the database since it’s in NOARCHIVELOG mode. No other option will give you a backup that is recoverable. |
3.
Your database backup scripts keep failing on the ALTER TABLESPACE BEGIN BACKUP
command. Your junior DBA informs you that the failure is because the database is in
ARCHIVELOG mode. Is he correct?
- A.Yes
- B.No
- C.There is insufficient information to decide the answer to this question.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The database should be in ARCHIVELOG mode. |
4.
What parameter is used to tune instance recovery in Oracle Database 12c?
- A.INSTANCE_RECOVERY_TIME
- B.FAST_START_RECOVERY_TIME
- C.FAST_MTTR_RECOVERY
- D.FAST_START_MTTR_RECOVERY
- E.None of the above
- Answer & Explanation
- Report
Answer : [B, E]
Explanation :
Explanation :
| B and E are the correct answers because ARCHIVELOG and NOARCHIVELOG are the two logging modes available in Oracle Database 12c. |
5.
Which files do you need to back up for a database that is in ARCHIVELOG mode to
ensure recovery? (Choose all that apply.)
- A.Database data files
- B.Online redo logs
- C.Archived redo logs
- D.Backup control file
- E.Control file from a backup
- Answer & Explanation
- Report
Answer : [A, C, D]
Explanation :
Explanation :
| A backup of any database in ARCHIVELOG mode should include the database data files (after they are put in backup mode), the archived redo logs, and the database control file. |
|
|
||||||||||||||||||||||||||||
