Home
  • Home
  • Database
  • Oracle Database 11g Administrator Certified Professional (OCP)
61.
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 :
Block-change tracking must be enabled with alter database enable block change tracking. The physical location and name of the block-change tracking file must be supplied.
Report
Name Email  
62.
What type of backup is stored in a proprietary RMAN format?
  • A.
    Backup set
  • C.
    Backup section
  • B.
    Image copy
  • D.
    Backup group
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
The backup set is stored in a proprietary RMAN format, where only used blocks are backed up.
Report
Name Email  
63.
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.
  • A.
    1
  • C.
    3
  • E.
    5
  • B.
    2
  • D.
    4
  • Answer & Explanation
  • Report
Answer : [D]
Explanation :
The following backup sets would be created:
  • One for an archive log backup b NN efore 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.
Report
Name Email  
64.
Which command creates an image copy?
  • A.
    backup as copy
  • C.
    copy as backup
  • B.
    backup copy
  • D.
    copy back
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
The backup as copy command is used to create an image-copy backup.
Report
Name Email  
65.
Compressed backups work with which of the following commands?
  • A.
    copy as backup
  • C.
    backup
  • B.
    backup as copy
  • D.
    copy
  • Answer & Explanation
  • Report
Answer : [C]
Explanation :
Compressed backups work only with backup sets, not image copies. Thus, compressed backups will work only with the backup command.
Report
Name Email