- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
26.
Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?
- A.BACKUP DATABASE
- B.BACKUP DATABASE AND ARCHIVELOGS
- C.BACKUP DATABASE PLUS ARCHIVELOGS
- D.BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT
- E.BACKUP DATABASE AND ARCHIVELOG DELETE INPUT
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The correct answer is to use the BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT command. |
27.
Which of the following best describes a full backup?
- A.All data files of a database
- B.All data files, archive logs, and control files
- C.All data files and control files
- D.All the used blocks in a data file
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| A full backup is best described as backing up all the used blocks in a data file or any database file. A full backup can be taken on one database file. |
28.
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?
- A.Differential incremental backup
- B.Different incremental backup
- C.Cumulative backup
- D.Cumulative incremental backup
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| A differential incremental backup backs up only blocks that have been modified since a backup at the same level or lower. |
29.
Which type of backup must be performed first with an incremental backup?
- A.Level 1
- B.Level 0
- C.Level 2
- D.Level 3
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| A level-0 backup is the first backup that is performed when implementing an incremental backup strategy. A level-0 backup copies all the used blocks as a baseline. |
30.
Which backup option defines a user-defined name for a backup?
- A.FORMAT
- B.NAME
- C.TAG
- D.FORMAT U%
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The TAG option is used to name a backup with a user-defined character string. |
|
|
||||||||||||||||||||||||||||
