单选题You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome

题目

单选题

You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？（）

The statement will not execute successfully.

The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

Backups will be deleted from the media after 400 days.

参考答案和解析

正确答案： C

解析：暂无解析

更多“You are maintaining your database in Oracle10g. You want to ”相关问题

第1题

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）A、DatafilesB、 Current control fileC、 Server parameter file （spfile）D、 Password file

点击查看答案
第2题

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A、 redo log filesB、 password fileC、 control fileD、 change tracking file

点击查看答案
第3题

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL

点击查看答案
第4题

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace

点击查看答案
第5题

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility

点击查看答案
第6题

You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？（）A、 The statement will not execute successfully.B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.

点击查看答案
第7题

单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）AVERSIONS_STARTSCNBVERSIONS_STARTTIMECVERSIONS_XIDDVERSIONS_OPERATION

点击查看答案

You are maintaining your database in Oracle10g. You want to

题目

参考答案和解析

更多“You are maintaining your database in Oracle10g. You want to ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容