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

Data files of which three tablespaces can be recovered by pe

题目
多选题
Data files of which three tablespaces can be recovered by performing an openrecovery？（）
A

TEMP

B

UNDO

C

INDEX

D

SYSAUX

E

SYSTEM

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

第1题：

Examine these two statements:Which three are true about the MRKT tablespace?()

A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B. The MRKT tablespace may be dropped if it has no contents.

C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D. No more data files can be added to the tablespace.

E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.


参考答案：B, C, D

第2题：

The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）

  • A、data files
  • B、backup sets
  • C、control files
  • D、archived redo log files

正确答案:A,B,D

第3题：

Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案：A, B

第4题：

Which three statements are true about the stages of database startup？（）

  • A、Data files and redo log files can be renamed at the MOUNT stage.
  • B、Control files are read at the OPEN stage for the location of data files.
  • C、Control files are required to bring the database to the NOMOUNT stage.
  • D、Data files and redo log files are made available to users at the OPEN stage.
  • E、Data files and online redo log files are checked for consistency while opening the database

正确答案:A,D,E

第5题：

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

  • A、The data files of the read-only tablespaces in the target database are not duplicated
  • B、The read-only tablespaces in the target database are still defined in new the database
  • C、The read-only tablespaces in the target database are changed to online after duplication
  • D、The data files of the read-only tablespaces in the target database get duplicated
  • E、The read-only tablespaces in the target database are not defined in the new database

正确答案:A,B

第6题：

Which two statements correctly describe the relation between a data file and the logical databasestructures（）

  • A、An extent cannot spread across data files.
  • B、A segment cannot spread across data files.
  • C、A data file can belong to only one tablespace.
  • D、A data file can have only one segment created in it.
  • E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

正确答案:A,C

第7题：

Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

  • A、The data files can be recovered till the last committed transaction.
  • B、The data files can be recovered without shutting down the database.
  • C、The data file is taken offline automatically; the database remains open.
  • D、The data files can be recovered to the time of the most recent backup.

正确答案:A

第8题：

Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.


参考答案：B, C

第9题：

Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

  • A、 The user has dropped an important table that needs to be recovered.
  • B、 The database files are corrupted when the database is open.
  • C、 You are not able to start up the database instance because the required database files are missing.
  • D、 The archived log files are missing for which backup is not available.

正确答案:B,C

第10题：

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

  • A、The data files can be recovered till the last committed transaction.
  • B、The data files can be recovered without shutting down the database.
  • C、The data file is taken offline automatically； the database remains open.
  • D、The data files can be recovered to the time of the most recent backup.

正确答案:A

更多相关问题
相关内容