网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

  • A、The backup as copy can only be taken to disk
  • B、The backup as copy can only be taken to tape
  • C、Backup can be performed only when the instance is shutdown
  • D、Backup will constitute all used and unused blocks in the database

参考答案

更多 “You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database” 相关考题
考题 If you want him to () you the money, you have to prove that you will be able to give it back A.giveB.lentC.lendD.borrow

考题 You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

考题 You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?() A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database

考题 You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two). A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database

考题 Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?()A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.

考题 Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

考题 You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?()A、RMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB、RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

考题 You can back up the RMAN recovery catalog with RMAN.()A、 TrueB、 False

考题 In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?()A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager (RMAN) to recover the database

考题 You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 On Jan 11, 2005 at 2:30 P.M., an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator, and you want to return the original values in the table. To do so, you decided to flash back the table. Which two options can you use to flash back a table?()A、 by using Oracle Enterprise ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

考题 You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery

考题 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 online backup,including backing up the  archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

考题 You executed the following command in Recovery Manager (RMAN): RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD、set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database

考题 单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()A  Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB  Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC  Use compression when performing tape backupsD  Configure multiple SBT channels

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A  back up the control file to traceB  bring database to the MOUNT stateC  open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD  set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?()A Place the root container in ARHCHIVELOG mode.B Take the user data tablespace offline.C Place the root container in the nomount stage.D Ensure that HR_PDB is open.

考题 多选题You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

考题 单选题You can back up the RMAN recovery catalog with RMAN.()A  TrueB  False

考题 多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()Abackup of offline tablespacesBbackup of read­only tablespacesCbackup of system­critical tablespacesDbackup of online, locally managed tablespacesEbackup of read/write dictionary­managed tablespaces

考题 多选题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 on in order to complete this task?()ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible

考题 单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?()A Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC Use compression when performing tape backupsD Configure multiple SBT channels

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A You must have change tracking enabled in your databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace, it must be in backup modeD To back up a tablespace, it must first be taken offline

考题 单选题Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A You need to perform the restore and recover operations manually, because the backup was made manually. B First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true?()A  You must have change tracking enabled in your databaseB  Your database must be running in NOARCHIVELOG modeC  To back up a tablespace,it must be in backup modeD  To back up a tablespace,it must first be taken offline