You have configured your database to use RMAN for backup and

题目
单选题
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()
A

 The command generates an error.

B

 The command backs up the tablespace and creates a backup set of size 200 MB

C

 The command backs up the tablespace and creates two backup sets of size 100 MB each.

D

 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第2题:

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 the RMAN CONFIGURE command to achieve this?()  

  • A、 MAXSETSIZE TO 2
  • B、 DEVICE TYPE DISK PARALLELISM 2
  • C、 RETENTION POLICY TO REDUNDANCY 2
  • D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

正确答案:C

第3题:

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. 

正确答案:C

第4题:

You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()

  • A、 target database
  • B、 auxiliary database
  • C、 third-party database
  • D、 recovery catalog database

正确答案:C

第5题:

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()  

  • A、 register database
  • B、 recover catalog
  • C、 load backupset
  • D、 synch metadata
  • E、 catalog start with

正确答案:E

第6题:

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()

  • A、cannot be used in RMAN
  • B、by starting up the database again
  • C、by using the CATALOG command of RMAN
  • D、by using the RECOVER CATALOG command in RMAN
  • E、by re-creating the target control file to rebuild the RMAN repository

正确答案:C

第7题:

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()

  • A、Database Datafiles 
  • B、Database Control Files 
  • C、Online redo logs
  • D、Archived redo logs 
  • E、The database SPFILE 
  • F、None of the above, all these files are backed up. 

正确答案:C

第8题:

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?()

  • A、backup of offline tablespaces
  • B、backup of read­only tablespaces
  • C、backup of system­critical tablespaces
  • D、backup of online, locally managed tablespaces
  • E、backup of read/write dictionary­managed tablespaces

正确答案:A,B

第9题:

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 / NOCATALOG
  • B、 rman TARGET sys/password
  • C、 rman TARGET sys/password AS SYSDBA
  • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

正确答案:B

第10题:

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()

  • A、 RMAN would use the current operating system location to place the backup.
  • B、 RMAN would use the control file of the target database to maintain the backup.
  • C、 RMAN would use the recovery catalog of the target database to maintain the backup.
  • D、 RMAN would use the control file of the target database to maintain the backup metadata.
  • E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

正确答案:D

更多相关问题