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

Data files of 

题目

Data files of which three tablespaces can be recovered by performing an open recovery？（）

  • A、TEMP
  • B、UNDO
  • C、INDEX
  • D、SYSAUX
  • E、SYSTEM
参考答案和解析
正确答案:A,C,D
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


参考答案：B

第2题：

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

第3题：

You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


参考答案：D

第4题：

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

第5题：

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

第6题：

Your data recovery strategy must meet the following requirements:·Back up all data files and folders in C:\Data.·Restore individual files and folders in C:\Data.·Ensure that data is backed up to and restored from external media.What should you do?（）

A.A

B.B

C.C

D.D


参考答案：D

第7题：

Which  statements are true about checkpointing（）

  • A、The checkpoint frequency decreases with the smaller redo log file size.
  • B、It ensures that all committed data is written to the data files during normal shutdown.
  • C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
  • D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files

正确答案:B,C

第8题：

You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.


参考答案：A, D

第9题：

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

  • A、Only the data files.
  • B、Only the data files and the online logs.
  • C、The data files， control files， and the online logs.
  • D、The data files and control files， but not the online logs.

正确答案:D

第10题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

  • A、Data files that belong to only the root container
  • B、Data files that belong to the root container and all the pluggable databases (PDBs)
  • C、Data files that belong to only the root container and PDB$SEED
  • D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

正确答案:B

更多相关问题
相关内容