- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
21.
How is block-change tracking enabled?
- A.With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
- B.With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
- C.With an init.ora parameter change
- D.With an spfile parameter change
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The backup set is stored in a proprietary RMAN format, where only used blocks are backed up. |
22.
What type of backup is stored in a proprietary RMAN format?
- A.Backup set
- B.Image copy
- C.Backup section
- D.Backup group
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The backup set is stored in a proprietary RMAN format, where only used blocks are backed up. |
23.
Consider the following command:
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
-> Control-file auto backups were enabled.
-> The size of backup sets was not restricted.
-> One channel was allocated.
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
-> Control-file auto backups were enabled.
-> The size of backup sets was not restricted.
-> One channel was allocated.
- A.1
- B.2
- C.3
- D.4
- E.5
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
|
The following four backup sets would be created: One for an archive log backup before the main backup. One for the main backup. Since we are using a single channel with no backup-set size restriction, RMAN would create a single backup set. One for an archive log backup after the main backup. One for the control-file autobackup. |
24.
Which command creates an image copy?
- A.BACKUP AS COPY
- B.BACKUP COPY
- C.COPY AS BACKUP
- D.COPY BACK
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The BACKUP AS COPY command is used to create an image-copy backup. |
25.
Compressed backups work with which of the following commands?
- A.COPY AS BACKUP
- B.BACKUP AS COPY
- C.BACKUP
- D.COPY
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Compressed backups work only with backup sets, not image copies. Thus, compressed backups will work only with the BACKUP command. |
|
|
||||||||||||||||||||||||||||
