66.
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. |
67.
Which of the following best describes a full backup?
- A.All datafiles of a database
- B.All datafiles, archive logs, and control files
- C.All datafiles and control files
- D.All the used blocks in a datafile
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| A full backup is best described by backing up all the used blocks in a datafile or any database file. A full backup can be taken on one database file. |
68.
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. |
69.
Which type of backup must be performed first with an incremental backup?
- A.Level 1
- C.Level 2
- B.Level 0
- 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. |
70.
Which backup option defines a user-defined name for a backup?
- A.FORMAT
- C.TAG
- B.NAME
- 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. |
|
|
||||||||||||||||||||||||||||
