当前分类: 1Z0-053
问题:单选题You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()A A base catalog existsB ...
查看答案
问题:Which of the following is a potential performance tuning rec...
问题:单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed o...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:多选题You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation o...
问题:单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corru...
问题:多选题Which two statements are true about encrypting RMAN backup?()AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the passwor...
问题:多选题Using the LIST command in Recovery Manager (RMAN),which two pieces of information in the RMAN repository can be listed?()Astored scripts in the recovery catalogBbackups that can be deleted from diskCbackup sets and image copies are obsoleteDbackups tha...
问题:多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()AThe command restores only th...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:多选题Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be...
问题:单选题Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont 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 ...
问题:单选题Which mode of database shutdown requires an instance recovery at the time of the next database startup?()A ABORTB NORMALC IMMEDIATED TRANSACTIONAL...
问题:单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to...
问题:单选题You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using ...
问题:单选题To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace. W...
问题:单选题You run the following commands: RMAN list expired backup; RMAN delete expired backup; What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()A They will be renamed.B Nothing will hap...
问题:单选题What is the net effect of the following command?() alter diskgroup dgroup1 drop disk abc;A The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command,the data on that disk will be lost.B The command will raise an ...
问题:To set the history retention period for either window loggin...
问题:单选题Which of the following commands will fail?()A report schemaB report need backupC report need backup days 3D report userE report obsolete...