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

You database operates in ARCHIVELOG mode and user-managed co

题目
单选题
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）
A

 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.

B

 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.

C

 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.

D

 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

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

第1题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  • A、The database is in mount state.
  • B、One of the tablespaces is offline.
  • C、One of the tablespaces is read only.
  • D、The database operates in ARCHIEVELOG mode. 
  • E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第2题：

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

  • A、The database must be opened in restricted mode.
  • B、The database must be configured to run in ARCHIVELOG mode.
  • C、The tablespaces are required to be in backup mode before taking the backup.
  • D、The tablespaces are required to be in read-only mode before taking the backup

正确答案:B,C

第3题：

You are managing a 24*7 database. The backup strategy for the database is to perform user－managed backups. Identify two prerequisites to perform the backups.()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案：B, C

第4题：

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 SEQUENCE
  • B、 UNTIL SCN
  • C、 UNTIL CHANGE
  • D、 UNTIL CANCEL

正确答案:C,D

第5题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第6题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

  • A、You have to shut down the database to perform the backups.
  • B、Archiving information is written to the data files and redo log files.
  • C、You can perform complete database backups without closing the database.
  • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
  • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

正确答案:C,E

第7题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

  • A、You can perform consistent backups only.
  • B、You can perform a complete database backup without shutting down the database instance.
  • C、You can back up data files only when all data files have the same SCN recorded in the control file.
  • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

正确答案:B,D

第8题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

  • A、The database is in NOMOUNT state.
  • B、The database is in ARCHIVELOG mode and the tablespace is online.
  • C、The database is in ARCHIVELOG mode and the tablespace is offline.
  • D、The database is in NOARCHIVELOG mode and the tablespace is online.
  • E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第9题：

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area （FRA） for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

第10题：

Which is the correct command to put the database in ARCHIVELOG mode？（）  

  • A、 alter database archivelog
  • B、 alter system enable archivelog mode
  • C、 alter database enable archive
  • D、 alter database archivelog enable
  • E、 None of the above

正确答案:A

更多相关问题
相关内容