CMS专题

单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 tablesp

题目
单选题
Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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题:

For which database operation would you need the database to be in the MOUNT state()

  • A、renaming the control files
  • B、re-creating the control files
  • C、dropping a user in your database
  • D、dropping a tablespace in your database
  • E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

正确答案:E

第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题:

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

  • A、 backup database all
  • B、 backup compressed database
  • C、 backup as compressed backupset database
  • D、 backup as compressed backup database plus archivelog all
  • E、 backup as compressed backupset database plus compress archivelog all

正确答案:C

第5题:

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

第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题:

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

第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题:

Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()

  • A、ARCHIVELOG mode.
  • B、NOARCHIVELOG mode.
  • C、Open database backups.
  • D、Consistent whole backups.

正确答案:A,C

第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

更多相关问题