In user-managed backup and recover procedures, how are data 

题目
单选题
In user-managed backup and recover procedures, how are data files backed up? ()
A

Using SQL commands.

B

Using SQL*Plus commands.

C

Using operating system commands.

D

Using Recover Manager commands.

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

第1题:

The IBM System Storage TS7650 ProtecTIER Appliance and Gateway solution is designed toaddress which customer requirement?()

  • A、latency across a long distance network 
  • B、high-speed backup of large video files 
  • C、increase levels of data protection with enterprise class data integrity 
  • D、improve backup and recovery operations without changing existing backup processes,procedures or policies

正确答案:D

第2题:

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 used in the user-managed recovery process performed by the database administrator (DBA)?() 

  • A、 redo logs
  • B、 control file
  • C、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第3题:

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure


参考答案:A, C, F

第4题:

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()

  • A、The database will open, and the tablespace automatically comes out of the backup mode
  • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
  • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
  • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

正确答案:C

第5题:

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

第6题:

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()

  • A、 V$BACKUP_CORRUPTION
  • B、 V$COPY_CORRUPTION
  • C、 V$DATABASE_BLOCK_CORRUPTION
  • D、 RC_BACKUP_CORRUPTION

正确答案: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题:

Which of the following allows an administrator to recover the MOST data?()

A. System image

B. Incremental backup

C. System state restore

D. Differential backup


参考答案:A

第9题:

For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()

  • A、 RMAN image copies.
  • B、 RMAN database backups.
  • C、 RMAN tablespace backups.
  • D、 User-managed backups placed in the flash recovery area.
  • E、 User-managed backups that have been cataloged with RMAN.
  • F、 User-managed data file backups for which the pull path name is specified.

正确答案:A,B,C,E

第10题:

单选题
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


正确答案: A
解析: 暂无解析

更多相关问题