违法和不良信息举报 联系客服
免费注册 登录

You are ready to implement RMAN in the backup and recover st

题目
单选题
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
A

SYSDBA

B

SYSOPER

C

No system privileges are required for the RMAN user.

D

Only SYS user can connect and execute RMAN commands on a target database.

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

第1题：

When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

  • A、Until SCN
  • B、Until time
  • C、Until cancel
  • D、Recover using backup control file.

正确答案:C

第2题：

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

第3题：

Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）

A. Implement RMAN multiplexing

B. Set the DEBUG ON in the RMAN script

C. Specify the command ID in the RMAN script

D. Use a tag with the RMAN BACKUP command


参考答案：C

第4题：

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

第5题：

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 MB
  • B、The RMAN uses multiplexing to perform backup
  • C、The operation is accomplished using the default channel available
  • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

正确答案:A,C

第6题：

As A DBA， which of the following methods can you use to make a backup of your table？（）

  • A、Recover Manager （RMAN） utility
  • B、Import utility
  • C、Export utility
  • D、O/S backup command

正确答案:C

第7题：

In which scenario will you perform a cancel-based recovery？（）

  • A、 when a tablespace is dropped and you have only RMAN-based backup of the database
  • B、 when a table is dropped and stored in the Recycle Bin
  • C、 when you are required to recover an existing table to its previous state
  • D、 when a tablespace is dropped and you have only a user-managed full backup of the database

正确答案:D

第8题：

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）

  • A、Mount the container database (CDB) and restore the control file from the control file auto backup.
  • B、Recover and open the CDB in NORMAL mode.
  • C、Mount the CDB and then recover and open the database, with the RESETLOGS option.
  • D、Open all the pluggable databases.
  • E、Recover each pluggable database.
  • F、Start the database instance in the nomount stage and restore the control file from control file auto backup.

正确答案:C,D,F

第9题：

The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

  • A、The data file cannot be recovered.
  • B、The date file can be restored from theSYSTEMauto backup.
  • C、Take thetablespaceoffline，drop，kand re-create it.
  • D、Recovery Manager （RMAN） is used to recover the data file.
  • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

正确答案:A

第10题：

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

更多相关问题
相关内容